This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
This article addresses the need, sometimes extreme, for a legend that may not be easy to create, depending on the features of conditional formatting you have used. Almost all spreadsheets need some sort of legend.
Listing and selecting time zones in Microsoft Access and Excel is not straight forward. In the previous article was shown how to retrieve the time zones of Windows. Here will be demonstrated how to create tables to store these and how to display and…