Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Total number display in stacked charts

I have put together a stacked chart and have each section of it labeled with
the appropriate value for it. I was wondering how to label above each bar on
the chart its total amount of all sections.

for example: bar 1 has a bottom section labeled 1570, middle labeled 185
and top section labeled 83. Without using a text box, how do I have the chart
add the three sections to label 1838 above the bar to display the cumulative
amount?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Total number display in stacked charts

Brianna -

I show how to do this in my blog:

Label Totals on Stacked Column Charts
http://peltiertech.com/WordPress/lab...tacked-charts/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Brianna wrote:
I have put together a stacked chart and have each section of it labeled with
the appropriate value for it. I was wondering how to label above each bar on
the chart its total amount of all sections.

for example: bar 1 has a bottom section labeled 1570, middle labeled 185
and top section labeled 83. Without using a text box, how do I have the chart
add the three sections to label 1838 above the bar to display the cumulative
amount?

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
Total number in stacked column Falcon08 Excel Discussion (Misc queries) 0 February 24th 09 02:50 PM
100% Stacked Chart - display total in data table only B Rager Charts and Charting in Excel 3 February 15th 08 02:40 PM
display total above certain number and display MGD Excel Discussion (Misc queries) 3 March 4th 06 05:03 PM
how do i display the total number of days in the current month in. timerigger Excel Discussion (Misc queries) 6 March 20th 05 05:13 PM
total value of stacked charts OkieViking Charts and Charting in Excel 1 January 28th 05 12:57 PM


All times are GMT +1. The time now is 03:42 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"