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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|