Hiding Zeros in Data Table

  • Thread starter Bruister via OfficeKB.com
  • Start date
B

Bruister via OfficeKB.com

How do I hide the zeros imbedded in a chart data table. The worksheet data
shows a blank cell but zeros appear in the data table in the chart? Am using
excel 2007
 
B

Bernard Liengme

I never use data table, so this is just what I found be experimenting.
The dialog for formatting data tables has no provision for formatting the
numbers

I made some data with B5 as a blank cell and generated a chart for it. The
data table in the chart had the entry for B5 blank. But if I had a formula
like =IF(test,"", number) then B5 might look blank but a 0 shows in the data
table.

However a formula as =IF(test, NA(), number) gives a blank in the data
table
If you do not like the look of #N/A in the data series, then use conditional
formatting in the form =ISNA(cell ref) and make the font the same colour as
the cell background to hide it.
best wishes
 
J

Jon Peltier

No need to compromise the data. Simply apply a number format in the
worksheet cells that suppresses display of zero, something like

0;;;

and the zero will be hidden in the worksheet and in the data table.

This works in 2007 and in Classic Excel.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top