![]() Set the major gridline line weight to be 2pt and black for the outer circle border. Switch on Major & Minor Horizontal Gridlines: Close the dialog box, then delete the axis numbers on the chart. Set the major unit fixed to 10 (your maximum value) and the minor unit fixed to 1. Right-click the remaining axis and choose Format Axis. You'll get this.ĭelete the legend and the circular data labels (highlighted yellow). Insert a chart - under the radar chart options choose the end one - "Filled Radar". Select all cells under the "Chart Labels" and 0-360 columns (G2:ND9 in this example). I'm just going to refer to the titles in column A but you might want to customise them here. For flexibility's sake let's add a "Chart Labels" column between the final Angle and the 0-360 degrees. (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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |