Problem with graphing

Hi,

Im using this excel sheet to put in new data in the red marked part of the left picture everyday and I want the graph to show my day to day progress without changing the data field every time I enter in new data. The problem is that the blank cells are causing the graph to go down to zero... How do I avoid this problem?

Here is the picture of the problem: asd.png

Thanks in advance!

I can't read png files. Ideally, upload an Excel file so we can see your formatting, your series, etc. That will get you the most specific help. Sounds like you want to work with dynamic named ranges. See if this helps

http://chandoo.org/wp/2009/10/15/dyn...t-data-series/