Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stacked column-chart Excel 2007
Hi!
I often use stacked column-chart in Excel 2007. I normally show the data labels in the chart. Usually I have 2 or 3 data-series. Is it possible to show the accumulated value at the top of each column/bar? If one series shows 10 and the other one shows 30, then I want to show the accumulated vaule 40 at the top of the bar. This is not a big issue, but I wonder if there is possible to show the accumulated value at the top. My boss will be very satisfied if this is possible ;-) -- Atri |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stacked column-chart Excel 2007
Atri wrote:
Hi! I often use stacked column-chart in Excel 2007. I normally show the data labels in the chart. Usually I have 2 or 3 data-series. Is it possible to show the accumulated value at the top of each column/bar? If one series shows 10 and the other one shows 30, then I want to show the accumulated vaule 40 at the top of the bar. This is not a big issue, but I wonder if there is possible to show the accumulated value at the top. My boss will be very satisfied if this is possible ;-) One way: Add a total column (assuming your series are in columns) to compute the total for the category. Add this as a new series to your chart. If you did this correctly the total bars will stack on top of the others, thus doubling the height. Now set the properties of the total series such that: -it uses the secondary x-axis -fill and line are "none" -data labels are turned on |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stacked column-chart Excel 2007
Thanks a lot! It worked.
-- Atri smartin skrev: Atri wrote: Hi! I often use stacked column-chart in Excel 2007. I normally show the data labels in the chart. Usually I have 2 or 3 data-series. Is it possible to show the accumulated value at the top of each column/bar? If one series shows 10 and the other one shows 30, then I want to show the accumulated vaule 40 at the top of the bar. This is not a big issue, but I wonder if there is possible to show the accumulated value at the top. My boss will be very satisfied if this is possible ;-) One way: Add a total column (assuming your series are in columns) to compute the total for the category. Add this as a new series to your chart. If you did this correctly the total bars will stack on top of the others, thus doubling the height. Now set the properties of the total series such that: -it uses the secondary x-axis -fill and line are "none" -data labels are turned on |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Stacked column chart with white data labels | Charts and Charting in Excel | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
Combination Column and Stacked Column Chart in XL 2007 | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |