+ Reply to Thread
Results 1 to 6 of 6

Create Chart for 3 variables against time.

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    australia
    MS-Off Ver
    2013
    Posts
    3

    Create Chart for 3 variables against time.

    Hi,

    Can EXCEL manage to chart 3 independent variables (ie: each with different scales) against time on X axis? I can see how to plot 2 variables against time using secondary Y axes and/or combo plot, or 3 variable using a stacked chart (essentially 2 charts, one above the other). However, cannot see that EXCEL can handle 3 independent variables against time.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,356

    Re: Create Chart for 3 variables against time.

    How would such a chart look if you draw it by hand? Can you mock something up and post a picture of the desired result?

    Excel can only have 2 different value axes, but if you have three dramatically different scales you may be able to convert one series using a formula. You could then create an artificial third Y axis with a helper series on a scatter chart.

    More details when you post some data and expected result.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,718

    Re: Create Chart for 3 variables against time.

    You haven't explained exactly what you have in mind for the final chart. As a generic "three independent variables against one dependent variable" approach, I would first recommend looking at this panel chart approach: https://peltiertech.com/Excel/Charts...venScales.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    02-13-2020
    Location
    australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Create Chart for 3 variables against time.

    Hi, I've attached image of what this would look like. If its not achievable in XL, I'll use grapher or similar utility.
    Attached Images Attached Images

  5. #5
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,356

    Re: Create Chart for 3 variables against time.

    The attached file has a sample.

    A formula scales down the "C" data. A and scaled down C are plotted on the primary axis, B is plotted on the secondary axis.

    A helper series is plotted towards the right of the chart and uses data labels with values from cells.

    2020-02-14_14-39-20.png
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    02-13-2020
    Location
    australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Create Chart for 3 variables against time.

    Hi, Many thanks, I'll give it a go.

+ 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