LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Excel 2010 - Line Chart with Mulitiple Data Sets

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line graphs with multiple data sets loveiseternal2000 Charts and Charting in Excel 3 September 28th 08 03:59 PM
how to create a line-chart with 2 sets of data who has different x Frank_C Charts and Charting in Excel 1 August 30th 08 03:55 PM
Excel graph 3 sets of data. 2 sets as lines 1 as column? AndyN Charts and Charting in Excel 2 July 11th 08 01:18 PM
How do I use 2 sets of data in a chart Skeety Charts and Charting in Excel 1 January 12th 08 01:14 PM
2 sets of data I need one line Tim Charts and Charting in Excel 1 February 25th 06 11:23 AM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"