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å

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"svangis" wrote in message
...
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å