+ Reply to Thread
Results 1 to 8 of 8

how do I plot a data series against two series

  1. #1
    Frustrated in Sydney
    Guest

    how do I plot a data series against two series

    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?



  2. #2
    Bernard Liengme
    Guest

    Re: how do I plot a data series against two series

    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 Sydney@discussions.microsoft.com>
    wrote in message news:E79A99A8-9F83-4D42-8B6F-21C7DA10EE97@microsoft.com...
    >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?
    >
    >




  3. #3
    Tushar Mehta
    Guest

    Re: how do I plot a data series against two series

    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 <E79A99A8-9F83-4D42-8B6F-21C7DA10EE97@microsoft.com>, "=?Utf-8?B?
    RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
    Sydney@discussions.microsoft.com> 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?
    >
    >
    >


  4. #4
    Frustrated in Sydney
    Guest

    Re: how do I plot a data series against two series

    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 <E79A99A8-9F83-4D42-8B6F-21C7DA10EE97@microsoft.com>, "=?Utf-8?B?
    > RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
    > Sydney@discussions.microsoft.com> 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?
    > >
    > >
    > >

    >


  5. #5
    Tushar Mehta
    Guest

    Re: how do I plot a data series against two series

    In article <360EE381-48FF-4B4E-B0AE-6BBBBF84FE23@microsoft.com>,
    FrustratedinSydney@discussions.microsoft.com 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 <360EE381-48FF-4B4E-B0AE-6BBBBF84FE23@microsoft.com>,
    FrustratedinSydney@discussions.microsoft.com 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 <E79A99A8-9F83-4D42-8B6F-21C7DA10EE97@microsoft.com>, "=?Utf-8?B?
    > > RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
    > > Sydney@discussions.microsoft.com> 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?
    > > >
    > > >
    > > >

    > >

    >


  6. #6
    Jon Peltier
    Guest

    Re: how do I plot a data series against two series

    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 Sydney@discussions.microsoft.com>
    wrote in message news:E79A99A8-9F83-4D42-8B6F-21C7DA10EE97@microsoft.com...
    >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?
    >
    >




  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,448
    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.

  8. #8
    Jon Peltier
    Guest

    Re: how do I plot a data series against two series

    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" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
    news:MPG.1e5d6c01283dd68d98b343@msnews.microsoft.com...
    > In article <360EE381-48FF-4B4E-B0AE-6BBBBF84FE23@microsoft.com>,
    > FrustratedinSydney@discussions.microsoft.com 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 <360EE381-48FF-4B4E-B0AE-6BBBBF84FE23@microsoft.com>,
    > FrustratedinSydney@discussions.microsoft.com 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 <E79A99A8-9F83-4D42-8B6F-21C7DA10EE97@microsoft.com>,
    >> > "=?Utf-8?B?
    >> > RnJ1c3RyYXRlZCBpbiBTeWRuZXk=?=" <Frustrated in
    >> > Sydney@discussions.microsoft.com> 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?
    >> > >
    >> > >
    >> > >
    >> >

    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1