Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot charts & tables | Charts and Charting in Excel | |||
Pivot tables Charts | Excel Discussion (Misc queries) | |||
Pivot Tables/Charts | Charts and Charting in Excel | |||
Pivot Tables and Charts | Charts and Charting in Excel | |||
Pivot Charts / Tables | Excel Worksheet Functions |