A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

hiding zero values in stacked bar charts



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2006, 12:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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.
  #2  
Old February 3rd, 2006, 01:10 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
  #3  
Old February 4th, 2006, 09:07 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

  #4  
Old February 4th, 2006, 09:19 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding Zeros in Stacked Bar Charts Darshan72 Charts and Charting 1 February 3rd, 2005 11:18 AM
Default placement for data values in Charts Ellen Powerpoint 2 July 14th, 2004 03:56 PM
Excel Charts - Value Y axis scale - locking values to preventchanging Andy Pope Charts and Charting 0 June 22nd, 2004 04:31 PM
follow up: stacked charts Anna Krieger Powerpoint 2 June 18th, 2004 09:29 PM
ignoring zero values in excel charts Whirlwind Charts and Charting 3 September 24th, 2003 04:03 PM


All times are GMT +1. The time now is 09:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.