From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Make Bar Graph in Excel

How to make bar graph in excel - full guide by ajelix - banner

Bar graphs can help you visually represent data and providing a clear way to present the necessary information. Excel, a powerful spreadsheet program, offers a range of features that make creating bar graphs quick and efficient.

What is Bar Graph?

A bar graph, also known as a bar chart, is a visual representation of data using rectangular bars. Bar graphs are super popular in all kinds of fields to show data in a cool and easy-to-grasp way. They’re great for comparing stuff, spotting trends, and seeing patterns in data sets.

How To Prepare Data for Excel Bar Chart?

Making sure your data is all neat and tidy in the Excel worksheet is super important. Put your data in columns or rows, where each column or row is for a different category.

How to make bar chart in excel - step 1 - prepare data

Screenshot taken by the author

Figure out which categories really matter for showing the info you want. Leave out any extra or unrelated data that might mess up the graph and make it harder to understand.

Related Article: How To Make Bar Chart Bars Wider?

How To Create A Simple Bar Graph?

Time needed: 2 minutes

Create A Bar Graph in Excel

  1. Select the data for the graph

    In Excel, you can easily rules select the data you want to include in your bar graph. Click and drag the cursor over the desired cells or use the Shift key to select a range of cells. Make sure to include both the category labels and the corresponding data values.
    Select the data for the excel bar chart

  2. Insert Bar Graph in Excel

    Go To the Excel option file tab, click on Insert tab, and choose Recommended Charts. A pop-up window will show and Excel will give you the option to pick and create a bar chart.
    Insert bar chart from recommended chart option in excel

Related Article: How To Delete A Chart in Excel?

How To Customize the Bar Graph in Excel?

How To Format the Axes, Labels, and Title?

To enhance the visual appeal and clarity of your bar graph, Excel provides numerous customization options. Modify the axes. Set appropriate scales and intervals.

Label the axes clearly. Add a descriptive title. Provide context for the graph. To add titles click on the chart, press the plus sign, and thick settings Axis Titles and Chart Title.

How to add axis title and chart title in excel chart

Screenshot taken by the author

To edit your chart titles simply click on them and you’ll be able to make edits.

Related Article: Change Page Orientation to Landscape in Excel

How To Change the Colors and Styles of The Bars?

Excel allows you to customize the appearance of the bars in your graph. Experiment with different colors, and patterns. To change bar chart colors go to Chart Design, pick Change Colors, and experiment with different color palettes provided by Excel. This is a great option if you want to create an advanced chart with lots of bars.

Change chart colors in chart design settings

Screenshot taken by the author

If you want to create your own pallet and change bar colors more freely here’s what to do:

  1. Click on the element that you want to change color, in our example, we chose to customize the bar;
  2. Click on the Format setting
  3. Pick Shape Fill to change the bar color or Shape Outline if you’d like other color for bar outline;
  4. Now you can choose from different colors
Format chart colors from format tab in excel

Screenshot with steps on how to change chart color

Related Article: How To Remove Conditional Formatting in Excel?

Conclusion

In conclusion, Excel is a powerful tool for creating bar graphs that effectively visualize and communicate data. By following the outlined steps and utilizing the extensive customization options, you can create visually appealing and informative clustered bar graphs. Excel’s charting features allows you to unlock the full potential of your data visualization and gain valuable insights.

Frequently Asked Questions

What is the purpose of using data labels in a bar graph?

The purpose of data labels in a bar graph is two-fold. Firstly, they provide additional information about the values represented by each bar. Secondly, they enhance accuracy and readability.

Can I add trendlines to my bar graph in Excel?

Yes, you can add trendlines to your bar graph to visualize patterns in the data, providing insights into the tendency.

How can I export my bar graph from Excel to a different format?

Export your bar graph from Excel using the “Save As” option. Select a desired format such as JPEG, PNG, or PDF. This will allow for easy sharing and compatibility with other software or platforms.

Struggling with your Excel formulas?

Try out for free AI Excel Assistant who can generate Excel and Google Sheets formulas from your text. Explain your formulas and give descriptions to the most complicated formulas. Translate your Excel files in 28 lanugages. Write and explain your VBA and Google Apps Scripts. Register for free!

Start Generating Formulas

Learn more about Excel and Google Sheets hacks in other articles. Stay connected with us on social media and receive more daily tips and updates.

Neueste Artikel