Enter your data into rows and 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, Area, or Scatter
Click the specific chart style you want
Use Chart Design to change chart colors, styles, and layout
Use the plus icon or Chart Elements to add titles, labels, legend, and gridlines
Use Chart Filters to show or hide data series and categories
Right-click chart parts to format axes, data labels, and series
Use Select Data to change the chart’s data source or switch rows and columns
Resize and move the chart as needed
Use Recommended Charts if you want Excel to suggest chart options
Save your workbook after finishing the chart