LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default How do I set up formulas to update graphs dynamically

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically update graphs ChrisG Charts and Charting in Excel 25 February 12th 07 05:29 PM
How do I update graphs automatically with periodic data updates Infinitejest Charts and Charting in Excel 2 October 28th 06 09:02 PM
embedded presentation graphs in excel don't update, tables do sid Excel Worksheet Functions 0 October 4th 06 02:20 PM
excel graphs won't update ejfu Charts and Charting in Excel 0 July 6th 06 11:18 PM
Graphs in Other Files do not Update Dolphinv4 Excel Discussion (Misc queries) 0 October 21st 05 10:38 AM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"