Starting graphs at the same point on microsoft excel?

Question

I have 2 line graphs on the same graph and i need to get both line graphs to start from the same point, does anyone know how to get them to start from the same point? If you need me to elaborate, please let me know.

Answer 1

You can try to set one of the lines to a secondary axis.
Right click on the line, format data series, axis tab, click the secondary axis radio button.

Then if needed, you right click the axis, format axis, scale tab, and uncheck the auto box next to the minimum.and set it manually to the initial value. Do this for both axis, and they will start on the same point. However, you may end up with lines dipping below the bottom of the chart. But if your data happens to trend upward from the minimums, it might work out how you wanted.

Answer 2

The graph interior the image is a mix chart including 3 charts that are in result over-laid one on ideal of the subsequent. Labels are required over the help columns of each and every records set. 3 scatter charts have been then created, one for each records set. The chart with the longest X axis; the single that is going to approximately -7 would desire to be the backside chart. Then with the different charts click in a sparkling component of the chart and choose replica. Then, bypass to the backside chart and click interior the chart and choose Paste. try this for the third records set additionally and you have gotten a precise reproduction of the image. there is yet another technique of bobbing up a mix chart yet would not artwork for this expertise. lookup interior the Excel help report "mixture chart" and shop on with the occasion that they provide.

Answer 3

Start at the same coordinate? Their values would have to be the same.