For several examples see
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html


On Mon, 4 Aug 2008 16:43:56 -0700 (PDT), wrote:

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

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products