charts and pivot tables
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 |
charts and pivot tables
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/200...d-range-names/ http://peltiertech.com/WordPress/200...ynamic-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 _______ "Tuxla" wrote in message ... 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 |
charts and pivot tables
thank you
"Jon Peltier" wrote: 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/200...d-range-names/ http://peltiertech.com/WordPress/200...ynamic-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 _______ "Tuxla" wrote in message ... 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 |
All times are GMT +1. The time now is 02:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com