G
Guest
in EXCEL - I want to have line chart showing Planned vs Actual over time
(weekly). I have 5 data points for Planned. I want to show Actual results
only when there are non-zero values.
Details: the Actual data series is a count of data entered. For example, at
end of week, someone enters actual results in series of columns. the "count"
of these entries makes up the Actual total to be plotted. Thus, after 3rd
week, the person has entered data for week 1, 2, 3, and there is total for
Actual for those weeks. total for week 4, 5 is zero cause there is no data.
Unfortunately, when plotting the Actual total - the chart seems to think
that the formula should be translated into a value on the chart - whether
there is data or not. Thus, the line on chart for Actual shows data for week
1, 2, 3, then line goes to zero for week 4, 5. I want the line to stop after
week 3.
How do I get the chart to not show week 4, 5 until the value is non-zero?
(weekly). I have 5 data points for Planned. I want to show Actual results
only when there are non-zero values.
Details: the Actual data series is a count of data entered. For example, at
end of week, someone enters actual results in series of columns. the "count"
of these entries makes up the Actual total to be plotted. Thus, after 3rd
week, the person has entered data for week 1, 2, 3, and there is total for
Actual for those weeks. total for week 4, 5 is zero cause there is no data.
Unfortunately, when plotting the Actual total - the chart seems to think
that the formula should be translated into a value on the chart - whether
there is data or not. Thus, the line on chart for Actual shows data for week
1, 2, 3, then line goes to zero for week 4, 5. I want the line to stop after
week 3.
How do I get the chart to not show week 4, 5 until the value is non-zero?