Trying to total the column values in my chart?
 

Hi !!
I am using the Stacked Column with a 3-d visual effect chart. I am
charting 6 months worth of numbers with 5 values in each column. I would
like to add up the totals in each column of my chart to make a heading (or
something). Can this be done?

Thanks !
K8T

Trying to total the column values in my chart?
 

Hi,

The last section of this page shows you how to add a total to a 3-d stack.
http://www.andypope.info/charts/StackColTotal.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"K8T" wrote in message
...
Hi !!
I am using the Stacked Column with a 3-d visual effect chart. I am
charting 6 months worth of numbers with 5 values in each column. I would
like to add up the totals in each column of my chart to make a heading (or
something). Can this be done?

Thanks !
K8T

Trying to total the column values in my chart?
 

This is not readily accomplished in a chart with 3D effects. But that's
okay, because switching to a 2D chart can only improve the chart.

Make another series that represents the totals you want to display. Add this
data to the chart as a new series. At first this series will appear as a new
column stacked on the rest. Select it, go to Chart menu Chart Type, and
select a Line chart style to change this series. Double click this series,
and on the Data Labels tab, choose the Values option, then on the Patterns
tab, select no lines and no markers. Click OK, then double click on the
labels, and on the Alignment tab, choose Above from the position dropdown.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"K8T" wrote in message
...
Hi !!
I am using the Stacked Column with a 3-d visual effect chart. I am
charting 6 months worth of numbers with 5 values in each column. I would
like to add up the totals in each column of my chart to make a heading (or
something). Can this be done?

Thanks !
K8T

Trying to total the column values in my chart?
 

Thank you so much, that worked. I knew there was a way to do it but
couldn't quite figure it out.

Thank you !!
K8T

"Jon Peltier" wrote:

This is not readily accomplished in a chart with 3D effects. But that's
okay, because switching to a 2D chart can only improve the chart.

Make another series that represents the totals you want to display. Add this
data to the chart as a new series. At first this series will appear as a new
column stacked on the rest. Select it, go to Chart menu Chart Type, and
select a Line chart style to change this series. Double click this series,
and on the Data Labels tab, choose the Values option, then on the Patterns
tab, select no lines and no markers. Click OK, then double click on the
labels, and on the Alignment tab, choose Above from the position dropdown.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"K8T" wrote in message
...
Hi !!
I am using the Stacked Column with a 3-d visual effect chart. I am
charting 6 months worth of numbers with 5 values in each column. I would
like to add up the totals in each column of my chart to make a heading (or
something). Can this be done?

Thanks !
K8T