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.
