Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data labels on a stacked chart
I have a simple stacked bar chart, but i would like to display the total for
the two items stacked for each bar. For example, hearth is $100 and is stacked over Indoor with a value of $200. I can display the data label of each, but would like to display $300 instead. |
#2
|
|||
|
|||
whouser,
There are several ways that you can do this. One way is to create a secondary reference that consists of the data labels. For example, assume you have this data for your stacked bar chart. Series1 Series2 a 100 200 b 150 250 c 125 100 Set up an additional reference that adds the data for the two series together. Series1 Series2 Labels a 100 200 300 b 150 250 400 c 125 100 225 Then use a data labeling tool or macro to connect a reference from Series2 to Labels. You can find a list of where to get those tools he http://www.pdbook.com/index.php/exce...t_data_labels/ -- Regards, John Mansfield http://www.pdbook.com "whouser" wrote: I have a simple stacked bar chart, but i would like to display the total for the two items stacked for each bar. For example, hearth is $100 and is stacked over Indoor with a value of $200. I can display the data label of each, but would like to display $300 instead. |
#3
|
|||
|
|||
Hi,
Here is a way using the data labels of an extra data series. http://www.andypope.info/charts/StackColTotal.htm Cheers Andy whouser wrote: I have a simple stacked bar chart, but i would like to display the total for the two items stacked for each bar. For example, hearth is $100 and is stacked over Indoor with a value of $200. I can display the data label of each, but would like to display $300 instead. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Thanks, guys. This works great. I appreciate both your answers.
"Andy Pope" wrote: Hi, Here is a way using the data labels of an extra data series. http://www.andypope.info/charts/StackColTotal.htm Cheers Andy whouser wrote: I have a simple stacked bar chart, but i would like to display the total for the two items stacked for each bar. For example, hearth is $100 and is stacked over Indoor with a value of $200. I can display the data label of each, but would like to display $300 instead. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
How do I get my data labels on a pivot chart to retain their form. | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Setting up data to create a chart | Excel Worksheet Functions |