Problem plotting three X-Y graphs on one plot, given unequal numbers of data points.

Read one previous thread that seemed relevant to this, but I did not understand it.

Am trying to plot 3 lines, the X-variable in all cases is the proportion of firms, the Y-variable is the percentage of orders executed. In Indian data, due to some data problems we have a graph for the upper bound and a graph for the lower bound, which has 1266 x-y data points. For the comparison US graph, we have one x-y graph based on 7655 data points.

When we plot each separately using EXCEL's "scatter | x-y" there's no problem. When I try plotting all three together for the US series, only 1266 points are used, and even these are rescaled. The original x-y data for all three graphs is already in the same scale, 0-100%.

Because of forum size limits, I am unable to include the file as an attachment. But have uploaded it to my cloud, and it can be accessed with the link: https://docs.google.com/file/d/0Bzyy...it?usp=sharing

Note, the EXCEL file has FOUR worksheets, with the fourth worksheet showing the problem, since teh graph on that sheet is not simply superimposing the graphs on the first three worksheets.

Please help. Thanks. Best,

Murgie

Found a solution at http://peltiertech.com/WordPress/plo...fferent-dates/ which seems to work for my case with 3 series and unequal numbers of data points for each series. Thanks, Jon Peltier. Best, -Murgie