+ Reply to Thread
Results 1 to 4 of 4

How do I use two different sets of data for X axis when plotting graph?

  1. #1
    Registered User
    Join Date
    05-09-2009
    Location
    New Zealand
    MS-Off Ver
    Excel 2008
    Posts
    1

    How do I use two different sets of data for X axis when plotting graph?

    I am TRYING to plot a graph for Economics with 'Output' on the X Axis (1,2,3...10) and $ (0,50,100...300) on the Y Axis. There are 3 Lines on the graph using this data (eg. Total fixed cost, Total variable cost, Average variable cost) but then I need to put a 4th line on the graph for Marginal Cost - using the same Y Axis values, but plotting on the X axis at 1.5,2.5,3.5...9.5. I don't have these values for the other 3 lines that I am plotting though so end up with a graph that is completely wrong. Is there anyway I can plot this 4th line without messing up the rest of the data?

    Any help is much appreciated!!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: How do I use two different sets of data for X axis when plotting graph?

    Right click on line you want to have different axis.
    -> format data series
    -> choose in Plot series on -> Secondary axis

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: How do I use two different sets of data for X axis when plotting graph?

    Use an xy-scatter chart rather than Line chart.

    Line chart plots categorical data on the X axis.
    Scatter will plot numerical values on the X axis.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: How do I use two different sets of data for X axis when plotting graph?

    Oh, yes, that might be it... didn't read carefully thou

+ 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