I got a question about ways to clean up the following..
someone has entered Mc Donald instead of McDonald or MacDonald. Or someone enters O Brien instead of O'Brien....is there a way to tidy up the data in Excel to the desired format? Thanks :-)
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.