How to exclude cells from a datasource?

  • Thread starter Thread starter Bart
  • Start date Start date
B

Bart

Hi,
I have an XY chart in excel97 that uses a range of cells
for the data source.
Every now and then I would like to exclude a XYnode from
the chart. Without having to reselt the datasource.

Is there a value one can enter in the cell that exludes it
from the graph (compare: putting text in a cell excludes
it from the SUM() function).

For example
point X Y
a 1 1
b 2 2
c 3 3

Gives a graph with two lines connecting the three points

While
point X Y
a 1 1
b ? ?
c 3 3

Should give a graph with one line connecting point a and c.
Point b is left out.

Or is there an other way to work around this?

Thanks

Bart
 
Hi,
I have an XY chart in excel97 that uses a range of cells
for the data source.
Every now and then I would like to exclude a XYnode from
the chart. Without having to reselt the datasource.

Is there a value one can enter in the cell that exludes it
from the graph (compare: putting text in a cell excludes
it from the SUM() function).

For example
point X Y
a 1 1
b 2 2
c 3 3

Gives a graph with two lines connecting the three points

While
point X Y
a 1 1
b ? ?
c 3 3

Should give a graph with one line connecting point a and c.
Point b is left out.

Or is there an other way to work around this?

Thanks

Bart
Click to expand...

Try putting the =NA() function in the cell to return the #N/A error. Now
select the chart, go to the menu and click Tools | Options | Charting tab
| Plot empty cells as... interpolated.
 
-----Original Message-----


Try putting the =NA() function in the cell to return the #N/A error. Now
select the chart, go to the menu and click Tools | Options | Charting tab
| Plot empty cells as... interpolated.
Click to expand...

THANKS!
 
Back
Top