I have been trying to create a Pie Radar Chart as described in answer to this question.
Everything works until I get to the section that describes inserting a series to create the chart's outline:
To get the radial segment borders we need to add a new series. Set the title to be cell C1 ("Sector Weight") and the values to the rows in column C (C2:C9). Set the horizontal category axis labels to be your chart labels (G2:G9).
Change the chart type for this new series to a pie chart. Remove the fill for the pie segments and add black borders. Add data labels for the pie series, selecting the Category Name instead of Value and setting the position to Outside End.
My problem is, when right click on the Chart > Select Data > Add New Series
(as described above) and then change the Horizontal Category Axis Labels to the Chart Labels and click OK-there is no visible change to the chart.
I went to Chart Tools > Layout
and added the Legend back in to see if Sector Weight
showed up, and the legend does indeed show it. But, I can't click on it anywhere on the chart to change the series to a Pie Chart. If I change the whole chart (i.e. all series) to a Pie Chart then I get nothing that looks like the final chart in the tutorial with the sector borders.