Prev: Pivot Chart Data Table
Next: Dynamically Scale X Axis on Column Chart Based on Number of Catego
From: KMH on 29 Jan 2010 18:04
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

From: Herbert Seidenberg on 30 Jan 2010 18:42
Excel 2007 Chart
Format data labels.
With macro.
http://www.mediafire.com/file/mo20mmnynai/01_30_10.xlsm
 | 
Pages: 1
Prev: Pivot Chart Data Table
Next: Dynamically Scale X Axis on Column Chart Based on Number of Catego