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. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “create a stacked column chart 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 columns 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. 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. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “create a stacked column chart in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
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
On the way here you may have searched this as “how to make stacked column chart in excel”, “how to make a column stay in excel”, “create stacked column chart excel” and “creating a stacked column chart in excel” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to make stacked column chart in excel”, “how to make a column stay in excel”, “create stacked column chart excel” all point at the one operation explained on this page, which is why they all lead here.