GRAPHS

[svangis]

I have a graph for a period of let´s say a year. I only got actual figures
for the first half of the period so what´s happening with my graph, it dives.
Is there anything you can do to avoid that?
/så

 

[Andy Pope]

Hi,

For the periods that have yet to come either make them empty cells or use
the formula =NA()
Anything else, non numeric, in the cell will be treated as text and text is
plotted as zero.

Cheers
Andy