G
Guest
Guest
I use a bar graph to display actual data and a line graph to display Budget data. Now, for obvious reasons, I only want to show data until February. The problem is that the line graph shows 0 (zero) values (which are the result of a formula like IF[ (A1="FEB-02";B1;"") ]and the bar graph does not show 0 (zero) values.
I get the following situation in a graph:
Jan Feb Mar Apr May
Actual 5 6 8
Budget 6 5 5 0 0
I get the following situation in a graph:
Jan Feb Mar Apr May
Actual 5 6 8
Budget 6 5 5 0 0