Pivot Charts

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
 
T

trip_to_tokyo

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

Roger Govier

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

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
T

The Rook

I have 2007.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top