| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic update for graph data
I have a graph with data for this year and last year by month. The data for
last year by month has already been pre-populated and the data for this year is added each month when it is available. Every month when I add the data for this year, I have to manually expand the data range for last year so that my year to date comparisons are kept in parity. Is there a way to update the data range for last years data automatically when I add the data for the new month this year? Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic update for graph data
Hi JRJ,
Use a dynamic range, have a look at http://pubs.logicalexpressions.com/P...cle.asp?ID=518 -- Hope this helps, MarkN "JRJ" wrote: I have a graph with data for this year and last year by month. The data for last year by month has already been pre-populated and the data for this year is added each month when it is available. Every month when I add the data for this year, I have to manually expand the data range for last year so that my year to date comparisons are kept in parity. Is there a way to update the data range for last years data automatically when I add the data for the new month this year? Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dynamic update for graph data
Perfect. Thanks for the help!
"MarkN" wrote: Hi JRJ, Use a dynamic range, have a look at http://pubs.logicalexpressions.com/P...cle.asp?ID=518 -- Hope this helps, MarkN "JRJ" wrote: I have a graph with data for this year and last year by month. The data for last year by month has already been pre-populated and the data for this year is added each month when it is available. Every month when I add the data for this year, I have to manually expand the data range for last year so that my year to date comparisons are kept in parity. Is there a way to update the data range for last years data automatically when I add the data for the new month this year? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
| Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Hybrid Mode
