Free Bar Chart Generator

Make a bar chart from Google Sheets data

In Google Sheets, copy the category and numeric columns with their headers. Choose Paste data in the tool above, paste the selected cells, and review the Category and Value fields. Copy the table itself rather than a chart image or a Sheets sharing URL.

Choose a category column and one or more numeric series. Keep category labels unique, exclude totals that duplicate the plotted values, and use comparable units for grouped bars. Choose horizontal orientation for long category labels. This creates a separate chart from the copied values and does not synchronize later changes in Sheets.

Follow the Google Sheets bar graph tutorial →

Statistics bar graph: compare category values

A statistics bar graph compares a summary measure, such as a count, mean, or percentage, across named categories. It works for regional revenue, support requests by issue type, product conversion rates, or budget versus actual spending. A single numeric field gives one bar per category. Select several comparable numeric fields to create grouped bars, making differences within each category visible without opening a larger reporting project.

For example, a fictional sales table can list North, South, East, and West beside their revenue. The bar lengths answer which region sold more and how large the difference was. Add a second revenue column for a different period when you want a side-by-side comparison. Keep the measurement unit and time window consistent so that the bars answer the same question.

When to choose another chart

Use the line graph maker when the main question is how a measure changes over an ordered sequence. Choose the pie chart maker for a few non-negative shares of one complete whole. For the distribution of raw numeric observations, such as individual order values, use a histogram. Our histogram vs bar chart guide explains why a frequency distribution needs different input.

Bars are also different from points on a scatter plot. If every row contains two numeric measurements, such as advertising spend and sign-ups, a scatter plot maker lets you examine their relationship. Turning those observations into named bars may hide the pattern. Choose the visual question before choosing colors or arranging the legend.

Prepare categories and numeric series

Use the first row for field names, followed by one row per category. A category column supplies labels; one or more numeric columns supply the bar values. Keep titles and explanatory notes outside the imported range. Do not include a Total row unless you deliberately want it to appear as an additional bar. For a spreadsheet walkthrough, follow how to make a bar graph in Excel.

Try this fictional table to compare planned and actual revenue in the same unit. The bar chart maker should identify Region as the category and both numeric columns as value fields. You can uncheck either series to return to a single-series chart.

Region,Planned revenue,Actual revenue
North,120,132
South,100,94
East,90,106
West,110,101

Every category must be non-empty and unique. When several source rows describe the same region, aggregate them in your spreadsheet first and decide whether the intended measure is a total, average, or count. The tool cannot infer that business rule. Missing values and invalid numbers must also be corrected. A blank is not automatically a zero: zero means the measure was observed and its value was zero.

Ordinary numbers and explicit percentages are supported. Use one format throughout each selected value column; mixing 37.5% and 42 in that column is rejected. Grouped series share a value axis, so compare measures with the same unit. Revenue beside conversion rate is misleading even when both columns contain valid numbers. Prepare separate charts if the measures answer different questions.

Three steps to a useful chart

Import and review

Open CSV, TSV, XLS, or XLSX, paste cells, or start with fictional sample data. Excel imports read the first worksheet. The shared import limits are 10 MB, 2,000 rows including the header, 100 columns, and 20,000 cells; the chart-specific category limit still applies. Review the selected fields before trusting the first preview. Automatic detection is a starting point, and the controls let you correct it.

Read and refine

Choose Vertical or Horizontal. Horizontal bars give long category names more room; vertical bars work well for short labels. Multiple selected value fields can form grouped, stacked, or 100% stacked bars. Choose Grouped for negative values; stack only series that add to a meaningful total. Keep the zero line visible, inspect positive and negative values, and use the legend to check which series each color represents. Adjust labels and decimal places for the precision your source supports.

Add a clear title, subtitle, source note, and any relevant qualification through the presentation controls. Use the available publication styles and canvas choices to fit the destination. A larger chart is not automatically clearer: a short title, consistent units, and fewer competing labels usually help more. Hover over marks to inspect the full category and value when labels are shortened.

Export your result

Download SVG when you need a vector figure that can be resized or edited in compatible design software. Choose PNG at 1×, 2×, or 3× for documents and slides, and check the transparent-background setting against the destination color. Open the downloaded image once before sharing it. Keep the original spreadsheet alongside the export so you can reproduce the chart when the numbers change.

Make comparisons readable

Order categories in the source table before importing when ranking is the point. Preserve a meaningful order for stages, age bands, or months. Use the same color for the same series across several reports. Avoid adding decimal places that imply more certainty than the data provides, and label an absolute change differently from a percentage change.

The bar chart creator supports up to 50 categories, but showing every available category is not always useful. Start with the comparison that informs the reader's decision. If you filter out rows, state the selection and keep the complete data available. A chart of selected categories should not be presented as the total market or entire population.