Having a Chart ignore blanks

[slam]

I'll start by saying I'm not good with charts in or outside of excel, so I hope I'm explaining this accurately.

I have a line chart that I want to ignore blanks from =IF(ISBLANK(),"",) formulas

It's plotting from the range AF2:AY37. AF and row 2 are the X and Y axis respectively, so AG3:AY37 is the data to be plotted.

There is currently only data in columns AF and AG, and in rows 3 through 18. How can I have it ignore the other cells?

For instance, the first value for one line to be plotted is 25, the second is 50, but with the third column being blank, its treating it like a 0. I just want the line to stop on the graph until the next value is entered/calculated.

 

[slam]

Sorry, I don't know how to hide a legend entry apart from maybe having as formula in the cell with the legend text

=IF(COUNT(AF3:AF37=0,"","My Legend")

Could you elaborate on how/where to use that please?

 

[VoG]

Thinking about it more, that won't work because the legend symbol would still appear without a (visible) series title.

 

[slam]

Do you think this would work if I could figure out how to apply it to my worksheet?

http://www.ozgrid.com/forum/showthread.php?t=35755&page=1

 

[VoG]

It might...

Your question is now different to your original one so you could start a new thread about how to hide a legend entry and hope that someone like Andy Pope spots it.

 

[slam]

Will do. Thanks for all your help. Good progress on the problem so far.