plotting different datatypes in a radar chart

[Jerry Koch]

Hi.

I am trying to plot different datatypes (percentages and
absolute values) in one radar chart. The percentages range
around 100% (~ 30% - 120%) and the absolute values will
range around 3 - 5 (which is interpreted as 300 - 500%).
This distortes the graph and makes it incomprehensible.
Since the absolute figures will be the # of a certain
activity it is not good to convert them to a percentage.

Does anybody know a way to plot this nicely into one chart
without breaking the continuous line of the radar chart?

Thanks

Jerry.

 

[Tushar Mehta]

I created the software to support the Custom Radar chart for the
specific reason you mention. Unfortunately, in its current
incarnation, the UI is very poor. If you want to try the software,
check the Excel | Add-Ins | Custom Radar Chart page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions