Colored Radar Charts

**je551cashe** · 09-28-2011, 04:39 AM

Hi All,

Does anyone know how to colour/fill-in the rings of a radar chart? I'm trying to create something like a bullseye, with the center ring red, next ring blue, next ring yellow, next ring green etc.. or the rings different shades of blue preferably.

The only problem is that I will be using a pivot table to create the chart to be able to filter the data on the fly. So when the rings aren't needed the colours disappear or change if possible.

Thanks....

**teylyn** · 09-28-2011, 04:48 AM

Attached is a file with two radar charts. One based on a regular table, the other one a Pivot Chart.

If that does not do what you need to do, then please post a workbook and explain in context.

cheers,

**je551cashe** · 10-05-2011, 08:26 AM

Hi,

How do you create the above file, could you attach a file with the steps in or explain over here, as that is what I would like

I have attached the file, of what I am looking to do but have the radar chart filled in.

Cheers,
Je551cashe

**teylyn** · 10-05-2011, 04:26 PM

Hello,

the file I attached uses the filled radar chart type. But looking at your file, I see that what you want is to have a background of concentric rings for your chart.

That won't be possible with charting tricks. But you could use a picture fill for the plot area. Create a suitable drawing with the drawing tools, save it as a picture and use it as the source for a picture fill.

cheers,

**Vinnie12** · 09-24-2012, 11:45 AM

I have some related questions on the fill of a radar chart. Looking at your example of a normal chart how can I:
- adjust the colours of the rings?
- add a chart without fill?

Regards,

**arlu1201** · 09-24-2012, 12:07 PM

Vinnie12,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.