Excel 2007 graphs/charts automatically populate with new data
I am working with multiple charts in Excel 2007. The charts are
filled in with pivot table data.
Every time a new month is added, the data is located one column to the
right of the old data.
In order for me to add the new month, I have to go manually into each
chart, add a new month,
and up the range to the corresponding columns.
How can I get Excel to automatically find the data in the pivot table,
and increase the range so it
populates the graph with the new month name and data? Please detail
how to do this.
- Re: Pivot Table in Mac 08 ==corrupted file==> MS office 07
... Do you have any Mac tools to repair corrupted files? ... problem when opening in Windows Excel. ... the charts and pivot tables intact as much as possible and save out the file ...
- Re: Dates in Excel 2007 graph axis dialogs - thanks
... always consistent and line charts won't work. ... Jon Peltier, Microsoft Excel MVP ... Line Chart: X as Time-Scale Axis ...
- printing chart with more than 2709 points
... I am having the same problem with charts in Excel 2007. ... I'm printing charts in excel. ... preview shows the scatter points. ...
- Re: Need help with SeriesCollection Object Please !
... Well Peter your explanation of my questions make sense and are sound answers. ... You seem very experienced with Excel and VBA:) ... Function GetSourceSheet(sFmla As String, sWSname, sFile As String) As ... ran my code on certain other charts sometimes it would return ...
- Re: Help with Charting My Data --
... > Pivot tables are the way to go with your data. ... 99.9% of the charts I make from pivot tables are standard charts. ... No matter, Excel will update that readily enough, and the output table is ideal ... >> my query to only display the exact information that I'm trying to chart? ...