PC Review


Reply
Thread Tools Rate Thread

Can I give each axis in a radar chart a different scale?

 
 
Lesle
Guest
Posts: n/a
 
      15th Jul 2008
I would like to create a radar chart that contains about 6 different factors
representing overall project results (schedule index, cost index,
requirements volatility, etc.) 1 data series would represent the
organizational baseline, the other would represent the project results. Is
is possible to give each different factor/axis a different scale? Thanks for
any suggestions.
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      15th Jul 2008
You can fake it, as shown by Tushar Mehta:
http://www.tushar-mehta.com/excel/so...adar/index.htm

A better chart for your purpose may be a parallel coordinate plot. See the
end of this article, where I compare a perfectly legible parallel
coordinates plot to an incomprehensible radar chart of the same data:
http://peltiertech.com/Excel/Charts/ParallelCoord.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Lesle" <(E-Mail Removed)> wrote in message
news:F5174B2C-BC5C-440D-AB0C-(E-Mail Removed)...
>I would like to create a radar chart that contains about 6 different
>factors
> representing overall project results (schedule index, cost index,
> requirements volatility, etc.) 1 data series would represent the
> organizational baseline, the other would represent the project results.
> Is
> is possible to give each different factor/axis a different scale? Thanks
> for
> any suggestions.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw chart: log scale on X axis, natural scale on y axis? =?Utf-8?B?UHJhdGFwIEQuIGNoYXZhbg==?= Microsoft Excel Charting 1 16th Nov 2006 08:03 AM
Radar chart - moving the axis =?Utf-8?B?TmVpbGZmZg==?= Microsoft Powerpoint 1 29th May 2006 09:48 PM
How do I change x-axis in an Excel Radar Chart? =?Utf-8?B?RHIuIEouV2hpdGU=?= Microsoft Excel Charting 1 7th Oct 2005 04:02 PM
Radar Chart with Variable X Scale =?Utf-8?B?VGFyeW4=?= Microsoft Excel Charting 9 3rd Aug 2005 03:17 PM
Re: Using different value axis on a radar chart Jon Peltier Microsoft Excel Charting 0 29th Jul 2004 09:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:13 PM.