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

XY Scatter to Edit Horizontal Data in Excel 2007. ... Excel automatically rescales the chart to fit within the image box, adds new labels to the x-axis and plots new data points on the chart.

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...