Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked bar chart with totals - Excel 2003
Hi everyone,
I have a stacked bar chart with 8 items associated with the stacked chart. What I want is, is there a way to get the total amount for each stack and display it at the top of each bar? Like a regular bar chart does. This would be awesome if someone has some sample code or a add-in! Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked bar chart with totals - Excel 2003
From another thread -
Jon wrote "Make another series that represents the totals you want to display. Add this data to the chart as a new series. At first this series will appear as a new column stacked on the rest. Select it, go to Chart menu Chart Type, and select a Line chart style to change this series. Double click this series, and on the Data Labels tab, choose the Values option, then on the Patterns tab, select no lines and no markers. Click OK, then double click on the labels, and on the Alignment tab, choose Above from the position dropdown. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "EAB1977" wrote: Hi everyone, I have a stacked bar chart with 8 items associated with the stacked chart. What I want is, is there a way to get the total amount for each stack and display it at the top of each bar? Like a regular bar chart does. This would be awesome if someone has some sample code or a add-in! Thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked bar chart with totals - Excel 2003
Luke, I've found your explanation very useful, as I needed the same thing as
the original poster. One problem I have run into is after I save the file, the data labels for the totals do not hold the format of "above". any thoughts as tho why this may happen? Other format changes will hold, so I don't get it. "Luke M" wrote: From another thread - Jon wrote "Make another series that represents the totals you want to display. Add this data to the chart as a new series. At first this series will appear as a new column stacked on the rest. Select it, go to Chart menu Chart Type, and select a Line chart style to change this series. Double click this series, and on the Data Labels tab, choose the Values option, then on the Patterns tab, select no lines and no markers. Click OK, then double click on the labels, and on the Alignment tab, choose Above from the position dropdown. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "EAB1977" wrote: Hi everyone, I have a stacked bar chart with 8 items associated with the stacked chart. What I want is, is there a way to get the total amount for each stack and display it at the top of each bar? Like a regular bar chart does. This would be awesome if someone has some sample code or a add-in! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
When using a 100% stacked column chart how do I get totals? | Charts and Charting in Excel | |||
Stacked Bar Chart - Data Labels:Percentage - Excel 2003 | Charts and Charting in Excel | |||
How do I fix my Stacked column chart with grand totals? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |