Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to include the Grand Total Column in a pivot table chart? | Charts and Charting in Excel | |||
Total on Stacked Column Chart | Excel Discussion (Misc queries) | |||
Want chart to display total of values | Charts and Charting in Excel | |||
how to total 3 series in a column chart | Excel Discussion (Misc queries) | |||
If column A and column B have values how do i get the total in co. | Excel Discussion (Misc queries) |