In Excel: select category labels and values, then choose Insert ▸ Bar Chart or Column Chart; use bars for long labels and columns for compact category names.
Put categories in one column and values in the next.
Select only the labels and values, excluding totals.
Choose Insert ▸ Bar Chart or Column Chart.
Sort categories and format the axis so labels are readable.
What this does
Bar and column charts compare values across categories. A bar chart runs horizontally, which works well for long names and ranked lists. A column chart runs vertically and is common for time buckets or short labels. The chart should use a clean label column, one or more numeric series and no total row inside the selected data. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “do a bar graph in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected chart change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Products are in A2:A6 and revenue is in B2:B6. Select A2:B6, choose Insert ▸ Bar Chart, then sort the source data descending so the largest product appears first. Add data labels when exact values matter. Bar charts are the clearest default for category comparison, from revenue by product to tickets by owner. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. If you take one thing from this page on “do a bar graph in excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Including a total row, which dwarfs the real categories.
- Using a pie chart for many categories when a bar chart would be clearer.
- Leaving categories unsorted when ranking is the point.
- Starting the value axis away from zero in a way that exaggerates differences.
Frequently asked questions
Bar chart or column chart?
Use bars for long labels or rankings; use columns for short labels or time buckets.
How do I show values on bars?
Add data labels from Chart Elements.
Should a bar chart start at zero?
Usually yes, because bar length visually encodes the value.
Other ways people ask this
This is also commonly searched as “how to do a bar graph in excel”, “how do i do a bar graph in excel” and “how to do bar graph on excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to do a bar graph in excel”, “how do i do a bar graph in excel”, “how to do bar graph on excel” all point at the one operation explained on this page, which is why they all lead here.