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.

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.