How to Make a Column Graph in Google Sheets: A Guide

To make a column graph in Google Sheets, select your data, choose Insert > Chart, then select Column chart in the Chart editor. A column graph displays categories along the bottom and values as vertical bars, making it easy to compare amounts at a glance. Before you begin, arrange the data in a simple table with a header row and one row per category; then you can add a title, labels, and other formatting to make the chart clear.

What You’ll Need

A Google account and access to Google Sheets in a web browser.
A spreadsheet containing the categories you want to compare and one or more columns of numeric values.
Clear column headings, such as Month and Visitors, so Sheets can identify the data series and label the chart.

For example, a small table with Month in column A and Visitors in column B is a good starting point. Put January, February, and March in A2:A4, and enter the matching visitor totals in B2:B4. The specific values do not matter; the important thing is that each category has a corresponding number and that the headings sit above the data.

Step-by-Step

Arrange the source data. Put category names in the first column and the values to compare in the next column. Use row 1 for headings, then add one category per row beneath it. Keep each value aligned with the correct category. Avoid putting explanatory notes, subtotals, or blank rows inside the table, because they can be treated as chart data or interrupt the category sequence. If you want to compare multiple series, such as this year and last year, give each series its own column and add a clear heading to each one.
Select the data range. Click the first cell in the table and drag across the full range, including the headings. For example, if the headings are in A1:B1 and three months of data are in A2:B4, select A1:B4. Including the heading row helps Sheets use the column names in the chart instead of treating them as another category or value. If your data occupies a continuous block, select that whole block rather than selecting individual cells.
Insert a chart. With the range selected, open the menu and choose Insert > Chart. Google Sheets adds a chart to the sheet and opens the Chart editor, usually on the right. The chart may not initially be a column graph: Sheets chooses a chart type based on the selected data. That is expected, and you can change the type in the next step without reselecting the data.
Choose Column chart. In the Chart editor, open the Setup tab. Find the Chart type menu and select Column chart. The preview updates to show vertical columns. Do not choose Bar chart if you specifically want columns: a bar chart displays horizontal bars, while a column chart displays vertical bars. If the chart preview looks correct, continue to the labels and layout options in Setup.
Check the data range and labels. In Setup, confirm that the Data range includes the headings and every row you intend to graph. Check the X-axis field as well: it should normally contain the category labels, such as the months in column A. Under Series, confirm that the numeric column or columns appear as values. For a typical table with headings in row 1, make sure Use row 1 as headers is enabled. If the categories are in the first column, make sure Use column A as labels is enabled. The exact column letter will vary with your layout.
Correct the chart orientation if needed. If Sheets has put the categories in the legend or charted each row as a separate series, use Switch rows/columns in Setup. Watch the preview as you change it. For a simple two-column table, you usually want one column of category labels along the horizontal axis and one value series. With several numeric columns, you usually want each column heading to identify a separate series, so the chart can compare them across the same categories.
Add a useful chart title and axis titles. Open the Customize tab, expand Chart & axis titles, and choose the title type you want to edit. Enter a concise Chart title that describes what is being compared. You can also select Horizontal axis title for the categories and Vertical axis title for the measured quantity. For example, a chart of monthly visitors could have the title Monthly Visitors, the horizontal axis title Month, and the vertical axis title Visitors. Use titles that explain the data without making the chart crowded.
Make the values easier to read. In Customize, open Series and enable Data labels if readers need to see the value on each column. If you have more than one series, check that labels do not overlap. You can adjust the series color and other available options there. Use a restrained color choice: a single series often needs only one clear color, while multiple series should use distinct colors that remain easy to tell apart.
Finish and place the chart. Close the Chart editor when you are done; your changes are saved in the spreadsheet. Click the chart and drag it to a clear part of the sheet. Drag a corner or edge handle to resize it, leaving enough room for the title, axis labels, and legend if one is present. Click a blank cell to leave the chart unselected. To reopen the editor later, click the chart and use its three-dot menu to choose Edit chart.

After making the chart, compare each column against the source table. The labels should match the categories, the columns should represent the expected numbers, and the vertical scale should not obscure the differences. If you later add rows or columns, check the chart’s Data range in Setup; update the range if the new cells were not included automatically.

Common Mistakes

Leaving out the headings. If you select only the numbers and categories but omit the header row, the legend may show a generic series name, or the first row may be interpreted incorrectly. Select the headings along with the data, then check the header option in Setup.
Including totals in the plotted data. A grand total is usually much larger than any individual category and can flatten the other columns visually. Keep totals outside the range used for the chart, or edit the Data range so only the categories you want to compare are included.
Using the wrong chart type. A line chart emphasizes changes across a sequence, while a bar chart uses horizontal bars. Choose Column chart for vertical columns. If your category names are long, however, horizontal bars may be easier to read, so the best chart type depends on the data and available space.
Mixing incompatible values. A chart is hard to interpret if a series combines different units, such as dollars and percentages. Split unrelated measures into separate charts or choose a suitable display for each measure. Also check that numeric entries have not been stored as text; text values may be ignored or plotted unexpectedly.
Overloading the chart. Too many series, labels, colors, or long category names can make the graph difficult to scan. Focus on the comparison the reader needs and remove data that does not help explain it.

Tips

Use consistent categories. If you are comparing values over time, use the same time interval throughout the table, such as one row per month. Do not mix monthly totals with a quarterly total in the same series unless that difference is clearly intentional.
Keep the source table tidy. Put units in the heading rather than repeating them in every cell. For instance, use Revenue (USD) as the series heading and enter numeric values in the cells. This makes the chart data easier to interpret and keeps labels clean.
Decide whether data labels are necessary. Labels can be handy when people need exact values, but they can clutter a chart with many columns. If approximate comparisons are enough, leave labels off and rely on the axis scale instead.
Use the legend only when it adds information. A single series may not need a legend if the chart title and axis title explain the values. For multiple series, keep the headers distinct and leave the legend visible so readers can identify each color.
Check the vertical scale. Sheets generally chooses a scale automatically. If small differences appear exaggerated or important differences are hard to see, open Customize > Vertical axis and review the minimum and maximum settings. Use a scale that represents the values honestly and does not hide relevant variation.
Think about where the chart will be viewed. A graph that fits on a desktop screen may be cramped when printed or viewed on a smaller display. Resize it and check the title, labels, and legend at the size your audience will see. If needed, shorten category names in the source data or make the chart wider.

Troubleshooting

The chart is blank or missing some columns. Open Edit chart > Setup and inspect the Data range and Series fields. Make sure the selected range includes the cells with numbers. Check whether the missing entries are truly numeric rather than text, and remove accidental blank rows or cells that split the range. If the source data has changed, select the correct cells in the Data range field.

The category names appear as bars or in the legend. Confirm that the data range includes the header row, then check Use row 1 as headers and Use column A as labels. If the preview still has the wrong arrangement, toggle Switch rows/columns and see whether the categories move to the horizontal axis. The right orientation depends on how the source table is arranged.

The chart shows generic labels such as Series 1. The series heading may be missing from the selected range, or the header option may be off. Add a clear heading above the numeric values, include that cell in the Data range, and enable Use row 1 as headers when headings are in the first row. If the chart uses a different layout, check that the heading is in the row or column Sheets is treating as labels.

The columns are all the same color or the legend is confusing. For one series, a uniform color is normal. For several series, first confirm each numeric column has a different heading and appears separately under Series in Setup. Then use Customize > Series to select and format a series. If the legend labels are unclear, improve the source column headings and verify that Sheets is using them as headers.

New data does not appear. Click the chart, choose Edit chart, and expand the Data range in Setup. Extend the range to cover the additional rows or columns, including any new heading if you added a series. Keeping new entries next to the existing table can make the source range easier to maintain, but always verify the range after adding data.

The title or labels are cut off. Enlarge the chart by dragging a corner handle, or shorten the title and category names. If the legend takes up too much space, consider moving it in Customize > Legend or removing it when there is only one series and it is not needed. Recheck the chart at the final size rather than judging it only in the larger editing view.

Frequently Asked Questions

Is a column graph the same as a column chart?
Yes. In Google Sheets, the chart type is called Column chart. It displays values as vertical columns, which many people informally call a column graph.

How do I make a column graph with two or more series?
Put the shared categories in the first column and each numeric series in its own column, with a heading for every series. Select the complete table, including headings, insert a chart, and choose Column chart. Check Setup to confirm the categories are on the X-axis and each value column appears as a separate series.

Can I change the chart after creating it?
Yes. Click the chart, open its three-dot menu, and select Edit chart. Use Setup to change the chart type or data range, and Customize to change titles, colors, labels, and other display options.

How can I show the exact value above each column?
Open the Chart editor’s Customize tab, expand Series, and turn on Data labels. If the chart has several series, check that the labels remain readable and do not overlap.

Can I make a column graph from non-adjacent cells?
It is usually simpler and less error-prone to arrange the categories and values in one contiguous table first. If your data is in separate ranges, you can edit the chart’s Data range in Setup, but verify the X-axis and Series fields afterward to ensure Sheets pairs each category with the intended value.

Does this work differently in Excel?
These instructions use Google Sheets in a web browser, where you choose Insert > Chart and set the type in the Chart editor. Excel has its own chart tools and menu paths, so the steps and labels are not identical.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.