Thread: how to hide zero values on line chart

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?

try =NA() instead of zero.


Mangesh



"MikeM" <MikeM@discussions.microsoft.com> wrote in message
news:FC630D87-0ED0-4295-B468-B54616B65DE9@microsoft.com...
> 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?

Never mind - the previous post had the answer.

mm.

"MikeM" wrote:

> 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?