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.
On this page7
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. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “clustered stacked bar chart excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected chart shows up while it is still harmless. 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 turns a visual that makes the number obvious at a glance into a method you can reuse, explain, and defend when the workbook leaves your screen.
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. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. If you take one thing from this page on “clustered stacked bar chart excel”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.
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.