Anastasis Tsiropoulos
New Member
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,
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,