Thread: Radar Map

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!

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


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

Originally Posted by Shadowrift

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!

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


"Bryan Hessey" wrote:

>
> Hi, I cannot duplicate that error on the outer web, but if I
> stretch/shrink the chart window size sideways or vertically there is a
> point (around a square chart) that I lose most of the internal webbing,
> occasionally losing just one internal web section, but if I continue the
> sizing the webbing is returned.
>
>
> Have you tried rightmouse, Chart Data, the Series tab, and re-selected
> the range?
>
>
> Shadowrift Wrote:
> > 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
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=395472
>
>

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

"Shadowrift" wrote:

> 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
>
>
> "Bryan Hessey" wrote:
>
> >
> > Hi, I cannot duplicate that error on the outer web, but if I
> > stretch/shrink the chart window size sideways or vertically there is a
> > point (around a square chart) that I lose most of the internal webbing,
> > occasionally losing just one internal web section, but if I continue the
> > sizing the webbing is returned.
> >
> >
> > Have you tried rightmouse, Chart Data, the Series tab, and re-selected
> > the range?
> >
> >
> > Shadowrift Wrote:
> > > 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
> > ------------------------------------------------------------------------
> > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> > View this thread: http://www.excelforum.com/showthread...hreadid=395472
> >
> >

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/
_______


Shadowrift wrote:

> 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
>
>
> "Bryan Hessey" wrote:
>
>
>>Hi, I cannot duplicate that error on the outer web, but if I
>>stretch/shrink the chart window size sideways or vertically there is a
>>point (around a square chart) that I lose most of the internal webbing,
>>occasionally losing just one internal web section, but if I continue the
>>sizing the webbing is returned.
>>
>>
>>Have you tried rightmouse, Chart Data, the Series tab, and re-selected
>>the range?
>>
>>
>>Shadowrift Wrote:
>>
>>>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
>>------------------------------------------------------------------------
>>Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
>>View this thread: http://www.excelforum.com/showthread...hreadid=395472
>>
>>

Good news, and thanks for the response.

Originally Posted by Shadowrift

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

"Shadowrift" wrote:

> 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
>
>
> "Bryan Hessey" wrote:
>
> >
> > Hi, I cannot duplicate that error on the outer web, but if I
> > stretch/shrink the chart window size sideways or vertically there is a
> > point (around a square chart) that I lose most of the internal webbing,
> > occasionally losing just one internal web section, but if I continue the
> > sizing the webbing is returned.
> >
> >
> > Have you tried rightmouse, Chart Data, the Series tab, and re-selected
> > the range?
> >
> >
> > Shadowrift Wrote:
> > > 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
> > ------------------------------------------------------------------------
> > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> > View this thread: http://www.excelforum.com/showthread...hreadid=395472
> >
> >