How-to Highlight or Color Rings in an Excel Radar Chart

Recently a user in an Excel Forum wanted to know if there was any way to highlight or color the outside ring of an Excel Radar Chart in red.  This is what I presented this user and he was very excited to learn how easy it was to make this type of radar chart:

image

It is actually kind of a simple solution that can be used in many different Excel applications.  In the Sample Excel Radar Chart below, you can see that I have colored in all the Excel Radar chart rings in a gradient fashion to highlight the various sections.

image

Let’s get started and see how you can make this type of Radar Chart for your Executives in your next Company Dashboard.





The Breakdown

1) Add an additional series to your radar chart so that is in the middle of the ring you wish to highlight.

2) Move the additional series up so that it is the first series in the chart.

3) Change the additional series line color to Red.

4) Increase the point size of the additional series line so that it fills up the ring of the Radar Chart.


SPECIAL - SAVE 10% until July 20th. Use code EDT.


5) Wow and amaze your executives as they drool over your really cool Excel Charts in you Company Dashboard.

Step-by-Step Tutorial

Here is a step-by-step on how-to make this chart in Excel.  Following this is a free sample tutorial file as well as a video demonstration.

1) Here is how I set up my original data:image

But we need to add an additional series that will be right in the middle of the last ring.  If you don’t know what that value will be, well, just make a quick Radar Chart and see what are the last ring values.





image

In our case, the last ring goes from 80 to 100.  Therefore, we need to add another series that is between those numbers (in our case 90) for all categories.

So insert a column for the data between column A and column B and title it Red Ring for the Red Ring Series.  It will look like this: image

This is the easiest way to create this Excel Radar Chart with this additional colored ring.  Alternately, if you need to keep your data and categories intact and add therefore the Red Ring series is to the right or your data series, you will need to follow the step 3.

2) Create your Excel Radar Chart:


SPECIAL - SAVE 10% until July 20th. Use code EDT.


Highlight from cell A1 to C13

image

In Excel 2010 or Excel 2007, click on the Insert Ribbon and Choose Other Charts and then select Radar Chart:SNAGHTML12a7c17c

Your resulting Excel Radar Chart will look like this:

image





2) Skip this Step if you were able to set up your data so that the Red Ring series is the first column of data after your Chart Categories.  This is an Alternate step that is only needed if your Red Ring data series in the Radar Chart is not the first series after your chart categories.

We need to make sure that the Red Ring series is the first data series in the Legend Entries (Series).  You can do this by selecting the chart, then click on the Design Ribbon and then Click on the Select Data button in the Data group.

SelectDataMenu

Then move the Red Ring series to the top by clicking on the Move Up button.SNAGHTML12b7083c

We need to do this so that the colored radar chart ring will not overlap our actual data, thus hiding or obscuring the data from chart.


SPECIAL - SAVE 10% until July 20th. Use code EDT.


3) Okay, we are getting real close, so lets change the Red Ring series line color to Red.  You can do this by clicking on the chart, then Right click on the Red Ring chart series and choose “Format Data Series…” from the pop-up menu.

image

Then choose the Line Color group in the Format Series Dialog Box, choose Solid Line radio button and then choose Red from the colors.

image

To make the color of the Data Series stand out, I would also change its line color to Green.  Your chart now looks like this:





image

4) Now, the only thing left for us to do is to fill up the Excel Radar Chart Ring section with the color red.  To do this, we need to increase the point size of the additional series line so that it fills up the ring of the Radar Chart.

Right click on the Red Ring data series and then choose “Format Data Series…”.  Then choose the Line Style sub menu and we need to change the Width so that it fills up the Radar Chart Ring.  In our case, it is find to put in anything between 15 and 20. image

Here is your final chart:

image


SPECIAL - SAVE 10% until July 20th. Use code EDT.


As you can see, this highlights our upper ring of our Excel Radar Chart.  You can use this Excel Chart technique to fill each of the Radar Rings.  If you want to do this, you need to create a data series in the middle of each Radar Ring and then follow the Excel Trick above.  Here is a sample of how I set up the data to color each Ring of the Excel Radar Chart.image

This is a great way to highlight a specific Radar Ring in Excel Dashboards and you can use this tip in your next Dashboard Template.

Free Excel Sample Download Template and Tutorial File:

Colored-Ring-Sections-in-Excel-Radar-Chart-Sample-File.xlsx

 





Video Demonstration:

 

Please let me know how you think you can use this Excel Tip and Trick in your next Excel Executive Dashboard in the comments below.

Steve=True


SPECIAL - SAVE 10% until July 20th. Use code EDT.






6 COMMENTS

  1. I’m glad you made this Tutorial. I just completed a Lighting upgrade in my facility and want to show the before/after lighting levels overlaid on color bars with recommended lighting levels. I haven’t tried your instructions yet, but it looks like this is exactly what I will need. Thank You.

    • Hi TH. It cannot be done with the standard Radar Chart. You would have to make it with an XY chart and would take some work.

  2. Hey, I did this and it was great thanks. But now I have an unwanted entry in my legend called ‘red ring’ for example. How do I delete this without getting rid of the data? I can’t just simply click and delete it from my legend for some reason

    • Hi Amber, yes you can delete it. Simply select the chart, then select the legend, then select the legend entry and then press the Delete key on your keyboard.

LEAVE A REPLY

Please enter your comment!
Please enter your name here