Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
KMH KMH is offline
external usenet poster
 
Posts: 31
Default Change All Data Labels in Excel 2007 Stacked Bar Chart

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

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default Change All Data Labels in Excel 2007 Stacked Bar Chart

Excel 2007 Chart
Format data labels.
With macro.
http://www.mediafire.com/file/mo20mmnynai/01_30_10.xlsm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007: Stacked column chart with white data labels Luca Brasi Charts and Charting in Excel 2 June 13th 09 12:26 AM
Data labels for stacked bar chart Ron H. Excel Discussion (Misc queries) 1 January 28th 08 05:24 PM
Stacked Bar Chart - Data Labels:Percentage - Excel 2003 seven_percent Charts and Charting in Excel 0 November 17th 06 03:16 PM
How do I get total value data labels in a stacked bar chart? blemerson Charts and Charting in Excel 2 September 15th 06 07:08 PM
Data labels on a stacked chart whouser Charts and Charting in Excel 3 May 11th 05 09:12 PM


All times are GMT +1. The time now is 05:44 PM.

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

About Us

"It's about Microsoft Excel"