Make a Bar Graph in Google Sheets
Turn a category-and-value range into a readable chart, check the exact series, and add percentage error bars in the Google Sheets chart editor. The recorded demo uses a fictional monthly revenue table.
Reviewed by the SheetsX team
Month is the category axis and Revenue is the only data series.
A vertical bar graph titled Monthly Revenue with the legend hidden.
Added manually in Customize > Series because Sheets API v4 does not provide an error-bar property.
How do you create a bar graph in Google Sheets?
Select the category and value range, choose Insert > Chart, and set the chart type to Bar chart for horizontal bars or Column chart for vertical bars. Confirm the X-axis and series in Setup. To add error bars, open Customize > Series > Error bars, choose a type such as Percent, and enter the value. In the demo, SheetsX creates the column chart automatically and gives the exact manual steps for 5% error bars because the Google Sheets API does not expose an error-bar field.
Watch SheetsX build and verify a monthly revenue chart
The Agent creates a vertical column chart from A1:B6, sets the title, hides the legend, anchors the chart at E2, and verifies every chart field it can read back.
The chart is created automatically. The final on-screen answer clearly states that error bars were not added by the API and lists the five Google Sheets UI steps required to add 5% percent error bars.
“Create a vertical column chart from A1:B6 on the current sheet. Use Month as the category axis and Revenue as the only series, title it Monthly Revenue, hide the legend, position it at E2, and add 5% error bars if the API supports them. Otherwise explain the exact manual UI steps. Keep A1:C6 unchanged, create no new sheet, verify every result, and respond in English only.”
How to make a bar chart and add error bars
Start with a clean two-column range. Use a horizontal bar chart when category labels are long and a vertical column chart when time or ordered categories run left to right.
- 1
Select the category and value columns
Highlight the headers and data, such as A1:B6. Avoid blank rows and totals unless they should appear as separate bars.
- 2
Insert and configure the chart
Choose Insert > Chart. In Setup, select Bar chart or Column chart and confirm that the category column is the axis and the numeric column is the series.
- 3
Customize and verify
Set the chart title and legend, then open Customize > Series > Error bars if uncertainty should be shown. Verify the range, series, position, and visible labels.
Bar chart choices and error-bar settings
The right chart orientation and uncertainty type depend on the question your data should answer.
| Use case | Formula or setting | What it does |
|---|---|---|
| Long category names | Bar chart | Horizontal bars leave more space for labels and make category comparisons easy to scan. |
| Monthly sequence | Column chart | Vertical columns preserve a natural left-to-right time sequence, as shown in the demo. |
| Relative uncertainty | Error bars: Percent = 5 | Shows symmetric error bars equal to 5% of each series value. |
| Same uncertainty for every bar | Error bars: Constant | Uses one fixed amount above and below every value; choose a unit that matches the series. |
Let SheetsX create the chart, then finish UI-only settings
SheetsX can create, position, and verify a chart through the Google Sheets API. Settings absent from that API, including error bars, must be completed in the native chart editor and should be reported honestly.
Install SheetsX- Name the exact source range and desired chart orientation.
- Specify the category axis, series, title, legend, and position.
- Tell the Agent to preserve the source values and formatting.
- Ask it to verify the chart fields after creation.
- Complete error bars in Customize > Series when the API cannot set them.
Google Sheets bar graph questions
Is a bar graph the same as a column chart in Google Sheets?+
Both compare values with rectangular bars. Google Sheets uses Bar chart for horizontal bars and Column chart for vertical bars. Choose the orientation that makes the categories easiest to read.
How do I add error bars in Google Sheets?+
Double-click the chart, open Customize, expand Series, find Error bars, choose Constant, Percent, or Standard deviation, and enter the required value when that option asks for one.
Why do I not see the Error bars option?+
Confirm that the selected chart type and series support error bars, and make sure you are editing a numeric series under Customize > Series rather than the chart-wide Setup panel.
Can the Google Sheets API add error bars?+
The current Sheets API v4 BasicChartSeries schema does not expose an error-bar field. SheetsX can create and verify the chart, then provide the exact Google Sheets UI steps for the remaining setting.
How do I keep Google Sheets from using the wrong series?+
Use a clean range with one header row, then confirm the X-axis and each series in the chart editor. Remove totals, helper columns, or blank columns from the data range unless they are intentional.