Muliple Charts from one Pivot Table

[TJonesEsq]

I am trying to produce multiple individual charts from one pivot table.
The change will be when the first column changes ie store number. If i
just look at the associated chart for the pivot table it is just a mass
of black. I would appreciate any tips please.

Many thanks in advance

 

[Debra Dalgleish]

If you create multiple pivot charts from a pivot table, they'll all look
the same -- if you change one chart's layout, they'll all change to the
same layout.

You could move store number to the page area of the pivot table, and the
chart may be easier to read. From the store number item list, choose a
store number to see only its data.