EXCEL 2007 - How to stop an area before the end ???

cyrilz · Oct 27, 2011

Hello all,

I want to use a mixer Bar/Area graph to show the budget/consumption progression over time.

I have the following table :

[pre]

Code:

month   Actual   Cumulative
Jan      2         =IF(RC[-1]=&#34;&#34;; &#34;&#34;; RC[-1]+R[-1]C)   ==&#62;  2
Feb      3         =IF(RC[-1]=&#34;&#34;; &#34;&#34;; RC[-1]+R[-1]C)   ==&#62;  5
Mar      1         =IF(RC[-1]=&#34;&#34;; &#34;&#34;; RC[-1]+R[-1]C)   ==&#62;  6
Apr      -2        =IF(RC[-1]=&#34;&#34;; &#34;&#34;; RC[-1]+R[-1]C)   ==&#62;  4
May                =IF(RC[-1]=&#34;&#34;; &#34;&#34;; RC[-1]+R[-1]C)   ==&#62;  &#34;&#34;
Jun
Jui
Aug
...

[/pre]

I want the area for the cumulative part to stop automatically on april and not to go to Zero.

I've test all possible value in the "zero value" button in the chart series options. The area goes always to zero.

So I want to know if there is an automated way to define number of values in series in chart?

Regards

Cyril

vasim · Oct 27, 2011

Hello.... instead of " " put an =NA()..NA() are not plotted on chart...

cyrilz · Oct 27, 2011

Thanks a lot, this worked really fine

EXCEL 2007 - How to stop an area before the end ???

cyrilz

New Member

vasim

Member

cyrilz

New Member