Thread: Pivot Charts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default 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