Excel Charts to Pivot Tables

Ok, as you know you can double click a value on a pivot table to see the data details but what if you click on a chart?
Since it is a collection of all the data, you can’t see the data behind it, however this macro code will allow you to go to the pivot table driving the chart.

Read More
Subscribe to RSS - macro