There, select the option “Format Gridlines”. Select major gridlines and right-click on them to open an Options Menu. Step 9 – You also can change the color of “Major Gridlines”. Step 8 – Now, change the colors of the other quarter sales line as well in the chart. I will choose a different color for the first-quarter sales line. Step 7 – As soon as you click on that Outline option, you’ll be able to customize the colors of quarter web lines. Click on the line associated with first-quarter values (Blue line) and right-click on it you’ll see a series of options popping up there you have one option called Outline. Step 6 – You can change the color of the webs associated with each quarter.

I will add the title as Quarterly Sales for the Last Six Years. Step 5 – You can add the title for this report under Title Section. Once you click OK, you’ll be able to see a radar chart, as shown in the image below. Once done with choosing the layout of your interest, click on the OK button. Inside this, I will choose the second layout as it has years marked as legend entries. It allows me to have bullet markers at each intersection point of the web. I will choose the second one, “Radar with Markers”. Step 4 – You can choose any radar chart for proceeding as per your convenience. Each of these categories has three sub-layouts of radar charts based on the visuality as well. A soon as you click on the Radar option, you’ll be able to see multiple radar chart layouts, namely Radar, Radar With Markers and Filled Radars.

Out of those, click on the “Radar option”. Step 3 – Inside the All chart option, you will see a list of all chart templates that are compatible in excel on the left-hand side of the window.

Select the “All Charts” option through the window popping up named “Insert Chart”.

Step 2 – Under the Charts option, click on the “Recommended Charts” icon.

Step 1 – In the active excel worksheet, select all the data across A1 to E7 and then click on the “Insert” tab placed at the third place on the upper hand ribbon of excel. You can download this Radar Chart Excel Template here – Radar Chart Excel Template

TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (35+).

Create pie chart in excel 2016 mac