Ignoring 0 values in the series data

#1 06-17-2005, 08:05 AM

How can I get my chart to ignore values which are zero in the series data and
not show these?

mangesh_yadav · #2 06-17-2005, 08:12 AM

replace zeros with =NA()

Mangesh

#3 06-17-2005, 09:05 AM

You can delete the formulas that are producing zero, or replace them with
=IF(formula=0,#N/A,formula)

Jerry

Alison wrote:

> How can I get my chart to ignore values which are zero in the series data and
> not show these?

#4 06-20-2005, 01:05 PM

What you have told me works but I would also like the chart to ignore the
chart label that the zero relates to. I have a spreadsheet that shows how
much time has been spent on differnet customer sites. Using data validation
and a look up table I have set it up so that you can select a partner and
view which customers it has worked on. The problem is the x axis shows all
the customers for FY05, meaning the graph is quite large with lots of empty
spaces. When you select the partner you want to view I would like the graph
to ignore all the customers with 0 and only show the actve ones. Is this
possible?!

"Alison" wrote:

> How can I get my chart to ignore values which are zero in the series data and
> not show these?

#5 06-21-2005, 09:05 AM

I think you will have to set up cells that summarize only the customers
worked on, and plot that summary information.

Jerry

Alison wrote:

> What you have told me works but I would also like the chart to ignore the
> chart label that the zero relates to. I have a spreadsheet that shows how
> much time has been spent on differnet customer sites. Using data validation
> and a look up table I have set it up so that you can select a partner and
> view which customers it has worked on. The problem is the x axis shows all
> the customers for FY05, meaning the graph is quite large with lots of empty
> spaces. When you select the partner you want to view I would like the graph
> to ignore all the customers with 0 and only show the actve ones. Is this
> possible?!
>
> "Alison" wrote:
>
>
>>How can I get my chart to ignore values which are zero in the series data and
>>not show these?

#6 08-16-2005, 12:05 PM

here yah go

http://www.andypope.info/charts/brokenlines.htm

"Jerry W. Lewis" wrote:

> I think you will have to set up cells that summarize only the customers
> worked on, and plot that summary information.
>
> Jerry
>
> Alison wrote:
>
> > What you have told me works but I would also like the chart to ignore the
> > chart label that the zero relates to. I have a spreadsheet that shows how
> > much time has been spent on differnet customer sites. Using data validation
> > and a look up table I have set it up so that you can select a partner and
> > view which customers it has worked on. The problem is the x axis shows all
> > the customers for FY05, meaning the graph is quite large with lots of empty
> > spaces. When you select the partner you want to view I would like the graph
> > to ignore all the customers with 0 and only show the actve ones. Is this
> > possible?!
> >
> > "Alison" wrote:
> >
> >
> >>How can I get my chart to ignore values which are zero in the series data and
> >>not show these?
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)