How To Create A Bar Graph In Excel

To create a bar graph in Excel, follow these steps: enter the data into a worksheet, select the data, go to the Insert tab, click on the Bar chart option, and choose the desired bar graph type.

Creating a bar graph is an essential skill for anyone working with data in Excel. Whether you need to visualize sales figures, compare market trends, or present survey results, bar graphs provide a clear and concise way to communicate information. In this blog post, we will guide you through the step-by-step process of creating a bar graph in Excel. By the end of this tutorial, you will have the knowledge and confidence to create stunning bar graphs that effectively convey your data. So, let’s dive in and unlock the power of data visualization in Excel!

How To Create A Bar Graph In Excel: Step-by-Step


Step 1: Open Excel

To open Excel on your computer, search for it in the Windows start menu or locate its shortcut on your desktop. Launch the software to access its features and functionality for creating and managing spreadsheets.

Next Step

Step 2: Create or Open Spreadsheet

To create a bar graph in a spreadsheet, open or create a new spreadsheet and access the file menu by clicking “New” or “Open”. This will allow you to start working on your graph.

Next Step

Step 3: Input Data

First, input all the relevant information you wish to display on the bar graph into a spreadsheet. Arrange the data in two columns, with one column representing the different categories and the other column containing their respective values.

Next Step

Step 4: Highlight the Data

Click and hold your left mouse button, then drag over the cells to highlight/select the data. This data will be included in your bar graph.

Next Step

Step 5: Click on ‘Insert’

Click on the “Insert” tab located at the top of the screen in the top menu. This tab contains various options for adding different objects and functionalities to your document, such as tables, pictures, charts, and more.

Next Step

Step 6: Select ‘Bar Chart’

Once you click on the ‘Bar Chart’ icon in the ‘Charts’ group under the ‘Insert’ tab, you will be presented with various options for different types of bar charts. Simply select the desired type to create your customized bar chart.

Next Step

Step 7: Choose Your Bar Chart Style

After clicking on ‘Bar Chart’, you will be presented with a diverse range of visually appealing styles. Simply select the one that best suits your needs, and it will seamlessly integrate into your worksheet for an enhanced presentation.

Next Step

Step 8: Edit Chart Elements

In Excel, different versions offer options to modify chart elements such as title, axes, legend, and data labels. Locate the ‘Add Chart Elements’ button on the left side of the ‘Chart Tools’ tab for access to these editing features.

Next Step

Step 9: Save the File

Once you have completed creating your bar graph, save your work by navigating to the ‘File’ menu, selecting ‘Save As’, naming your document, choosing a storage location, and finally, clicking ‘Save’.


Overall, creating a bar graph in Excel is a simple and effective way to visually represent data. By following the step-by-step instructions in this blog post, you can now confidently create a bar graph in Excel to showcase your data in a clear and concise manner.

Excel provides a versatile platform for data visualization, allowing you to customize and format your bar graph to meet your specific needs. Whether you want to compare different categories, display trends over time, or analyze the distribution of data, Excel’s bar graph feature is a valuable tool.

Remember to choose the appropriate type of bar graph that suits your data and consider using additional formatting features to enhance the visual appeal of your graph. It is important to label your axes, add a title, and provide proper context to ensure that your audience can easily interpret the displayed information.

By mastering the art of creating bar graphs in Excel, you can effectively communicate your data and insights to others, whether it be for business presentations, academic reports, or personal projects. So go ahead and unlock the potential of Excel’s bar graph feature to bring your data to life and make informed decisions based on the patterns and trends you discover.

Table of Contents