hiding zero values in stacked bar charts
 

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.

hiding zero values in stacked bar charts
 

Hi,

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

Cheers
Andy

WSU Cougar wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

hiding zero values in stacked bar charts
 

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.

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

WSU Cougar wrote:
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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

hiding zero values in stacked bar charts
 

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

WSU Cougar wrote:
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.

"Andy Pope" wrote:


Hi,

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

Cheers
Andy

WSU Cougar wrote:

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.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info