how do I hide zeros in a graphic?
If I have a table with 'zero' values and don't want them to appear in my
graphic, but do want the rest of the values to show, how do I hide them? Hiding them on the table doesn't work, they still show up in the graphic... |
how do I hide zeros in a graphic?
Replace the zeros by =NA() or #N/A
-- David Biddulph "FLF" wrote in message ... If I have a table with 'zero' values and don't want them to appear in my graphic, but do want the rest of the values to show, how do I hide them? Hiding them on the table doesn't work, they still show up in the graphic... |
how do I hide zeros in a graphic?
Replace them with =NA() which displays in the cells as #N/A but is ignored
by the chart engine best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "FLF" wrote in message ... If I have a table with 'zero' values and don't want them to appear in my graphic, but do want the rest of the values to show, how do I hide them? Hiding them on the table doesn't work, they still show up in the graphic... |
how do I hide zeros in a graphic?
Bernard Liengme wrote:
Replace them with =NA() which displays in the cells as #N/A but is ignored by the chart engine best wishes I tried something like this and it didn't work. I finally had to just remove the values, leaving a blank cell. |
how do I hide zeros in a graphic?
"Something like this" was obviously not close enough. Next time, don't do
it that way. I think you win today's newsgroup prize for useful and detailed description of a problem: "Something like this", and "it didn't work" :-( -- David Biddulph "doofy" wrote in message ... I tried something like this and it didn't work. I finally had to just remove the values, leaving a blank cell. Bernard Liengme wrote: Replace them with =NA() which displays in the cells as #N/A but is ignored by the chart engine best wishes |
All times are GMT +1. The time now is 12:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com