Thanks for feedback
My first point was to type =NA() (not =N/A)
The NA() function returns (ie displays) the value #N/A
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message
news:9d561f0451c12@uwe...
Hmmmmm

1. =N/A is still recognised in the range and the graps still plummett to
zero
2. I dont actylly have an option to say ignore empty cells in tool options
for the chart. The option id do have is plot visible cells only, and that
makes no difference
3. Jons site seems to be the answer.

Many Thanks
Matt



Bernard Liengme wrote:
Depending on your needs they are several solutions
1) fill the empty cells with =NA() until the data is available. This
displays as #N/A and is ignored by the chart engine
2) use the option (select chart, open Tools | Option | Chart) and specify
that empty cells are to be ignored
3) make a true dynamic chart - Google "Excel dynamic Chart" but you can
readily find the answer at Jon Peltier's site
http://peltiertech.com/Excel/Charts/Dynamics.html
best wishes
Hi all

[quoted text clipped - 17 lines]
Regards
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200910/1