Generate a chart per item in a filter of a pivot table
Hi Experts,
I would like to create multiple graphs (one for each item of a pivot table filter), without the annoyance of generating a pivot for each chart. If the chart data update with the pivot table and/or it is possible to automatically generated the array of chart is a huge bonus.
The following image tries to illustrate what I'm talking about :)
Thanks in advance,
Fdiang
2 main options: 1. pivot for
2 main options:
1. pivot for each chart
2. VBA to produce custom views
if you don't know VBA, go for 1.
- it's not a big overhead as if you copy and paste the pivot, it shares the cache and updates when the pivot is refreshed on any other pivot sharing the same cache