## 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.

Nice and great article on Microsoft Excel Certification

ReplyDeleteExcel Certification

MS Excel Training

Basic Excel Training

Advanced Excel Training

Excel Courses Online

Excel Training Online

Excel Courses

Excel training