| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Show total in a Stacked Chart
Is it possible to display a total value for each stacked column on a stacked
chart. I'm able to show the values for the various series of each column, but can't seem to find a way to show a total. Thanks, B |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Show total in a Stacked Chart
Hi,
Simplest way is to add an additional data series to the chart, which is the sum of the stacked data series. And plot this as a line chart. You can format the line series to have no line color or markers. The data labels will display the total value and can have the alignment property set to Above. Cheers Andy Bryan Potter wrote: Is it possible to display a total value for each stacked column on a stacked chart. I'm able to show the values for the various series of each column, but can't seem to find a way to show a total. Thanks, B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
| Possible to show clustered and stacked columns on one chart? | Charts and Charting in Excel | |||
| Total on Stacked Column Chart | Excel Discussion (Misc queries) | |||
| How do I get total value data labels in a stacked bar chart? | Charts and Charting in Excel | |||
| show aggregate total in pie chart | Charts and Charting in Excel | |||
Linear Mode
