Microsoft Excel plotting: Urgent please

[pre2grk]

Hi,
I have 3 columns of data (Mass,Area and Volume) for 10 different
spheres. It looks like
Sphere type - -mass -- area -- volume
I -- 1 -- 12 -- 20
II -- 4 -- 18 -- 36
III
...... till X
I want one line showing mass on x axis, area on y axis and volume
on seconday y axis, in plot area. I can plot three different lines but
I want only one line with ten points on it. This line shows relationship
between all three variables (mass,area & volume).
Your help will be really useful.
Thanking you.
Dave
mmec49@hotmail.com

 

[GlennUK]

Explain exactly where, for example point number 1 would go ... it would align with the 1 on the x-axis, but how would it align with 2 different y-axes? You need a different type of chart in my opinion ... how about a bubble graph?

 

[tusharm]

In certain circumstances one can simulate the effect of 1 series on 2 axis by plotting 2 series, one on each y-axis and then synchronizing the min and max values of the 2 axis so that the 2 series overlap each other. Don't know if this technique will work here, but an example is
Case Study – Single chart dual axis
http://www.tushar-mehta.com/excel/tips/0204-single graph dual axis.pdf

Another alternative, already suggested to you, is a bubble chart.

A third option that *may* work and that too only if 2 of the dimensions contain equidistant values is a surface chart. For how and why the limitation see
3D Surface
http://www.tushar-mehta.com/excel/charts/3d_surface/index.html

Hi,
I have 3 columns of data (Mass,Area and Volume) for 10 different
spheres. It looks like
Sphere type - -mass -- area -- volume
I -- 1 -- 12 -- 20
II -- 4 -- 18 -- 36
III
...... till X
I want one line showing mass on x axis, area on y axis and volume
on seconday y axis, in plot area. I can plot three different lines but
I want only one line with ten points on it. This line shows relationship
between all three variables (mass,area & volume).
Your help will be really useful.
Thanking you.
Dave
mmec49@hotmail.com

 

[pre2grk]

Explain exactly where, for example point number 1 would go ... it would align with the 1 on the x-axis, but how would it align with 2 different y-axes? You need a different type of chart in my opinion ... how about a bubble graph?

Sorry for the confusion. I have one sphere and therefore
it has mass, surface area and volume. How I should represent
or plot this one point (becz one sphere) in chart where
mass is on x axis, area on y axis and volume on secondary y axis. Total 4 columns as follows,
Sphere -- mass--area-- volume
I--1--12--20
So similarly I have ten spheres with different
variables and finally I can draw one line through all these
ten points. Waiting for your reply.
Thanks.

 

[GlennUK]

Have a series for mass vs area, and another for mass vs volume, and plot the second series on the secondary axis, for each of the ten sets of data, ( or, in fact, one series for all the mass vs area figures, and another for mass vs volume ).