#1   Report Post  
Shadowrift
 
Posts: n/a
Default 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!
  #2   Report Post  
Bryan Hessey
 
Posts: n/a
Default


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

  #3   Report Post  
Shadowrift
 
Posts: n/a
Default

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


  #4   Report Post  
Shadowrift
 
Posts: n/a
Default

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


  #5   Report Post  
Jon Peltier
 
Posts: n/a
Default

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




  #6   Report Post  
Bryan Hessey
 
Posts: n/a
Default


Good news, and thanks for the response.

Shadowrift Wrote:
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




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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Radar Chart Angus Robinson Charts and Charting in Excel 1 June 24th 05 04:09 AM
Radar Plot using geographical coordinates David Charts and Charting in Excel 2 May 31st 05 08:06 PM
radar chart & labels uriel78 Charts and Charting in Excel 1 April 22nd 05 08:45 PM
change axis info on radar charts alfred Charts and Charting in Excel 1 January 11th 05 04:36 AM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"