| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Total of Stacked Column Chart
Using 2003
I have a stacked column chart with 10 different stacks/series of data. I want to show the total of all the stacks at the top of each column. What I do now is add it up manually and insert the total into a text box. Is there an easier more automated way to do this? Thanks, Karen |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Total of Stacked Column Chart
Hi,
Add a series, plotting as line, which is is the total of each stack. Display data labels in the above position and format the line as none with no markers. Or use a column on the secondary axis, again removing formatting and applying data label http://www.andypope.info/charts/StackColTotal.htm Cheers Andy Karen wrote: Using 2003 I have a stacked column chart with 10 different stacks/series of data. I want to show the total of all the stacks at the top of each column. What I do now is add it up manually and insert the total into a text box. Is there an easier more automated way to do this? Thanks, Karen -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stacked Column Chart - Total that isn't the sum of series | Charts and Charting in Excel | |||
| Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
| Show total in a Stacked Chart | Charts and Charting in Excel | |||
| Total on Stacked Column Chart | Excel Discussion (Misc queries) | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
Linear Mode
