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

How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.