Radar chart with multiple axes

[mark91345]

Hi,
Hope there is a solution for this:

I am measuring 2 months of stock prices (just the day's High and Low), using the Radar chart, as the "roundness" is helpful to me.

I also want to see the daily Volume on the same chart; however, as this requires two different axes (price versus volume), I don't know how to get both on the same chart.

Can I do this?

Just to be sure some of the terms are clear, a stock price would have this kind of info:

Date Low High
7/1/11 $11.22 $11.68
7/2/11 $10.55 $10.59
7/3/11 $11.05 $11.57




whereas Volume would have different columnar information:
Date Volume
7/1/11 57,050
7/2/11 23,605
7/3/11 41,555

 

[Steve=True]

Not sure if it is really a thrid axis, but you can add another series of disproportionate scales. However, you need to normalize your data to % of something like the Max Value or Average Value.

Series 1 Data Points =Volume/MAX(Volume Range)
Series 2 Data Points =Low/MAX(Low Range)
Series 3 Data Points =High/MAX(High Range)

Here is a sample:
http://www.4shared.com/document/cx6GO41_/Radar_Normalization_Test.html

 

[mark91345]

Thank you so much for this, as this helps with exactly what I want.
You're an angel!