|
Radar Chart with Variable X Scale
Does anyone know how to make a radar plot with a non-equal X axis. I would
like to specify a unique theta for each data point. |
Hi,
This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Yeh, I saw that one from a previous post. It allows for a variable Y per
each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Maybe this then
http://www.andypope.info/ngs/ng4.htm Taryn wrote: Yeh, I saw that one from a previous post. It allows for a variable Y per each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
I think I can make something of this. I'm having some issues.
1) If I change the scale it does not appear to rescale on the chart...say 1 is 10 2) how do I change the plot to go clockwise with zero at the top? "Andy Pope" wrote: Maybe this then http://www.andypope.info/ngs/ng4.htm Taryn wrote: Yeh, I saw that one from a previous post. It allows for a variable Y per each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Ok, I've figured out everything except the label holders for display axes
labels. "Taryn" wrote: I think I can make something of this. I'm having some issues. 1) If I change the scale it does not appear to rescale on the chart...say 1 is 10 2) how do I change the plot to go clockwise with zero at the top? "Andy Pope" wrote: Maybe this then http://www.andypope.info/ngs/ng4.htm Taryn wrote: Yeh, I saw that one from a previous post. It allows for a variable Y per each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Take a look at either of these free addins. Allowing you to link the
datalabels to cells. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy Taryn wrote: Ok, I've figured out everything except the label holders for display axes labels. "Taryn" wrote: I think I can make something of this. I'm having some issues. 1) If I change the scale it does not appear to rescale on the chart...say 1 is 10 2) how do I change the plot to go clockwise with zero at the top? "Andy Pope" wrote: Maybe this then http://www.andypope.info/ngs/ng4.htm Taryn wrote: Yeh, I saw that one from a previous post. It allows for a variable Y per each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thanks for all your help. Using your examples I have modified my charts to
work. "Andy Pope" wrote: Take a look at either of these free addins. Allowing you to link the datalabels to cells. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy Taryn wrote: Ok, I've figured out everything except the label holders for display axes labels. "Taryn" wrote: I think I can make something of this. I'm having some issues. 1) If I change the scale it does not appear to rescale on the chart...say 1 is 10 2) how do I change the plot to go clockwise with zero at the top? "Andy Pope" wrote: Maybe this then http://www.andypope.info/ngs/ng4.htm Taryn wrote: Yeh, I saw that one from a previous post. It allows for a variable Y per each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Glad to hear that. Thanks for posting back.
Taryn wrote: Thanks for all your help. Using your examples I have modified my charts to work. "Andy Pope" wrote: Take a look at either of these free addins. Allowing you to link the datalabels to cells. Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com Cheers Andy Taryn wrote: Ok, I've figured out everything except the label holders for display axes labels. "Taryn" wrote: I think I can make something of this. I'm having some issues. 1) If I change the scale it does not appear to rescale on the chart...say 1 is 10 2) how do I change the plot to go clockwise with zero at the top? "Andy Pope" wrote: Maybe this then http://www.andypope.info/ngs/ng4.htm Taryn wrote: Yeh, I saw that one from a previous post. It allows for a variable Y per each parameter but couldn't figure out how to make the X variable. "Andy Pope" wrote: Hi, This might help. http://tushar-mehta.com/excel/softwa...adar/index.htm Cheers Andy Taryn wrote: Does anyone know how to make a radar plot with a non-equal X axis. I would like to specify a unique theta for each data point. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com