CODEWITHSUNDEEP
excelexcel-2013radar-chart
yamori
yamori

Reputation: 1243

Add radial lines to radar chart

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.

Upvotes: 3

Views: 61407

Answers (5)

Ndini Wenyu
Ndini Wenyu

Reputation: 1

In Excel for Mac version 16, 1. Create your radar chart. 2. Change chart type to any other chat type. 3. With your new chat selected. Go to Insert==>Chart==>Radar (the chart now allows you to format Y axis).

Upvotes: 0

neko
neko

Reputation: 11

How about the code below?

ActiveChart.Axes(xlCategory).hasMajorGridlines=true

  1. Select the target chart on excel.

  2. Press Alt+F11 on excel, then VBE opens.

  3. Press Ctrl+G on VBE, then immediate window opens.

  4. Paste the above code.

  5. Place the cursor on the line of the code and press the enter key.

I made the file with PHPExcel and edit it with excel 2010.

p.s. I confirmed with Excel 2016 without PHPExcel, too.

Upvotes: 1

Jeff
Jeff

Reputation: 1

Right click the rectangular edge of the overall chart. Click "Chart Area" drop down. Select "radar (value) axes" and click the pen icon to select a colour.

Upvotes: 0

dginelli
dginelli

Reputation: 409

These are the steps that I follow to add radial lines:

  • Create radar chart;
  • Click on the radar chart to show the Chart Design tab on toolbar;
  • Click on Change Chart Type and select Radar, then "Radar with Markers" or "Filled Radar";
  • Click on Add Chart Elements (on the toolbar), then click on Axes, More Axes Options...;
  • Click on Fill & Line icon (under the button "Axis Options"), find Line section and click on Solid line.

Line

Upvotes: 3

teylyn
teylyn

Reputation: 35935

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

Upvotes: 13

Related Questions