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....