software

Hi,

I followed the directions given to hide zero values in chats and tables in
Excel 2000. I used the chart wizard when i created them. But the zero
values continue to be shown on the chart. For example, I have data for
target values versus actual values for events. The targeted numbers go from
July 2005 - June 2005. The actual data values are from July 2005 - Nov
2005. I used the toolsgt; optionsgt;chartgt;plot visible cells only.

Any guidance on what I am doing incorrect?

Hi fascal,

The setting you want is toolsgt;optionsgt;chartgt;Plot empty cells as: not plotted
(leave gaps)

The problem you then face is that zero values are still plotted, where you
have no data you need to leave the cell empty or put the value #N/A in the
cell.

If you are using formulas for the actuals, try something like;
=IF(C3=0,NA(),C3)

Ed Ferrero
www.edferrero.comgt; Hi,
gt;
gt; I followed the directions given to hide zero values in chats and tables in
gt; Excel 2000. I used the chart wizard when i created them. But the zero
gt; values continue to be shown on the chart. For example, I have data for
gt; target values versus actual values for events. The targeted numbers go
gt; from
gt; July 2005 - June 2005. The actual data values are from July 2005 - Nov
gt; 2005. I used the toolsgt; optionsgt;chartgt;plot visible cells only.
gt;
gt; Any guidance on what I am doing incorrect?

Originally Posted by Ed FerreroHi fascal,

The setting you want is toolsoptionschartPlot empty cells as: not plotted
(leave gaps)

The problem you then face is that zero values are still plotted, where you
have no data you need to leave the cell empty or put the value #N/A in the
cell.

If you are using formulas for the actuals, try something like;
=IF(C3=0,NA(),C3)

Ed Ferrero
www.edferrero.com

Hi,
I followed the directions given to hide zero values in chats and tables inExcel 2000. I used the chart wizard when i created them. But the zerovalues continue to be shown on the chart. For example, I have data fortarget values versus actual values for events. The targeted numbers gofromJuly 2005 - June 2005. The actual data values are from July 2005 - Nov2005. I used the tools optionschartplot visible cells only.
Any guidance on what I am doing incorrect?

I used the NA solution and it worked on the graph but the spreadsheet doesnot add up now as it now has NA!!!!!!!!!!!!!!!!!!!!
I suggest you keep the original data range as is for the table and
subsequent calculations, and use a nearby worksheet range for the chart
source data. Use a formula following Ed's suggestion to convert blanks,
text, and zeros to NA(), and use this fixed up range for the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Peter Nashquot; gt; wrote in message
...
gt;
gt; Ed Ferrero Wrote:
gt;gt; Hi fascal,
gt;gt;
gt;gt; The setting you want is toolsoptionschartPlot empty cells as: not
gt;gt; plotted
gt;gt; (leave gaps)
gt;gt;
gt;gt; The problem you then face is that zero values are still plotted, where
gt;gt; you
gt;gt; have no data you need to leave the cell empty or put the value #N/A in
gt;gt; the
gt;gt; cell.
gt;gt;
gt;gt; If you are using formulas for the actuals, try something like;
gt;gt; =IF(C3=0,NA(),C3)
gt;gt;
gt;gt; Ed Ferrero
gt;gt; www.edferrero.com
gt;gt;
gt;gt;
gt;gt; Hi,
gt;gt;
gt;gt; I followed the directions given to hide zero values in chats and
gt;gt; tables in
gt;gt; Excel 2000. I used the chart wizard when i created them. But the
gt;gt; zero
gt;gt; values continue to be shown on the chart. For example, I have data
gt;gt; for
gt;gt; target values versus actual values for events. The targeted numbers
gt;gt; go
gt;gt; from
gt;gt; July 2005 - June 2005. The actual data values are from July 2005 -
gt;gt; Nov
gt;gt; 2005. I used the tools optionschartplot visible cells only.
gt;gt;
gt;gt; Any guidance on what I am doing incorrect?
gt;
gt; I used the NA solution and it worked on the graph but the spreadsheet
gt; doesnot add up now as it now has NA!!!!!!!!!!!!!!!!!!!!
gt;
gt;
gt; --
gt; Peter Nash
thank you. I used the formula.

Best Regards,
fascal

quot;fascalquot; wrote:

gt; Hi,
gt;
gt; I followed the directions given to hide zero values in chats and tables in
gt; Excel 2000. I used the chart wizard when i created them. But the zero
gt; values continue to be shown on the chart. For example, I have data for
gt; target values versus actual values for events. The targeted numbers go from
gt; July 2005 - June 2005. The actual data values are from July 2005 - Nov
gt; 2005. I used the toolsgt; optionsgt;chartgt;plot visible cells only.
gt;
gt; Any guidance on what I am doing incorrect?