software

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 Formatgt;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 Formatgt;Selected Data Labels,
and select the Alignment tab
For Label Position, select Above
Click OK

Elnora wrote:
gt; I am building a column chart where several components are shown in each
gt; column. I would like to display a total at the top of each column, but do not
gt; want to show the breakdown amounts of the component pieces. When I use data
gt; labels, it only displays the components, but not the total. Is there a way to
gt; display the total at the top of each column without showing data labels for
gt; the components? (I still want to show the components as coloured segments on
gt; each column, but I don't want the numbers to show there... just a grand total
gt; at the top of each column.)--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks Debra! This worked great!

quot;Debra Dalgleishquot; wrote:

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

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

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