Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 99
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what do you use a doughnut chart for QuietRanger Charts and Charting in Excel 4 December 8th 06 02:25 PM
doughnut charts daz Charts and Charting in Excel 0 April 27th 06 11:30 AM
Problem with Pie and Doughnut Charts pmtw Charts and Charting in Excel 1 April 4th 06 05:43 PM
Label Doughnut-Chart outside Steeplechase Charts and Charting in Excel 4 February 2nd 06 09:20 AM
Office Web Components; combined chart Doughnut/Scatterline doesn't work hstaaks Charts and Charting in Excel 1 May 27th 05 06:05 PM


All times are GMT +1. The time now is 03:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"