PC Review


Reply
Thread Tools Rate Thread

Change All Data Labels in Excel 2007 Stacked Bar Chart

 
 
KMH
Guest
Posts: n/a
 
      29th Jan 2010
How do I change all data labels in an Excel 2007 Stacked Bar Chart? I can
turn them all on at once to get a #, but I want the series name, set # format
to currency, and resize the font text. I may or may not want it to put it on
2 lines. I am fine if I change my default for all to this as long as I know
how to change it. It is a pain to change them each 1 at a time.

Also, is there a way to size them to fit and/or wrap the text? I can work
with VB code if not a setting that you can make.

Thanks

 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      30th Jan 2010
Excel 2007 Chart
Format data labels.
With macro.
http://www.mediafire.com/file/mo20mmnynai/01_30_10.xlsm
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: Stacked column chart with white data labels Luca Brasi Microsoft Excel Charting 2 13th Jun 2009 12:26 AM
Data labels for stacked bar chart Ron H. Microsoft Excel Misc 1 28th Jan 2008 04:24 PM
Stacked Bar Chart - Data Labels:Percentage - Excel 2003 seven_percent Microsoft Excel Charting 0 17th Nov 2006 02:16 PM
How do I get total value data labels in a stacked bar chart? =?Utf-8?B?YmxlbWVyc29u?= Microsoft Excel Charting 2 15th Sep 2006 07:08 PM
Data labels on a stacked chart =?Utf-8?B?d2hvdXNlcg==?= Microsoft Excel Charting 3 11th May 2005 09:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:07 AM.