#1   Report Post  
Posted to microsoft.public.excel.charting
smartie123
 
Posts: n/a
Default 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   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

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
How to do I convert angles from radians to degrees in Excel? HELP ME PLEASE!!!!! Excel Worksheet Functions 2 January 13th 06 08:20 PM
How do i convert angles from degrees,minutes, seconds to decimal morne Excel Discussion (Misc queries) 1 November 23rd 05 03:09 PM
Cell Formatting for Angles Jay Excel Worksheet Functions 2 August 8th 05 06:13 PM
HOW DO I CONVERT ANGLES TO DECIMAL DEGREES LTHSATT Excel Worksheet Functions 1 June 7th 05 03:18 AM


All times are GMT +1. The time now is 03:07 PM.

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

About Us

"It's about Microsoft Excel"