Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing the Grand Total on Data Labels
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 FormatSelected 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 FormatSelected 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing the Grand Total on Data Labels
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 FormatSelected 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 FormatSelected 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing the Grand Total on Data Labels
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 FormatSelected 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 FormatSelected 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Excel charts should let me select a range for data labels. | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Data not showing on my chart | Charts and Charting in Excel |