Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2007

Tip: Looking for answers? Try searching our database.

can the doughnut chart key be in words

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lili class - 28 Dec 2007 23:45 GMT
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 - 29 Dec 2007 09:25 GMT
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

> 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 - 29 Dec 2007 09:25 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.