I have one mod. that needs to be made here. Right now it looks at "active cell" for a double click to produce the checkmark. I need it to look at A SPECIFIC CELL. In the case of the example attached, it needs to look at "Sheet1, Cell C4".
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.