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
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 _______ "Tuxla" wrote in message news:6C28C9F9-9FCE-4040-8EE6-CBB1EF3239DD@microsoft.com... >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 > > >
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/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 > _______ > > > "Tuxla" wrote in message > news:6C28C9F9-9FCE-4040-8EE6-CBB1EF3239DD@microsoft.com... > >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 > > > > > > > > >
