Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Quote:
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 the percentage values as Y-coordinates. Have a look at the attached. Hope this is what you need. Regards Holger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line graphs with multiple data sets | Charts and Charting in Excel | |||
how to create a line-chart with 2 sets of data who has different x | Charts and Charting in Excel | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
How do I use 2 sets of data in a chart | Charts and Charting in Excel | |||
2 sets of data I need one line | Charts and Charting in Excel |