software

On a stacked bar chart with values displayed (data label is set to value), I
do not want to display the value if its zero (no slice of data). Is there a
way to do this?

When I have approached different Excel users with this problem, they said
they go back to the spreadsheet and delete the zero's so they do not show up
on the chart.
I have a lot of entries and frequently use the spreadsheet so I want to
avoid having to manually delete the zeros for display purposes.

Thank you.

Hi,

To get rid of zero data labels try using a custom number format
General;General;;

Cheers
Andy

WSU Cougar wrote:
gt; On a stacked bar chart with values displayed (data label is set to value), I
gt; do not want to display the value if its zero (no slice of data). Is there a
gt; way to do this?
gt;
gt; When I have approached different Excel users with this problem, they said
gt; they go back to the spreadsheet and delete the zero's so they do not show up
gt; on the chart.
gt; I have a lot of entries and frequently use the spreadsheet so I want to
gt; avoid having to manually delete the zeros for display purposes.
gt;
gt; Thank you.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

I tried this but it hides the zeros in the spreadsheet. What I really would
like is to have the zeros displayed in the spreadsheet but not in the stacked
bar chart.

Any ideas?

Thank you.

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; To get rid of zero data labels try using a custom number format
gt; General;General;;
gt;
gt; Cheers
gt; Andy
gt;
gt; WSU Cougar wrote:
gt; gt; On a stacked bar chart with values displayed (data label is set to value), I
gt; gt; do not want to display the value if its zero (no slice of data). Is there a
gt; gt; way to do this?
gt; gt;
gt; gt; When I have approached different Excel users with this problem, they said
gt; gt; they go back to the spreadsheet and delete the zero's so they do not show up
gt; gt; on the chart.
gt; gt; I have a lot of entries and frequently use the spreadsheet so I want to
gt; gt; avoid having to manually delete the zeros for display purposes.
gt; gt;
gt; gt; Thank you.
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

Apply the number format to the actual data labels not the cell.

WSU Cougar wrote:
gt; I tried this but it hides the zeros in the spreadsheet. What I really would
gt; like is to have the zeros displayed in the spreadsheet but not in the stacked
gt; bar chart.
gt;
gt; Any ideas?
gt;
gt; Thank you.
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;To get rid of zero data labels try using a custom number format
gt;gt;General;General;;
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;WSU Cougar wrote:
gt;gt;
gt;gt;gt;On a stacked bar chart with values displayed (data label is set to value), I
gt;gt;gt;do not want to display the value if its zero (no slice of data). Is there a
gt;gt;gt;way to do this?
gt;gt;gt;
gt;gt;gt;When I have approached different Excel users with this problem, they said
gt;gt;gt;they go back to the spreadsheet and delete the zero's so they do not show up
gt;gt;gt;on the chart.
gt;gt;gt;I have a lot of entries and frequently use the spreadsheet so I want to
gt;gt;gt;avoid having to manually delete the zeros for display purposes.
gt;gt;gt;
gt;gt;gt;Thank you.
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info