How do I Insert a Column Chart in Excel?

Excel provides users with a wide range of chart options to effectively visualize and analyze data. One of the most commonly used chart types in Excel is the column chart, which provides a visually appealing and easy-to-understand representation of data. Whether you are a data analyst, a business professional, or a student, knowing how to insert a column chart in Excel is essential for presenting data and communicating insights effectively. In this guide, we will explore the step-by-step process of inserting a column chart in Excel, empowering users to create visually appealing and informative charts effortlessly.

The column chart in Excel is a versatile tool that allows users to compare and analyze data across different categories or time periods. By representing data as vertical columns, users can easily identify patterns, trends, and variations in the data set. Whether you are working with sales figures, survey results, or any other type of numerical data, the column chart is an effective way to present the information in a visually impactful manner.

Step 1: Open Excel and select your data

  • Launch Excel and open the spreadsheet containing the data you want to represent in a column chart.
  • Select the range of data that you want to use for your column chart. Make sure to include the column headers and the data values.

Step 2: Click on the “Insert” tab

  • Look for the “Insert” tab in the Excel ribbon at the top of the screen.
  • Click on the “Insert” tab to access the charting options.

Step 3: Choose the column chart type

  • Within the “Insert” tab, locate the “Charts” group.
  • Click on the “Column” chart type to see the available column chart options.
Column Chart in Excel

Step 4: Select the desired column chart

  • From the available options, choose the specific column chart style that best suits your data representation needs.
  • Click on the desired chart to insert it into the spreadsheet.

Step 5: Customize your column chart

  • With the chart selected, you will see the “Chart Tools” appear in the Excel ribbon.
  • Utilize the various options within the “Chart Tools” to customize your column chart. This includes changing colors, adding axis titles, and adjusting the chart layout.
  • Experiment with different customization options until you are satisfied with your column chart’s appearance.

Step 6: Update your chart with new data

  • If there are any changes or updates to your data, simply update the range of data selected in Step 1.
  • When you click outside the selected data range, your column chart will automatically update to reflect the new data.


By following these simple steps, you can easily insert a column chart in Excel to visually represent your data. Remember to explore the customization options available to make your chart visually appealing and informative.

Get your Excel license from our website! Access the Office Suite with options like Office 2016, Office 2019, or Office 2021, chosen to match your needs perfectly.

Related Projects