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

You can lock the position of a chart in Excel spreadsheet so that it doesn't move or resize when you include more columns and change cell width. Learn how!

The X-axis, which is the horizontal axis, on most Excel charts does not use numeric intervals like the vertical Y-axis does. The X-axis contains either strings of text or a date under each set of ...