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

Example.png
Nick's picture

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