close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()