I want to plot one data series against two axes. I can get the secondary axes
and I can get it onto the x axes at the top. What I want is to get the second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want to
create a graph so that the data series I plot can be looked up by either the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

Please tell us how the data is set out.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Frustrated in Sydney" <Frustrated in
wrote in message ...
I want to plot one data series against two axes. I can get the secondary
axes
and I can get it onto the x axes at the top. What I want is to get the
second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want
to
create a graph so that the data series I plot can be looked up by either
the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function
of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

Assuming I understood you, it is possible to simulate the effect. See the
link 'Singe chart with dual axis' at http://www.tushar-mehta.com/excel/tips/

The direct link to the article is *not* a permanent link. Currently, it is
Single chart dual axis
http://www.tushar-mehta.com/excel/ti...ual%20axis.pdf
--
Regards,

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

In article , "?B?
RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
says...
I want to plot one data series against two axes. I can get the secondary axes
and I can get it onto the x axes at the top. What I want is to get the second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want to
create a graph so that the data series I plot can be looked up by either the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

That method is fine for a situation where the two measuring axes are linearly
related to eachother like celsius and fareinheight. (9/5 +32 ) but my
situation has the two measuring axes being in a non-linear relationship to
eachother ( Vf= (Wfration fibre/density fibre)/(Weight fraction fibre/density
fibre+Weight fraction matrix/density matrix)
So I can't just scale the axes by changing the min and max of the axis.

So what I need to do is have one of the x-axes regularly spaced and the
other irregularly spaced so that they are equally far from the y axis when
they are equivalent.

From what I've seen so far from other posts and the excel help, it looks as
though this is not possible.

Thanks anyway.

"Tushar Mehta" wrote:

Assuming I understood you, it is possible to simulate the effect. See the
link 'Singe chart with dual axis' at http://www.tushar-mehta.com/excel/tips/

The direct link to the article is *not* a permanent link. Currently, it is
Single chart dual axis
http://www.tushar-mehta.com/excel/ti...ual%20axis.pdf
--
Regards,

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

In article , "?B?
RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
says...
I want to plot one data series against two axes. I can get the secondary axes
and I can get it onto the x axes at the top. What I want is to get the second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want to
create a graph so that the data series I plot can be looked up by either the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

In article ,
says...
So what I need to do is have one of the x-axes regularly spaced and the
other irregularly spaced so that they are equally far from the y axis when
they are equivalent.

It is always possible to simulate an axis. But, you have to provide more
information about the nature of the two axes. Clearly, if you are plotting
one data set against two metrics, there has to be a relationship between the
two measuring systems.


From what I've seen so far from other posts and the excel help, it looks as
though this is not possible.

OK. It's your call.

--
Regards,

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

In article ,
says...
That method is fine for a situation where the two measuring axes are linearly
related to eachother like celsius and fareinheight. (9/5 +32 ) but my
situation has the two measuring axes being in a non-linear relationship to
eachother ( Vf= (Wfration fibre/density fibre)/(Weight fraction fibre/density
fibre+Weight fraction matrix/density matrix)
So I can't just scale the axes by changing the min and max of the axis.

So what I need to do is have one of the x-axes regularly spaced and the
other irregularly spaced so that they are equally far from the y axis when
they are equivalent.

From what I've seen so far from other posts and the excel help, it looks as
though this is not possible.

Thanks anyway.

"Tushar Mehta" wrote:

Assuming I understood you, it is possible to simulate the effect. See the
link 'Singe chart with dual axis' at http://www.tushar-mehta.com/excel/tips/

The direct link to the article is *not* a permanent link. Currently, it is
Single chart dual axis
http://www.tushar-mehta.com/excel/ti...ual%20axis.pdf
--
Regards,

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

In article , "?B?
RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
says...
I want to plot one data series against two axes. I can get the secondary axes
and I can get it onto the x axes at the top. What I want is to get the second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want to
create a graph so that the data series I plot can be looked up by either the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

One of your axes has to be made independent of Excel's axis capability.
Since you know how VF and WF interrelate, this is not a major problem. This
page shows how to make an arbitrary axis scale, and gives links to some
examples:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

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

"Frustrated in Sydney" <Frustrated in
wrote in message ...
I want to plot one data series against two axes. I can get the secondary
axes
and I can get it onto the x axes at the top. What I want is to get the
second
axes to be dependent on the first. You see the second axes is the volume
fraction of a composite ply and the first is the weight fraction. I want
to
create a graph so that the data series I plot can be looked up by either
the
volume fraction or the weight fraction. The problem is that the volume
fraction axes scale needs to be irregular since it's a nonlinear function
of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

I responded before noticing Tushar's contributions to the thread. In any
case, it's certainly possible to get what the OP asked. Whether the two
parameters are related linearly is irrelevant.

Here's the link I provided in my other post.

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

"Tushar Mehta" wrote in message
om...
In article ,
says...
So what I need to do is have one of the x-axes regularly spaced and the
other irregularly spaced so that they are equally far from the y axis
when
they are equivalent.

It is always possible to simulate an axis. But, you have to provide more
information about the nature of the two axes. Clearly, if you are
plotting
one data set against two metrics, there has to be a relationship between
the
two measuring systems.


From what I've seen so far from other posts and the excel help, it looks
as
though this is not possible.

OK. It's your call.

--
Regards,

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

In article ,
says...
That method is fine for a situation where the two measuring axes are
linearly
related to eachother like celsius and fareinheight. (9/5 +32 ) but my
situation has the two measuring axes being in a non-linear relationship
to
eachother ( Vf= (Wfration fibre/density fibre)/(Weight fraction
fibre/density
fibre+Weight fraction matrix/density matrix)
So I can't just scale the axes by changing the min and max of the axis.

So what I need to do is have one of the x-axes regularly spaced and the
other irregularly spaced so that they are equally far from the y axis
when
they are equivalent.

From what I've seen so far from other posts and the excel help, it looks
as
though this is not possible.

Thanks anyway.

"Tushar Mehta" wrote:

Assuming I understood you, it is possible to simulate the effect. See
the
link 'Singe chart with dual axis' at
http://www.tushar-mehta.com/excel/tips/

The direct link to the article is *not* a permanent link. Currently,
it is
Single chart dual axis
http://www.tushar-mehta.com/excel/ti...ual%20axis.pdf
--
Regards,

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

In article ,
"?B?
RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
says...
I want to plot one data series against two axes. I can get the
secondary axes
and I can get it onto the x axes at the top. What I want is to get
the second
axes to be dependent on the first. You see the second axes is the
volume
fraction of a composite ply and the first is the weight fraction. I
want to
create a graph so that the data series I plot can be looked up by
either the
volume fraction or the weight fraction. The problem is that the
volume
fraction axes scale needs to be irregular since it's a nonlinear
function of
the weight fraction. Firstly, I'd like to know if that's possible.

If so,
HOW DO I DO IT?

It's certainly possible. Gut feel says you're going to need to use a
dummy series to simulate the secondary Y axis rather than use a built
in secondary axis. www.peltiertech.com has examples of using dummy
series as axes.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=512544