+ Reply to Thread
Results 1 to 3 of 3

How to chart multiple lines with inconsistent X values?

  1. #1
    Registered User
    Join Date
    11-01-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    33

    How to chart multiple lines with inconsistent X values?

    Hi folks,

    I'm trying to create a line/scatter graph with six different lines. The problem is that the associated X data (the date) is inconsistent between the various lines.

    Bob

    Jan 1 – $12
    Jan 3 – $10.3
    Jan 4 – $333
    Jan 6 – $24

    Jim

    Jan 2 – $303
    Jan 3 – $23
    Jan 5 – $4
    Jan 6 – $45

    How would I plot these both together given the differences in the X axis?

    Thanks!

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

    Re: How to chart multiple lines with inconsistent X values?

    You can either create a chart data set where the layout does the work.

    Or create a chart and specify the ranges used for x and y values for each data series, via the Select Data dialog
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-01-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: How to chart multiple lines with inconsistent X values?

    Perfect, thanks!

+ 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. Replies: 1
    Last Post: 08-11-2012, 05:43 PM
  2. chart with multiple columns and lines
    By Tknops in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-07-2007, 07:30 PM
  3. formatting of multiple lines on a chart
    By robert111 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2006, 04:45 AM
  4. Lines on chart don't correlate to values being charted
    By BW in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-13-2006, 03:00 PM
  5. Broken lines in a chart to display extreme values?
    By Metin Örsel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-04-2005, 10:05 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