G Guest Mar 9, 2006 #1 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.
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.
D Debra Dalgleish Mar 10, 2006 #2 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.
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.
