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.
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:
=A2amp; quot; quot; amp;TEXT(C2/SUM($C$2:$C$4)*360,quot;0.0quot;)
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:
gt; Could someone please let me know when you are showing data in a pie chart how
gt; you can also show the angles of each portion.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
- Jul 25 Fri 2008 20:44
Angles
close
全站熱搜
留言列表
發表留言