XY plots (tricks and modifications)

XY scatter plot

XY Polt (scatter or line or combination) has both X and Y quantative values. The lines can be drawn, connected by smoothing based on data trend or directly connected as such.

We can just combine all of the different variations within single plot, just by selecting a series and change the chart type.  In the following case only Y2 is changed to smoothed line:

We can add error bars (specified from a series or fixed amount to the plot)

Connect the lines, in desirable connect.