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]
[/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
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]=""; ""; RC[-1]+R[-1]C) ==> 2
Feb 3 =IF(RC[-1]=""; ""; RC[-1]+R[-1]C) ==> 5
Mar 1 =IF(RC[-1]=""; ""; RC[-1]+R[-1]C) ==> 6
Apr -2 =IF(RC[-1]=""; ""; RC[-1]+R[-1]C) ==> 4
May =IF(RC[-1]=""; ""; RC[-1]+R[-1]C) ==> ""
Jun
Jui
Aug
...
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