ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   can the doughnut chart key be in words (https://www.excelbanter.com/charts-charting-excel/171002-can-doughnut-chart-key-words.html)

lili class

can the doughnut chart key be in words
 
i have a balance sheet the has to be presented in a doughunt chart but the
key has to be in words.

using office 2003. if it is possible please could i have a step by step
explanation

Andy Pope

can the doughnut chart key be in words
 
Hi,

The key will display the text you specify as the Name of the series.
Normally the text is held within a cell at the head of each data series.
You can use the Source Data dialog to set the Name of each series,
either as a reference to a cell or text.
Right click chart and pick Source Data...
On the series tab is the place to change the Name.

Cheers
Andy

lili class wrote:
i have a balance sheet the has to be presented in a doughunt chart but the
key has to be in words.

using office 2003. if it is possible please could i have a step by step
explanation


Ed Ferrero[_2_]

can the doughnut chart key be in words
 
Hi lili,

i have a balance sheet the has to be presented in a doughunt chart but the
key has to be in words.

using office 2003. if it is possible please could i have a step by step
explanation


If the data looks like this;

Col A Col B
Eenie 20
Meenie 12
Miinie 40
Mo 25

Then select both columns, use menu item Insert - Chart - Doughnut and
click Finish.
The resulting doughnut chart will show a legend with the label in Col A for
each value.

Right-click the doughnut, select Format Data Series, click the Data Labels
tab, check the 'Category name' box.
That will show the data labels inside the doughnut.

Does this help?

Ed Ferrero
www.edferrero.com



All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com