|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 2nd, 2009, 10:00 PM
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
September 3rd, 2009, 08:50 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
