plot graph without blank values

[nielsb]

Hi there,

I?m trying to obtain a plotted graph from a dynamic range (attached file, tab "SELECT") which is derived from another tab (tab "INPUT".
The cells with ?? as value (e.g. H19) are plotted by Excel as 0, whereas I want Excel to neglect them (not plotted in the graph).

Deleting the formula from the cells would do the trick, but I don?t want that as the graph need to be used for dynamic inputs

Does anybody know how to overcome this?

Kind regards,
Niels

[TMS]

One way:

Please Login or Register  to view this content.

copied across.

Are you still using Excel 2010? If you have upgraded to a much newer version, there may be neater options.

[nielsb]

Thanks Forum guru, your formula helps out well..
However I was hoping for a formula to be inserted in the graph data selection box that would seek (dynamically) range of cells that have a value..


Is there such a solution?

[TMS]

However I was hoping for a formula to be inserted in the graph data selection box that would seek (dynamically) range of cells that have a value..

I'm not sure what you mean by that.

[nielsb]

@ Forum guru.. never mind.. Your first answer helps out fine. Thanks again!

[TMS]

You're welcome.



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.