Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello,
I have the following information I need to graph date Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 burn 116 23 254 inventory 3035 3011 2757 The "date" is the x-axis label and the "burn" and "inventory" are the values on the y-axis. If the values for burn and inventory are blank for a particular date, I don't want the information plotted. As I add values for each date, I would like the graph to be updated automatically. I understand I need to define a named range and use it in the graph, however, I have not been successful in doing this. Also, even though the data is blank, there is still a formula there and I want to make sure that does not cause any problems. thanks in advance for your help, OS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically update graphs | Charts and Charting in Excel | |||
How do I update graphs automatically with periodic data updates | Charts and Charting in Excel | |||
embedded presentation graphs in excel don't update, tables do | Excel Worksheet Functions | |||
excel graphs won't update | Charts and Charting in Excel | |||
Graphs in Other Files do not Update | Excel Discussion (Misc queries) |