Showing the Grand Total on Data Labels

I am building a column chart where several components are shown in each
column. I would like to display a total at the top of each column, but do not
want to show the breakdown amounts of the component pieces. When I use data
labels, it only displays the components, but not the total. Is there a way to
display the total at the top of each column without showing data labels for
the components? (I still want to show the components as coloured segments on
each column, but I don't want the numbers to show there... just a grand total
at the top of each column.)

Calculate the totals in your data, then add the totals to the
chart as a new series.
Right-click the Total series, and change the chart type to Line.
Right-click the Line, choose Format>Selected Data Series, and set the
Line to None and Markers to None
On the Data Labels tab, select Value, click OK
Right-click the Data Labels, choose Format>Selected Data Labels,
and select the Alignment tab
For Label Position, select Above
Click OK

Elnora wrote:
> I am building a column chart where several components are shown in each
> column. I would like to display a total at the top of each column, but do not
> want to show the breakdown amounts of the component pieces. When I use data
> labels, it only displays the components, but not the total. Is there a way to
> display the total at the top of each column without showing data labels for
> the components? (I still want to show the components as coloured segments on
> each column, but I don't want the numbers to show there... just a grand total
> at the top of each column.)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra! This worked great!

"Debra Dalgleish" wrote:

> Calculate the totals in your data, then add the totals to the
> chart as a new series.
> Right-click the Total series, and change the chart type to Line.
> Right-click the Line, choose Format>Selected Data Series, and set the
> Line to None and Markers to None
> On the Data Labels tab, select Value, click OK
> Right-click the Data Labels, choose Format>Selected Data Labels,
> and select the Alignment tab
> For Label Position, select Above
> Click OK
>
> Elnora wrote:
> > I am building a column chart where several components are shown in each
> > column. I would like to display a total at the top of each column, but do not
> > want to show the breakdown amounts of the component pieces. When I use data
> > labels, it only displays the components, but not the total. Is there a way to
> > display the total at the top of each column without showing data labels for
> > the components? (I still want to show the components as coloured segments on
> > each column, but I don't want the numbers to show there... just a grand total
> > at the top of each column.)
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome! Thanks for letting me know that it worked.

Elnora wrote:
> Thanks Debra! This worked great!
>
> "Debra Dalgleish" wrote:
>
>
>>Calculate the totals in your data, then add the totals to the
>> chart as a new series.
>>Right-click the Total series, and change the chart type to Line.
>>Right-click the Line, choose Format>Selected Data Series, and set the
>> Line to None and Markers to None
>>On the Data Labels tab, select Value, click OK
>>Right-click the Data Labels, choose Format>Selected Data Labels,
>> and select the Alignment tab
>>For Label Position, select Above
>>Click OK
>>
>>Elnora wrote:
>>
>>>I am building a column chart where several components are shown in each
>>>column. I would like to display a total at the top of each column, but do not
>>>want to show the breakdown amounts of the component pieces. When I use data
>>>labels, it only displays the components, but not the total. Is there a way to
>>>display the total at the top of each column without showing data labels for
>>>the components? (I still want to show the components as coloured segments on
>>>each column, but I don't want the numbers to show there... just a grand total
>>>at the top of each column.)
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html