Hi - Sorry for late reply.
I tried again and got the #N/A as you described.
Maybe i accidentally typed something into it too.

Aside from that though, the area chart still plots to zero when i ask it to
look at the =N/A() cells.
I tried clicking on the graph, and going to tool/options/chart and i have
options to...Plot emptycells as eother empty or interpolated - using either
of these make no difference.
Other options are plot visible cells only, and again make no difference with
the chart.
To clarify the chart as i am sometimes rubbish at explaining
Its an area chart with a line chart inside it
The background colour of the area chart is green giving an above target look
to the chart. Amber (orange) and target (Red) and actual (black line) are the
3 axis for the area chart. To get to the actual line i just clicked on what
was the actual area colour and changed chart type to line.
i want to extend the graph for a whole year, but dont want the graph to sink
to zero on empty months.

Maybe this is not possible. Excel 2002 is the version.

Many Thanks Bernard

Regards
Matt



David Biddulph wrote:
Are you sure that you have =NA() ? Those are opening and closing
parentheses. Did you type someting into your formula, or copy from the
newsgroup?
Perhaps you can copy back from your formula bar to the newsgroup so that we
can see exactly what you've got in the formula which is returning #NAME?
--
David Biddulph

Hi Bernard - This now returns #NAME? and the graphs still plots them as
zero?
[quoted text clipped - 12 lines]
Regards
Matt

--
Matt Lynn

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