Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pls HLP - Label Above Column in Stacked Chart
I am working with stacked "floating" charts and have almost succeeded in
doing what I want... However, I would like both the value of the column, plus the % of the total, to appear ABOVE the columns. Is there any way of doing this besides a text box? Thanks so much! -- Thanks! Dee |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pls HLP - Label Above Column in Stacked Chart
Hi,
Create a set of cells which contains the total. Plot this as a line series. You can then use the line series data labels. Position these to be plotted above the point and then remove all formatting from the line are markers. I explain a similar technique here, but use a column series instead of line. http://www.andypope.info/charts/StackColTotal.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dee" wrote in message ... I am working with stacked "floating" charts and have almost succeeded in doing what I want... However, I would like both the value of the column, plus the % of the total, to appear ABOVE the columns. Is there any way of doing this besides a text box? Thanks so much! -- Thanks! Dee |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pls HLP - Label Above Column in Stacked Chart
I think I'm lost. I have been up all night working on this, so am very
tired.. I managed to get the look I want by dragging (individually) the value of each column, plus had added a % column who columns I hid, but kept the % value and moved them up to the top of the column as well. It worked, but is manual. Your way is probably automatic, but I'm not understanding it. This is my data: Product Last Year Current Year This year % LLM002 125 151 (22%) LLM003 145 95 (14%) LLM004 74 135 (20%) MNO443 99 154 (22%) MNO444 54 77 (11%) MNO445 44 55 (8%) MNO446 11 24 (3%) Total 691 (100%) I hide last years pattern and line to create the floating affect, and do the same for the %. Then I manually take each box and move it up and out of the column. -- Thanks! Dee "Andy Pope" wrote: Hi, Create a set of cells which contains the total. Plot this as a line series. You can then use the line series data labels. Position these to be plotted above the point and then remove all formatting from the line are markers. I explain a similar technique here, but use a column series instead of line. http://www.andypope.info/charts/StackColTotal.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dee" wrote in message ... I am working with stacked "floating" charts and have almost succeeded in doing what I want... However, I would like both the value of the column, plus the % of the total, to appear ABOVE the columns. Is there any way of doing this besides a text box? Thanks so much! -- Thanks! Dee |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pls HLP - Label Above Column in Stacked Chart
Assuming your data is in cells A1:D9 add this formula to E2 and copy down to
E9 =B2+C2 Now add a series to the chart based on the range E2:E9 Select this series and change the chart type to line. Via the Format dialog change the line to the secondary axis. Via the Source Data dialog set the category labels for the secondary axis to be D2:D9 Again format the line series to display Category data labels. Set marker and line to none. Format data label to be positioned above point. Finally delete the secondary Y axis. The labels should now be positioned above the stacked columns. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dee" wrote in message ... I think I'm lost. I have been up all night working on this, so am very tired.. I managed to get the look I want by dragging (individually) the value of each column, plus had added a % column who columns I hid, but kept the % value and moved them up to the top of the column as well. It worked, but is manual. Your way is probably automatic, but I'm not understanding it. This is my data: Product Last Year Current Year This year % LLM002 125 151 (22%) LLM003 145 95 (14%) LLM004 74 135 (20%) MNO443 99 154 (22%) MNO444 54 77 (11%) MNO445 44 55 (8%) MNO446 11 24 (3%) Total 691 (100%) I hide last years pattern and line to create the floating affect, and do the same for the %. Then I manually take each box and move it up and out of the column. -- Thanks! Dee "Andy Pope" wrote: Hi, Create a set of cells which contains the total. Plot this as a line series. You can then use the line series data labels. Position these to be plotted above the point and then remove all formatting from the line are markers. I explain a similar technique here, but use a column series instead of line. http://www.andypope.info/charts/StackColTotal.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "dee" wrote in message ... I am working with stacked "floating" charts and have almost succeeded in doing what I want... However, I would like both the value of the column, plus the % of the total, to appear ABOVE the columns. Is there any way of doing this besides a text box? Thanks so much! -- Thanks! Dee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing Percentage Value Data Label in a 100% Stacked Column Chart | Charts and Charting in Excel | |||
Data series label in Stacked Chart | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
Percent Data Label on 100% Stacked Column Chart | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |