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. Treat “add a line in a column 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 columns 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. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
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. Treat “add a line in a column chart 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 “excel add line to column chart” and “how to add line in column chart 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. “excel add line to column chart”, “how to add line in column chart excel” all point at the one operation explained on this page, which is why they all lead here.