Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Graph Data
Is there a way to refresh a graph's data? I am trying to graph total loans
by month and starting with November. I want to add next month's without having to create a new graph... is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Graph Data
Karen wrote:
Is there a way to refresh a graph's data? I am trying to graph total loans by month and starting with November. I want to add next month's without having to create a new graph... is this possible? ----------------- The technique I use is to put a colored row of cells at the bottom of the data with the message "Insert new rows above this line". Include that line in your plot data range. Then when you want to add a new row of data you Insert a row above the colored bar and Excel knows to include it in your chart automagically. There are "better" techniques, but I find this one to be dead simple and it's what I choose to use. Good luck... Bill |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Graph Data
Hi Karen. I do the same thing with Total Revenue" for each month. What I
did was create the data table with all 12 months and then just fill in the data when it's received. The months show up on the X-Axis, but the chart is blank until the data is entered. Once entered the chart updates automatically. HTH -- Sincerely, Michael Colvin "Karen" wrote: Is there a way to refresh a graph's data? I am trying to graph total loans by month and starting with November. I want to add next month's without having to create a new graph... is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Data Table - Graph Links Breaking!!! | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |