Thread: overcoming zero values in line graph

I have a 12-month line graph where some of the earliest and most recent data
is still zero.

Is there a way to have Excel not plot zero values - to avoid the big rises
and drop offs they cause - and, rather, just have the graph start and end
wherever there is positive data?

(NOTE: for multiple reasons, I can't erase the formulae in the cells
yielding the zero values, or have them display the N/A message....)

Thanks!!!

Marika

There is no reason why you cannot have a 2nd data set that has the N/A
values. Plot this second set and use the first for whatever you are
using it for.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <FABDAB90-F576-4317-89B2-AB6F2BD37DC9@microsoft.com>,
marika1981@discussions.microsoft.com says...
> I have a 12-month line graph where some of the earliest and most recent data
> is still zero.
>
> Is there a way to have Excel not plot zero values - to avoid the big rises
> and drop offs they cause - and, rather, just have the graph start and end
> wherever there is positive data?
>
> (NOTE: for multiple reasons, I can't erase the formulae in the cells
> yielding the zero values, or have them display the N/A message....)
>
> Thanks!!!
>
> Marika
>
>

From the data set you can use the IF command to make it read NA when the
response is zero. If you are inputting the numbers, you can also do a page
format for anything less than or equal to 0 is "NA" and that should leave it
unplotted.

=IF(A1=0, "NA", A1/A2) or something to that extent


"marika1981" <marika1981@discussions.microsoft.com> wrote in message
news:FABDAB90-F576-4317-89B2-AB6F2BD37DC9@microsoft.com...
>I have a 12-month line graph where some of the earliest and most recent
>data
> is still zero.
>
> Is there a way to have Excel not plot zero values - to avoid the big rises
> and drop offs they cause - and, rather, just have the graph start and end
> wherever there is positive data?
>
> (NOTE: for multiple reasons, I can't erase the formulae in the cells
> yielding the zero values, or have them display the N/A message....)
>
> Thanks!!!
>
> Marika
>

Debra Dalgleish shows how to hide those errors with conditional formatting:

http://contextures.com/xlCondFormat03.html#Errors

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

marika1981 wrote:

> I have a 12-month line graph where some of the earliest and most recent data
> is still zero.
>
> Is there a way to have Excel not plot zero values - to avoid the big rises
> and drop offs they cause - and, rather, just have the graph start and end
> wherever there is positive data?
>
> (NOTE: for multiple reasons, I can't erase the formulae in the cells
> yielding the zero values, or have them display the N/A message....)
>
> Thanks!!!
>
> Marika
>