Multiple Data Set on a Line Graph

[antoniom93]

Its hard to explain, but I need to put 4 different lines in a line graph with different x-points of each graph.

What I need is a single x-axis and the lines varying within the whole chart, that range through the y-axis. I have no clue how to do this with several x data points.Real Estate in Ecuador.xlsx The data I need help is on sheet 5.

[DBY]

Hello
You could use a Scatter graph with 4 series, see attached image. But I'm not sure if you'll get much from it as it seems a tangle of lines.

DBY

[antoniom93]

Awesome!! Thank you so much for the tip.

[MrShorty]

If that solves your problem, I would suggest that you review this article: http://peltiertech.com/Excel/ChartsH...ValueAxis.html describing the differences and similarities between line and XY scatter charts/axes. It will help you in future projects to know when to use each type of chart.