Quick summary
Creating a bar chart in Microsoft Excel takes just a few clicks: select your data range, use the Insert tab to choose a bar chart style, and customize the result to fit your needs. This tutorial walks through every step so you can visualize spreadsheet data quickly and accurately.
Steps
- Select the data range — highlight the cells containing your data, including labels (e.g., A1:B4).
- Click the Insert tab in the ribbon at the top, then choose Bar Chart (also listed as "Column or Bar Chart").
- From the dropdown menu, select your preferred bar chart style.
- To switch the chart type, select the chart, open the Chart Design tab, and click Change Chart Type.
- Select the bar chart option, hover to preview it, then click OK to insert the chart into your spreadsheet.
- Customize your bar chart as needed using the available formatting and design options.
