Angles

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie in pie chart - how do you change the angle of the 1st slice 1
pie charts instead of bubbles 3
How to create a table which calculates the angles in a Pie Chart? 2
PIE: tilt a 3d chart 2
Excel Compass angles in Excel 10
Line Chart - Problems with labeling X-Axis 3
Angling Label Text on a Chart 2
soften jagged edges of pie charts 1

Back
Top