Graphing Help

[Hazzard County]

I have created a graph in excel. Sheet one contains the information and sheet 2 the graph. I have the potential to have 10 data entries to be graphed; however, it will take 10 weeks to get all 10 data entries. The graph will be printed periodically within the 10 weeks. If I only have 4 data entries points the graph drops off at data entry 5 down to zero. Is there a way to only graph valued data entries and remove the dropoff to the zero where no data has been entered yet?

 

[VoG]

Hello and welcome to MrExcel.

This may help you http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html