+ 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 Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    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
    15,803

    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 Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    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)

Similar Threads

  1. Cannot figure out how to create bar chart with line overlay using 3 variables
    By drewforte1087 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-24-2018, 03:13 AM
  2. Create a scatter chart to show a correlation between two variables
    By Blake 7 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-10-2012, 02:10 AM
  3. Create chart with variables data source
    By vietnam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2012, 04:08 AM
  4. Create chart with variables data source
    By vietnam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2012, 10:21 PM
  5. Create Bubble Chart with multiple variables
    By MiguelFernandes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2012, 09:48 AM
  6. How to create a complex chart with four variables?
    By ddiego in forum Excel General
    Replies: 0
    Last Post: 06-12-2012, 07:47 PM
  7. how to create chart with five data variables
    By Kyle in forum Excel General
    Replies: 0
    Last Post: 04-05-2006, 10:20 AM

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