Enter your data in rows or columns with clear headers
Select the data range you want to chart
Go to the Insert tab
Choose a chart type such as Column, Line, Pie, Bar, or Scatter
Click the chart style you want
Review the chart and make sure the data is displayed correctly
Use Chart Design to change colors, layout, and styles
Use Format to adjust fonts, labels, and chart elements
Add or edit chart title, axis titles, and legend
Add data labels if needed
Resize or move the chart as needed
Save your workbook