charts and pivot tables

[Tuxla]

I update a table in excel (2003) each month, showing year to date data.
I need to pivot the data into many pivot tables then create charts (I don't
want to use a pivot chart for cosmetic reasons).
Because it is year to date, I would like the charts to automatically update
each time I add a new month (date is on the X axis).
At the moment I change the source data each month for each chart to include
the new month, but I was hoping someone could tell me an easier way of doing
this.
Thank you

 

[Jon Peltier]

You could use the utility I mentioned in your other post:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

Also, you can set up dynamic ranges that include pivot table data, and use
them to create dynamic charts:

http://peltiertech.com/WordPress/2008/04/24/dynamic-chart-using-pivot-table-and-range-names/
http://peltiertech.com/WordPress/2008/05/14/dynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon

 

[Tuxla]

thank you

You could use the utility I mentioned in your other post:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

Also, you can set up dynamic ranges that include pivot table data, and use
them to create dynamic charts:

http://peltiertech.com/WordPress/2008/04/24/dynamic-chart-using-pivot-table-and-range-names/
http://peltiertech.com/WordPress/2008/05/14/dynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______