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.

"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

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" wrote in message
...
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

I have 2007.

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

"Roger Govier" wrote:

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" wrote in message
...
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