An X-Y scatter chart is an ideal plot choice when you have data sets with at least two interesting variables per record, and because scatter plots are a native graph option in Excel, you simply ...

For example, if you are plotting stock prices over time, you can use a line graph or a scatter plot. This set of data is labeled as "Series 1." Right-click a blank space on the chart, click ...