• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Radar chart with different colour rings

Hello Chandoo colleagues. We've been asked to include in our monthly presentations to management a radar chart that has different background colours based on specific value ranges (<10, 10-50 and >50). To put it simpler, a radar chart with different colour rings (green, orange and yellow).

This has been done using 3 helper columns to set the position of each ring and then manually adjusting their width.

Is there a way to automate this process and make it more accurate?

Ideally we would want every time the data is updated or the chart size is changed the width of the rings to be updated also to match the relevant value ranges.

Many thanks,