Look at dynamic charts
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm
--------------------------------------------------------------------------------


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jennifer" wrote in message
...
Hi, I don't want my blank cells to appear anywhere on my chart. I want it
to
ignore the cooresponding cell if the cell has #NA in it. Write now, I
have
over 10,000 cells, but only 50 have results but the chart is trying to
chart
the entire workbook.

"Andy Pope" wrote:

Hi,

The blank part of your formula should be NA() rather than "".

=IF( test , value , NA() )

More information here
http://www.andypope.info/charts/brokenlines.htm

Cheers
Andy

groj wrote:
In my series data, the blank is created by an if statement so there is
a
calculation here that makes the cell blank. should it still not plot it
as
zero?
I looked where you mention, and I am already set up to plot emplty
cells as
not plotted. But there are still zeros being plotted.

any help?
thanks

"John Mansfield" wrote:


hlp,

Click once on your chart. Then, go to the standard toolbar and go to
Tools
- Options - Chart - Plot empty cells as: Not plotted (leave gaps).

----
Regards,
John Mansfield
http://www.pdbook.com

"hlp" wrote:


How do I exclude blank cells in diagrams. If I have an area of data
and among
these data some is blank. How do I get excel to not display these data
as '0'
but just to skip the cell.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info