How to Make a Bar Graph in Excel

To make a bar graph in Excel, select a table with category names and numeric values, open Insert, and choose a 2-D Clustered Bar chart. Add a descriptive title, check the category labels, and keep the value axis starting at zero for an honest comparison.

In Excel's chart menu, Bar means horizontal bars and Column means vertical bars. People often use “bar graph” for both. Choose Clustered Bar for long category labels, or Clustered Column when you prefer upright bars. This tutorial begins with one series and then adds a second for a planned-versus-actual comparison.

The instructions target recent desktop versions of Excel, including Microsoft 365. Ribbon names and available commands can vary on Mac and Excel for the web. Microsoft's chart creation guide provides version-specific help; its chart-type reference explains the distinction between bar and column charts.

Start with a small, clean table

Use one header row and one row for each category. Keep units consistent and place notes, merged titles, and grand totals outside the selected range. Excel needs to distinguish labels from the values that determine bar length. A neat table makes that choice easier and helps you spot errors before they become a polished-looking chart.

Download the fictional revenue CSV and open it in Excel. The table should occupy cells A1:C5. If your regional settings place everything in one column, use Excel's text/CSV import flow and specify a comma delimiter. Check the preview before loading so the headers and values land in separate columns.

Create a single-series bar chart

1. Select the categories and one value column

For the first chart, select A1:B5: Region and Planned revenue, including their headers. The four region names should become category labels, while the four revenue numbers determine bar lengths. Avoid selecting an entire worksheet or adding empty rows underneath the table. A precise selection reduces the chance of stray labels or unexpected series appearing.

2. Insert a 2-D Clustered Bar chart

On the Insert tab, find the column/bar chart menu and choose the 2-D Clustered Bar option. You can also use Insert → Recommended Charts, then inspect All Charts if the recommended choices do not include the layout you want. Choose Clustered Column instead if you want vertical bars. The fictional regional comparison does not require 3-D effects or a stacked layout.

Inspect the result before formatting it. There should be four categories and one series called Planned revenue. North should have the longest bar at 120, followed by West at 110, South at 100, and East at 90. The displayed category order may differ between horizontal and vertical layouts, but each label must remain paired with the correct value.

3. Add a title, units, and useful labels

Replace the default title with something specific, such as “Planned revenue by region — fictional example.” Use the chart element controls or Chart Design → Add Chart Element to add axis titles and data labels where available. For this small table, numeric labels make the exact values easy to read. With many categories, labels may need more room or may be unnecessary.

A legend for a single series often repeats information already contained in the title. Remove it if that makes the chart easier to understand. Keep enough gridlines to read the scale without competing with the bars. Use a consistent color unless highlighting a particular region serves a clear purpose. Color differences alone should not imply differences that the data does not contain.

Add a second series for grouped bars

To compare planned and actual revenue, select A1:C5 and insert another Clustered Bar or Clustered Column chart. Each region should now have two neighboring bars, one for each measure. In the example, North's actual revenue is 132 compared with a plan of 120; South is 94 compared with 100. The chart makes both over- and under-performance visible in one view.

Use the legend to identify Planned revenue and Actual revenue, then check every pair against the table. Both series use the same unit, so a shared value axis is appropriate. Do not add a percentage conversion-rate column to this chart just because it is numeric. A currency amount and a percentage need separate context; mixing them on a common scale obscures their meaning.

Clustered bars compare series side by side. Stacked bars add them together. Planned revenue and actual revenue are alternative measures of the same performance, so their sum is usually not a useful total. Select the chart type based on the question, rather than choosing a visually attractive option that changes the interpretation.

Fix the most common problems

The series and categories are reversed

If the chart groups by Planned revenue and Actual revenue while treating North and South as separate series, check the source range and header row. With the chart selected, Chart Design → Switch Row/Column can change how supported chart types interpret the table. Review the preview afterwards. The intended grouped chart has regions as categories and the two revenue fields as series.

Some bars are missing or values look wrong

Check whether numbers were imported as text, whether the selected range excludes a row, and whether a hidden or filtered row affects the view. Also inspect decimal and thousands separators. A cell that looks like 1,200 can mean something different under another locale. Verify the values in the worksheet before adjusting the chart; a formatting change cannot correct an incorrectly parsed number.

The category labels are too long

Try a horizontal bar chart and increase the chart height. Shorten labels only when readers can still identify the categories, and preserve the full names in the source table. If you sort by value, sort the entire table so labels and all series stay together. Sorting just the numeric column would pair values with the wrong regions.

Small differences look exaggerated

Bar length is interpreted relative to its baseline. Keep zero visible for ordinary magnitude comparisons rather than trimming the value axis to a narrow range. If the data includes negative values, retain a clear zero line and a range that accommodates both signs. Write “change in revenue” when values are changes, rather than letting readers mistake them for revenue totals.

Export a separate chart in Charttoolbox

If you want to keep chart editing tied to the workbook, Excel already provides that workflow. If you want a separate PNG or SVG from a small table, the Charttoolbox bar graph maker offers a browser-based option. This creates a new chart from the table values; it does not import an existing Excel chart's formatting or maintain a live connection to the workbook.

1. Copy the header row and the four data rows, then choose Paste data in the bar chart workspace. Alternatively, open the CSV or Excel file. For XLS/XLSX, put the relevant table on the first worksheet.
2. Review the detected fields. Set Category to Region. Choose Planned revenue alone for a single series, or select both revenue fields for grouped bars. Check the preview against the source numbers.
3. Choose Vertical or Horizontal, adjust the title, labels, palette, and presentation settings, and export PNG or SVG. Open the downloaded file before using it in a report.

Charttoolbox accepts at most 50 unique categories for a bar chart. Duplicate or blank category labels, invalid numeric values, and inconsistent percentage formats within a selected column require correction. The tool does not automatically aggregate repeated categories. If your spreadsheet contains one row per transaction, summarize it by region first rather than assuming the chart will choose the aggregation for you.

Spreadsheet contents are processed locally in the browser. Optional analytics requires consent and does not receive the table contents. Save the original workbook and exported chart yourself: the browser workflow does not create a saved cloud project. When the figures change, import the updated table and export a new image.

Choose a different chart when the question changes

For monthly revenue trends, a line chart maker emphasizes the ordered sequence. For individual transaction values, a histogram answers how those observations are distributed. A bar graph of region totals and a histogram of raw transactions answer different questions even though both use rectangles. See our histogram versus bar chart comparison before switching between them.

A pie or donut can communicate a small number of shares of one whole, but planned and actual revenue should not become slices of one pie. Their sum combines two different views of the same activity. For the example in this guide, grouped bars are the appropriate starting point. The final check is simple: can a colleague name the category, unit, period, and comparison without opening your spreadsheet?