|
|||||||||||||||||||||
|
#1
|
|||
|
|||
|
Ignoring 0 values in the series data
How can I get my chart to ignore values which are zero in the series data and
not show these? |
|
#2
|
|||
|
|||
|
replace zeros with =NA()
Mangesh |
|
#3
|
|||
|
|||
|
Re: Ignoring 0 values in the series data
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
|
|||
|
|||
|
RE: Ignoring 0 values in the series data
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
|
|||
|
|||
|
Re: Ignoring 0 values in the series data
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
|
|||
|
|||
|
Re: Ignoring 0 values in the series data
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? > > |
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|