Radar charts: no blank space between series

**Lions** · 06-19-2014, 10:30 AM

Hi to everybody!
I'm Lions and I'm new of this forum.
I have a problem with Excel 07 and Radar chart.
I have data of mountain aspect surfaces and especially the distribution of data among cardinals points.
I would a part of Radar chart with a different colors and especially one color for the part with values over 70% of the maximum value and another color for the part with value between 30% and 70% of the maximum value. The remaining part will be with another color.
I tryed to make different series and I made a radar graph near to what I want. In the image RadarChart.jpg:
- red color: > 70%
- green color: >30% and <70%
- violet color: the remaining part
But how can I paste the series red/green/violet without blank spaces? The blank parts in between are just the transfer between the three series (or colors).

RadarChart.JPG

Is there any alternative way to make what I need with different method?

Thank you in advance

**Andy Pope** · 06-21-2014, 05:51 AM

You need to duplicate the point prior to the data appearing within the series.
See attached for example.

You will not be able to get the chart you want if there is less than 2 consecutive data values. As that would join the fill pattern incorrectly. The issue is you can not plot 2 values at any one spoke as the axis is categorical rather than value.