Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a radar chart. In this chart I only want the grid to only have one grid ring. Currently it displayed all the minor grid rings and I only need one of those rings displayed. How do I change that? Furthermore, I only want one point value for the radar chart to display. That point value should correlate with the grid ring as I stated before. Is there a way I can fix this?
Thank you for your help
Maybe you can use a reference line instead of the grid - as you can control the reference line with a constant value / variable or expression. And you can also layout e.g. the color
This gets rid of all the 'rings' . Is it closer to what you want ? I selected 'hide axis' on the presentation tab of the chart properties.
Maybe you can use a reference line instead of the grid - as you can control the reference line with a constant value / variable or expression. And you can also layout e.g. the color
Thank you both for your help. So I hide the axis as you suggested and that worked better. When I entered in my value for the reference line it would not post for some reason. Currently what I have is attached. What I would like to do is: put an axis around the middle of that radar chart. I only want one axis to display at the middle value which is 200,000. How should I do this?
Hi james - i tested daniels reply too ( and 'liked it' as well:) ) ... make sure you add the number as the expression AND label
also make sure the color is not transparent and its has a weight > 0pt.
Finally ... try re-enabling the axis to just ensure 200,000 is actually in the range.
Lastly, the chart is dynamic and will not 'stretch out' to show the reference line if the values are smaller. You may need to add a 'max value' on the axis tab to something greater than 200,000 to ensure its always viewable.
Thank you for the help. I forget to add the value in the expression section. It works great now.