Thread: Angles
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Debra Dalgleish
 
Posts: n/a
Default 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