If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Angles
Could someone please let me know when you are showing data in a pie chart how
you can also show the angles of each portion. |
#2
|
|||
|
|||
Angles
You can calculate the angle on the worksheet, and include that in the
chart label. For example, with the following data in cells A2:B4 -- Jan 57 Feb 36 Mar 91 Insert a column between A and B In cell B2, enter the formula: =A2& " " &TEXT(C2/SUM($C$2:$C$4)*360,"0.0") Copy the formula down to cell A4 Select cells B2:C6, and create a pie chart, showing Category Name and Value as labels. smartie123 wrote: Could someone please let me know when you are showing data in a pie chart how you can also show the angles of each portion. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I remove corner angles showing up in Microsoft Word 2002? | Kimberly_1960 | General Discussion | 2 | December 28th, 2005 04:07 PM |
How do i convert angles from degrees,minutes, seconds to decimal | morne | General Discussion | 1 | November 23rd, 2005 02:09 PM |
How to get rid of right angles appearing in the four corners of a | David G. | General Discussion | 2 | September 21st, 2005 12:05 AM |
How do i draw a box with arbitrary angles in Visio 2003? | vgo | Visio | 1 | March 3rd, 2005 09:38 AM |
Annoying angles in each corner of the Office Word page | Finn | Page Layout | 4 | September 3rd, 2004 11:27 PM |