Radar Chart with Variable X Scale

[Taryn]

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]

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

[Taryn]

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]

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

[Taryn]

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
>

[Taryn]

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]

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

[Taryn]

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]

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