+ Reply to Thread
Results 1 to 2 of 2

Plotting a line chart with 2 sets of values and dates?

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    London
    Posts
    39

    Plotting a line chart with 2 sets of values and dates?

    Hi,

    First time poster here, apologies if this is a common question, I couldn't find an answer with a quick search. If anyone wants to point me towards relevant FAQs that'd be grand, but I'd appreciate being handed this answer on a platter too!

    I want to plot a line chart with the date as my horizontal axis and two lines representing two values on any given day (expected stock in, and stock actually arrived.) My data is currently in four columns: Expected stock, Date for this, Stock arrived, Date for this. eg:

    40, 24/7/08, 20, 30/7/08

    Which indicates I expected 40 stock on 24/8 but only got 20 and on 30/7.

    Is there a way of doing this without massively reorganising all my data? I would greatly appreciate any help!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    The normal layout for chart data is 1st column category labels (x-axis) and 2nd column Values (y-axis)

    Because your 2 sets of data will not share the same dates you will need to plot a xy-scatter rather than Line chart.

    But I do not see how you will know which points in the 2 line series are related.

    If you do not change the layout of your data you can use the Data step in the chart wizard to select appropriate ranges for x and y values.
    Cheers
    Andy
    www.andypope.info

+ 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. date and time line chart
    By ilfan83 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-23-2012, 12:04 AM
  2. how do you chart data by dates and omit dates
    By travelbrains in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-09-2008, 02:37 PM
  3. Setting chart value to dates
    By joe bloggs in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-11-2008, 04:53 AM
  4. copying values to respective dates
    By yeaster in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2008, 11:45 AM
  5. Replies: 2
    Last Post: 10-31-2007, 06:52 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