how to make a pie chart in excel with two column of data

(Note - If you're using Excel 2003 or earlier you will need to flip this table round so the table is vertical (transpose) because the number of columns used by this method is greater than the number allowed by old versions of Excel.) Make sure you copy this for all rows and columns for 0-360 degrees. For each cell, add some logic that checks whether the angle for that column is covered by the Start/Final Angles - and if so return the value for that row. Let's extend our table, with a column for each angle (shaded grey in my example). Now the trick to making a radar chart think it's a pie chart is to create data points for every one of the 360 degrees in a circle. In a 'Finish Angle' column multiply the cumulutive figure for '% of 360' by 360. In the top row enter 0, then for each row below reference the cell above. Next we need to calculate the start and end angles that each sector covers. Add a column called '% of 360', dividing the sector weight by the sum of all sector weights.

Now we need to calculate the slice proportions that each sector needs to cover. eg if you wanted 'WORK' to appear as a double/triple/quadruple-sized slice, just change the sector weight to 2/3/4 etc.

In your example we want all the sectors to be the same size, but let's make things flexible and add in a sector weight column. There's a bit of data manipulation to do before we create the chart. Let's say this is the data you're starting with. This walkthrough is based on Andy Pope's original tutorial here.

How to make a pie chart in excel with two column of data