radar graph
I regularly use a radar graph to plot 24 points of information.
I now need to create a radar graph where I only need to plot 4 points of information--but when I set up the graph, the graph is square, rather than round. I need to have these 4 points graphed on a round radar graph. Is there any way to do this? I thought interpolating the information would help, but it does not. |
radar graph
You get a 4-sided polygon instead of a 24-sided polygon (not a circle),
because you have 4 categories and values, not 24. If you use data like this: Values a 1 b c 3 d e 2 f g 2 h with blanks in between the values, you'll get the effect you want. You'll have to select the chart, go to Options on the Tools menu, and on the Chart tab, where it asks how to display blanks, choose Interpolate. My example data has an octagon with four populated points. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Russell-stanely wrote: I regularly use a radar graph to plot 24 points of information. I now need to create a radar graph where I only need to plot 4 points of information--but when I set up the graph, the graph is square, rather than round. I need to have these 4 points graphed on a round radar graph. Is there any way to do this? I thought interpolating the information would help, but it does not. |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com