Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Stacked column chart with white data labels | Charts and Charting in Excel | |||
Data labels for stacked bar chart | Excel Discussion (Misc queries) | |||
Stacked Bar Chart - Data Labels:Percentage - Excel 2003 | Charts and Charting in Excel | |||
How do I get total value data labels in a stacked bar chart? | Charts and Charting in Excel | |||
Data labels on a stacked chart | Charts and Charting in Excel |