How to Do a Two-Sided Graph in Excel. Microsoft Excel can present two series of data points together on the horizontal axis, but if the number scale for each series dramatically differs, the data ...

One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.

Above the lizards is a multiple line graph. The horizontal X axis is labeled "time (days)." The vertical Y axis is labeled "% survived." In the graph there are five separate lines labeled by ...

Neither line chart handles the missing zeros well, but the multiple-line chart is hopeless. The line chart has a gap between the two months, which definitely looks odd.