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

How To Make Bar Graph in Excel

  • Author:
    Agnese
  • Published on:
    June 17, 2023
  • Category:
  • Last updated:
    April 6, 2024
  • Tags:
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?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

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.

New Articles

Speed up your spreadsheet tasks with Ajelix AI in Excel

Excel formula generator from Ajelix - more than 15 ai tools for spreadsheets

Similar posts

How to analyze data in Excel spreadsheet banner by author

How To Analyze Data In Excel Spreadsheet

April 4, 2024
Excel is the workhorse of data analysis in countless businesses. It can unlock valuable insights from spreadsheets, but for many, its pow…
How to add drop down list in Excel banner

How To Add Drop Down List in Excel

November 2, 2023
Let’s take a look at how to add drop down list to make your spreadsheets more professional and user-friendly. We’ll take a lo…
How to add checkbox in Excel banner

How To Add Checkboxes In Excel

October 31, 2023
This article will cover steps to add checkboxes in Excel with screenshots and tips to help you tackle this task. Learn how to enable the …

Online Calculators

Free future value calculator online banner

Free Future Value Calculator Online: Calculate FV

June 13, 2024
A future value calculator helps you estimate how much an investment will be worth in the future, taking into account factors like interes…
Free IRR calculator online: calculate your internal rate of return banner

Free IRR Calculator: Calculate Internal Rate of Return

June 11, 2024
IRR formula in Excel screenshot from spreadsheet for IRR calculator
Net present value banner

Free NPV Calculator Online: Calculate Net Present Value

June 6, 2024
An NPV calculator is a tool that helps you assess the profitability of an investment by calculating its Net Present Value (NPV). Calculat…
Calculate markdown metric with free online calculator banner

Free Markdown Calculator Online

June 4, 2024
A markdown calculator is used by businesses to maximize profits. They track how much you discount inventory, helping you identify areas t…
free clt calculator: calculate customer lifetime value online banner by ajelix

Free CLV Calculator: Calculate Customer Lifetime Value

May 30, 2024
Customer lifetime value calculator, also referred to as CLV calculator or lifetime value (LTV), is a metric that businesses use to estima…
Free debt to asset ratio calculator online banner

Free Debt To Asset Ratio Calculator Online

May 28, 2024
The debt to asset ratio calculator is a tool to assess a company’s financial health by indicating the proportion of its assets fina…

Business Intelligence

Hoe to calculate business growth rate with examples and formula banner by ajelix

How to Calculate Business Growth Rate? Formula & Examples

April 16, 2024
Whether you’re a seasoned entrepreneur or just starting, measuring progress is vital to identify areas of strength, pinpoint opport…
How to calculate average revenue per user formula & meaning example banner

Calculate Average Revenue Per User: ARPU Formula & Meaning

April 11, 2024
The metrics are king, there’s no doubt about it. They tell the story of your company’s health, customer base, and overall suc…
How to calculate revenue growth in Excel with examples and formulas banner by ajelix

How To Calculate Revenue Growth Rate: Formula & Examples

April 9, 2024
Revenue growth rate is a performance indicator, that helps understand if your sales efforts are yielding positive results. Tracking it ov…
What is collaborative business intelligence (BI) and analytics blog article banner by ajelix

Collaborative Business Intelligence (BI) & Analytics

April 2, 2024
Imagine a world where everyone in your organization, from sales reps to executives, can easily access, analyze, and discuss data together…
top 7 business intelligence trends (bi) 2024 banner ajelix

7 Business Intelligence Trends (BI) 2024

March 28, 2024
This year, Business intelligence trends are all about harnessing the power of technologies like Generative AI and Natural Language Proces…
Financial business intelligence meaning and examples banner by ajelix team

Financial Business Intelligence Meaning & Examples

March 26, 2024
Measuring business financial health is vital for any manager or owner to understand what is happening in your company. However, you can’t…