macro

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
tag: 
code
excel
macro
pivot table
charts
Subscribe to RSS - macro