Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Mass Setting Data Labels on Stacked Chart

I have a stacked bar chart that I update on a weekly basis in Excel 2010. The # of stacks stays the same (workcenters), the series in each stack varies depending on the tools that were run in that workcenter that week. The source of the chart is a pivot table that summarizes the individual data records I get from my ERP program. The first time I created the chart, I went into each series, turned on the data values and changed the format to display the series name (tool #). However, the next week, as the tool #'s changed, some of the data labels were missing. I know I can set each one individually...is there a way to turn on the data labels / format the data labels for all series in a chart at the same time?

Update...I just learned that if you select the chart itself, go to PivotChart Tools, Select Layout, Data Labels, you can turn them all on / off at once. However, Excel defaults to the VALUE for the data label. Even if I have the entire graph selected, when I try to go to More Data Label Options, to change the label to the Series Name, instead of the Value, Excel only changes one series. How can I make Excel default to show the Series Name instead of the Value, so that I can turn all the Series Names on at once?

Last edited by dorio : May 30th 14 at 05:57 PM Reason: added version info
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
Cumulative Data Labels on Stacked Bar/Column Chart BlueWolverine Charts and Charting in Excel 0 April 1st 10 01:35 PM
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 01:11 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"