Add radial lines to radar chart

excel excel-2013 radar-chart
yamori picture yamori · Sep 22, 2015 · Viewed 47.2k times · Source

I'm using Office 2013 Excel and making a radar chart. By default the concentric rings are visible, but I want spokes or radial lines from the center to each category on the outside. I can't find out how to do this.

Answer

teylyn picture teylyn · Sep 23, 2015

It seems to be a bug in Excel 2013 (and 2016).

A workaround is:

  • Create a radar chart.
  • Change the chart type to one of the other two radar charts, for e.g. radar with markers.
  • Change the chart type back to the original radar chart and format the Y axis to have lines.

enter image description here

Related questions

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, …

Read More
Excel: Searching for multiple terms in a cell

I use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",C1)),"1","") This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1. All I'd like …

Read More
Clear contents and formatting of an Excel cell with a single command

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use .ClearFormats. Sheets("Test").Range("A1:C3").ClearContents Sheets("Test").Range("…

Read More