Need to Learn How to Make a Bar Graph in Excel?
QI Macros makes bar charts easy
...AND can draw even smarter charts to analyze your data!
Create Bar Charts using QI Macros:
- Select your data.
- Select Excel Charts > Bar Chart on QI Macros menu.
- QI Macros will do the math and draw the graph for you.
Use a Bar Chart to Compare Categories of Data
Bar Graphs and Column Charts are often used to describe the same type of chart with vertical bars. However, in Microsoft Excel, a bar graph has horizontal bars whereas a Column Chart has vertical bars. No matter, what you call them, Bar graphs and Column charts are used to compare different categories of data.
Bar Graphs 101
To create a bar graph in Excel, select your data, then click on the Insert tab and then Bar. There are various choices of bar shapes (2-D, 3-D, Cylinder, etc) and formats (clustered, stacked or 100% stacked.)
100 % Stacked
Consider These "Smarter" Alternatives to Bar Graphs
Line and bar charts are often the "dumb and dumber" of Excel charts. They won't give you the insights you need to make improvements.
If you are tracking data over time, then use a control chart instead of a bar graph. Consider using a histogram to show the distribution of measured data or a Pareto Chart to show the importance of the bars,
It's time consuming and difficult to create Histograms and Pareto charts in Excel. However, its a snap if you have QI Macros. Download a 30 day trial to see for yourself.