How To Create Charts In Excel?

Open Excel and select the data range you want to chart (include column headers).

Go to the Insert tab.

Choose a chart type from the Charts group (e.g., Column, Line, Pie, Bar, Scatter).

Select the specific chart style you want.

If needed, use the Chart Design tab to change chart type or layout.

Use the Select Data option (Chart Design tab) to adjust which rows/columns are included.

Use Add Chart Element (Chart Design tab) to add Title, Axis Titles, Legend, Data Labels, Gridlines, and more.

Format the chart using the Format tab (or right-click options like Format Axis, Format Data Series).

Drag chart elements or resize the chart as needed.

Save the workbook to keep the chart.

Suggested for You

Trending Today