+ Reply to Thread
Results 1 to 2 of 2

Multiple Data Series in a line chart, without consistent y-axis

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Nashville TN
    MS-Off Ver
    D365 Pro
    Posts
    4

    Multiple Data Series in a line chart, without consistent y-axis

    Okay, I am working on a Project S-curve for a customer, based off % complete (X axis) and dates\ (Y axis). The problem I am running into is that the data points don't all share the same dates. As an example:

    Baseline Date - Baseline % - Planned Date - Planned % - Actual Date - Actual %
    1Feb12 - 12% - 4Feb12 - 8% - 4Feb12 - 8%
    14Feb12 - 24% - 12Feb12 - 22% - 12Feb12 - 22%
    29Feb12 - 36% - 1May12 - 38% - (No Data)


    I know I can chart a series of lines in a single chart, if the dates (Y axis) were consistent. However, when the Y values are different for each data point, how do I create a line for each set of data, again, using % Complete as the X-Axis and Dates as the Y-Axis.

    Thank you very much for the help.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Lightbulb Re: Multiple Data Series in a line chart, without consistent y-axis

    Hi
    See the attached Chart Example. Is this what you're looking for? It plots the three series of Basline Date; Planned Date and Actual Date against Date and percentages across the X axis.

    Hope this helps.
    DBY
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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