| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I update graphs automatically with periodic data updates
I am trying to use a data source of 52 weeks of information that I update on
a weekly basis. I can't figure out how to have the graph display blank cells on the graph as blank instead of "0." My graph looks great right up to the first blank cell and then the graph plumets to "0". I would like the graph to just end where the data in the cells ends, and automatically pickup the new information as I enter each week. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked data tables wont update automatically | Excel Discussion (Misc queries) | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
| Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions | |||
Threaded Mode
