Pivot Charts
Don't copy it but create the 2nd, 3rd etc chart(s) as you did the first one.
If you do this I think you will find that it will work.
Please hit yes if my comments have helped.
Thanks.
"The Rook" wrote:
Morning,
I am wanting to create several pivot charts from the same source but for
different months. I have already tried to achieve this but if I create 1
chart then copy it and then try and us the pivot chart filter box to change
the month it changes both charts.
How can I create several charts using the same data.
I want to be able to place these on one worksheet so they can be printed on
one page
|