How to Plot X vs Y Data Points in Excel | Scatter Plot in Excel With Two Columns or Variables

Описание к видео How to Plot X vs Y Data Points in Excel | Scatter Plot in Excel With Two Columns or Variables

Download the featured file here: https://www.bluepecantraining.com/wp-...

In this video I demonstrate how to create a X vs Y scatter plot in Microsoft Excel. The task is pretty easy to achieve if your data is laid out correctly - if it's not then you will need the tips and tricks explored in this tutorial.

00:00 Introduction
00:27 Selecting data for your scatter plot
01:43 Creating the scatter chart
02:16 Swapping the x and y axes (2 methods)
04:51 Including noncontiguous columns in your scatter chart
05:45 Changing the minimum value on the x axis
06:11 Displaying a trendline on your scatter chart
------------------------

Комментарии

Информация по комментариям в разработке