Line Graphs to not include blanks

[reaper985]

Good afternoon,

I have data ranging from January 2013 to December 2013

Entries have only been entered for January, Feburary and March...the rest are blank

I want to have a line graph which live updates itself, but when it goes to a blank Month cell - it should not go down to zero.

Can anyone help me with this?

Help would be much appreciated

regards

 

[BAlGaInTl]

Instead of blanks, you can put the following in the cells

=NA()

Then it should not plot...

If you want to, you can also plot a helper column instead.... something like

=IF(A1,A1,NA())

Where you would be entering your data in column A, but plotting the formula above...

 

[reaper985]

Thats great,

Thankyou