Radar Map

[Guest]

Hi,

Im using a radar map to display data. I have added in a new field that is
automatically inserted into radar map (where the map gets its data from).

The problem is, the web encircling the radar map no longer reaches around
the entire radar map. There is a break at the new axis.

Can someone inform me how to make it so that the web reaches around the
entire radar again? what formatting field needs to be edited? or which data
needs needs to be checked and how and where to find it.

Thanks!

 

[Bryan Hessey]

Hi, I cannot duplicate that error on the outer web, but if
stretch/shrink the chart window size sideways or vertically there is
point (around a square chart) that I lose most of the internal webbing
occasionally losing just one internal web section, but if I continue th
sizing the webbing is returned.


Have you tried rightmouse, Chart Data, the Series tab, and re-selecte
the range?

 

[Guest]

Thanks for responding Bryan

Ok, it seems that because the webbing of calculated points only show up
after submitting, that part works fine. No broken webbing for the calculated
fields. It is however the red, yellow and green default webbing that is
broken now that the new axis has been added:

http://rich.toogeek.com/radargraph.gif

How does one fix this? i want those old existing lines to go all the way
around

 

[Guest]

i just hardcoded the series instead of using an invisible range that was
using before, not sure what upperbound is.

but this has solved my problem thanks

 

[Jon Peltier]

Your data is incomplete. I got a similar appearance with this data,
which has one fewer Y value per series than the number of X values:

Ser 1 Ser 2
a 1 2
b 1 2
c 1 2
d 1 2
e 1 2
f

If you're using dynamic ranges, check the way they are counting rows.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Bryan Hessey]

Good news, and thanks for the response.

i just hardcoded the series instead of using an invisible range that
was
using before, not sure what upperbound is.

but this has solved my problem thanks