| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar chart with no zero columns
I have a colums with a hundreds a values and only twenty is real values the
rest is all zero. How do I plot a bar chart showing only the values and omits the zero values from the chart. My chart is plotting all zero values which makes it impossible to view. Is there a way of not plotting the zero columns without filtering the data. I read the previous posts but the NA() allso shows zero values. Any help would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart with no zero columns
Hi,
You could use filtering to hide the rows. Make sure the chart has Plot visible cells only set. Select the chart and check via Tools Options Chart Plot visible cells only Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mac" wrote in message ... I have a colums with a hundreds a values and only twenty is real values the rest is all zero. How do I plot a bar chart showing only the values and omits the zero values from the chart. My chart is plotting all zero values which makes it impossible to view. Is there a way of not plotting the zero columns without filtering the data. I read the previous posts but the NA() allso shows zero values. Any help would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart with no zero columns
If you read my question, I said I dont want to use filtering. Thanx anyway.
Do you have any other ideas. "Andy Pope" wrote: Hi, You could use filtering to hide the rows. Make sure the chart has Plot visible cells only set. Select the chart and check via Tools Options Chart Plot visible cells only Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mac" wrote in message ... I have a colums with a hundreds a values and only twenty is real values the rest is all zero. How do I plot a bar chart showing only the values and omits the zero values from the chart. My chart is plotting all zero values which makes it impossible to view. Is there a way of not plotting the zero columns without filtering the data. I read the previous posts but the NA() allso shows zero values. Any help would be appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart with no zero columns
Why do you not want to use filtering? You could always place your chart data
somewhere else within the workbook if it effects your presentation. Maybe with formula you could modify this technique. http://www.cellmatrix.net/index.php/...e_zero_values/ Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mac" wrote in message ... If you read my question, I said I dont want to use filtering. Thanx anyway. Do you have any other ideas. "Andy Pope" wrote: Hi, You could use filtering to hide the rows. Make sure the chart has Plot visible cells only set. Select the chart and check via Tools Options Chart Plot visible cells only Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mac" wrote in message ... I have a colums with a hundreds a values and only twenty is real values the rest is all zero. How do I plot a bar chart showing only the values and omits the zero values from the chart. My chart is plotting all zero values which makes it impossible to view. Is there a way of not plotting the zero columns without filtering the data. I read the previous posts but the NA() allso shows zero values. Any help would be appreciated. Thanks |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart with no zero columns
As a follow-up, here's a link to a modification of the formulas:
http://www.cellmatrix.net/index.php/...de_zero_values -- John Mansfield http://cellmatrix.net "Andy Pope" wrote: Why do you not want to use filtering? You could always place your chart data somewhere else within the workbook if it effects your presentation. Maybe with formula you could modify this technique. http://www.cellmatrix.net/index.php/...e_zero_values/ Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mac" wrote in message ... If you read my question, I said I dont want to use filtering. Thanx anyway. Do you have any other ideas. "Andy Pope" wrote: Hi, You could use filtering to hide the rows. Make sure the chart has Plot visible cells only set. Select the chart and check via Tools Options Chart Plot visible cells only Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mac" wrote in message ... I have a colums with a hundreds a values and only twenty is real values the rest is all zero. How do I plot a bar chart showing only the values and omits the zero values from the chart. My chart is plotting all zero values which makes it impossible to view. Is there a way of not plotting the zero columns without filtering the data. I read the previous posts but the NA() allso shows zero values. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Widening Columns in Chart | Charts and Charting in Excel | |||
| Merged columns in chart | Excel Discussion (Misc queries) | |||
| Chart columns | Charts and Charting in Excel | |||
| How do I have stacked columns and a reg col. on same chart? | Charts and Charting in Excel | |||
| Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Hybrid Mode
