Pivot Charts

  • Thread starter Thread starter The Rook
  • Start date Start date
T

The Rook

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
 
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.
 
Hi

You need to have a separate Pivot Cache for each chart.
Depending upon which version of XL you have, the instructions are different.

If you don't know how to do this, post back with the version you are using.

--
-------
Regards
Roger Govier

The Rook said:
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

__________ Information from ESET Smart Security, version of virus
signature database 4873 (20100217) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4873 (20100217) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
I have 2007.

If I have a different cache does that mean I will have 12 pivot tables as
well as 12 charts?
 
Back
Top