Excel 2010 - Line Chart with Mulitiple Data Sets

[Dukegijoe]

I am working on a Project S-curve for a customer, based off % complet
(X axis) and dates\ (Y axis). The problem I am running into is that th
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 (
axis) were consistent. However, when the Y values are different for eac
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

 

[PIMP MY CHART]

I am working on a Project S-curve for a customer, based off % complet
(X axis) and dates\ (Y axis). The problem I am running into is that th
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 (
axis) were consistent. However, when the Y values are different for eac
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.

Hi,

in this case you should use the chart type 'XY scatter with lines
rather than a regular line chart. Select the dates as X-values and th
percentage values as Y-coordinates. Have a look at the attached. Hop
this is what you need.

Regards

Holge

+-------------------------------------------------------------------
|Filename: XY scatter lines dates.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=395
+-------------------------------------------------------------------