Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Radar Chart | Charts and Charting in Excel | |||
Radar Plot using geographical coordinates | Charts and Charting in Excel | |||
radar chart & labels | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel |