graphing data only in a certain range

[Soccerboy83]

I am trying to create a graph using data from my table, now some of my data
has blank cells, however they are blank because the formula i am using tells
it to be blank, i.e. if (a4<10,"",a4). however when i graph this data it
graphs it as a zero value. Is there a way to omit this data from my graph,
i have already tried going to the chart option table and selecting plot empty
cells as NOT PLOTTED but i think that only applies is there is no formula in
the cells. can someone please help me out, or at least point me in the right
direction.

 

[Jeff in GA]

I've encountered this before. I don't believe there is an "automatic"
solution.

Two options I'm aware of. First, define a new line chart for each data
series containing consecutive non-null data. Those separate lines will appear
as one sequence (except for the null gaps) if you'll then configure them with
the same colors, markers, etc.

The second option is to manually hide the null line segments & points (e.g.,
by coloring them white).

 

[Jon Peltier]

You're right about the treatment of Empty Cells: a formula renders a cell
not empty.

Excel assigns a value of zero to cells containing text, and "" is a short
piece of text. In a line or XY chart, the #N/A error is not plotted, and the
line extends from the point on one side of the #N/A to the point on the
other side. Change your formula to

=IF(A4<10,NA(),A4)

to produce this error value in a cell. If you don't like to see the error in
your table, hide it with conditional formatting.


Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


..