LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 740
Default stacked column chart

Cj,

yes it is possible.

--
regards

"Conditional join" wrote:

I have a stacked column chart and I added data labels showing values. I want
the chart to graph the value with the column bars, but I would like to see
the percentages with those bars instead of the value. For example, the total
for the column bar is 200 with the break down as such: Group = 50,
Individual = 25 and Enterprise 125. I want the stack bar to show a total of
200, but instead of the labels showing the value of 50, 25 and 125 for Group,
Individual and Enterprise, I want the labels to show 25% for Group (50/200),
12.5% (25/200) for Individual and 62.5% (125/200) for Enterprise. Is this
possible? I don't want to switch to the 100% stacked column chart as that
put everything at 100%. I want to show the full value and then the
percentages within those sections.

 
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
Excel 2003 - Combination chart: Stacked Column + Stacked Column Robyda Charts and Charting in Excel 4 August 24th 08 03:16 PM
Needed: Chart that combines clustered column and stacked column types Gerry Charts and Charting in Excel 3 February 14th 07 02:53 AM
How to combine stacked column with a cluster column chart? Rwalsh Charts and Charting in Excel 1 December 19th 06 01:16 AM
How can I add a line chart in a stacked column chart style? Guilherme Loretti Excel Discussion (Misc queries) 0 August 3rd 06 01:46 AM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"