Bar Chart by Month in Excel: Create, Format, and Read

To make a month-by-month chart in Excel, put each month in one column and its value in the next, select the two columns, then choose Insert > Insert Column or Bar Chart and select a chart type. Excel’s “bar” charts display the month labels vertically and values horizontally; if you want months along the bottom, choose a column chart instead.

What a monthly bar chart shows

A monthly chart compares one value for each month, such as sales, website visits, expenses, units produced, or support requests. The month is the category and the measured amount is the series. A simple chart might show January through December on one axis and total sales on the other. It can make seasonal patterns and unusually high or low months easier to notice than a long list of figures.

There is a small but important terminology distinction in Excel. A bar chart uses horizontal bars: categories appear on the vertical axis, and values run along the horizontal axis. A column chart uses vertical bars, with categories along the horizontal axis. People often use “bar chart” to mean either kind of chart in everyday conversation. Choose based on the layout you want, not just the name.

For one measure across twelve months, a clustered column chart is a familiar choice when month names should read from left to right. A clustered bar chart can be easier to read when category labels are long, or when the chart is narrow. Both compare month totals; neither changes the underlying data.

Arrange and check the monthly data

For a basic chart, create a compact summary table with one row per month and clear column headings. For example, A1 could contain Month and B1 could contain Sales, followed by January and its total in row 2, February and its total in row 3, and so on. Select the headings as well as the values so Excel can use the headings in the chart legend and the first column as category labels.

Before charting, check that every month is represented once, values are numeric, and the category order is chronological. If your source data contains individual transactions rather than monthly totals, do not chart each transaction as a separate category and expect a monthly summary. First aggregate the records by month, using a PivotTable, a formula, or a prepared summary table.

Actual Excel dates are often more useful than typed month names. For example, enter a real date such as 1/1/2026 for January and format it to display as January or Jan. This preserves the underlying date value and helps Excel order the months correctly. Text labels can also work, but labels such as Apr, Aug, Dec may be sorted alphabetically if you sort them as text rather than using a calendar order.

• Use one consistent unit, such as dollars, visits, or items, throughout the series.
• Decide how to handle missing months: show a zero only when the value is truly zero, not when the data is unavailable.
• Use a concise, descriptive heading such as Monthly Sales rather than leaving the chart title as Chart Title.

Create the chart from a summary table

With a clean two-column table, select the month labels and values, including their headings. In Excel for Microsoft 365 on Windows, go to Insert > Insert Column or Bar Chart. Under 2-D Bar, choose Clustered Bar for horizontal bars. To put months along the bottom, choose a 2-D Column option such as Clustered Column instead. Excel inserts a chart linked to the selected cells, so edits to the source values update the chart.

1. Click the chart title and type a meaningful title, such as Sales by Month.
2. Use the chart’s plus button, called Chart Elements, to add or remove elements such as axis titles, data labels, and gridlines. You can also use Chart Design > Add Chart Element on the ribbon.
3. Click the value axis to adjust its number format or scale. For currency, use a currency number format; for counts, use a suitable number format without unnecessary decimal places.
4. Resize the chart by dragging a corner handle, and move it away from the data table if it obscures cells.

If Excel assigns the months and values incorrectly, select the chart and use Chart Design > Switch Row/Column. For a two-column table this is not usually necessary, but it can help when the source table has multiple series. You can also choose Chart Design > Select Data to inspect the chart data range and edit the series or category labels.

On Excel for Mac, the same basic approach is available from the Insert tab, though the ribbon arrangement and some dialog details can differ. Excel for the web also supports creating standard charts from selected cells, but some formatting controls and advanced chart options may be more limited or placed differently than in the Windows desktop app.

Summarize transaction dates by month

If you have a list of dated transactions, a PivotTable is often the most straightforward way to create monthly totals without building separate formulas. Select the source data, including headers such as Date and Sales, then choose Insert > PivotTable. Place Date in Rows and Sales in Values. If Excel displays individual dates, right-click a date in the PivotTable, choose Group, select Months (and Years if the source covers more than one year), and confirm. Then select a cell in the PivotTable and choose Insert > PivotChart to create a chart tied to that summary.

Including Years matters when data spans multiple years. Grouping only by month can combine every January into one category, every February into another, and so on. That may be useful for comparing typical seasonality, but it is not a month-by-month timeline. To chart January 2025 through December 2026 in sequence, group by both Months and Years or create a summary that has a distinct date for each month.

A formula-based summary is another option when you want a regular chart table independent of a PivotTable. Assume transaction dates are in A2:A100, transaction amounts are in B2:B100, and month-start dates are in D2:D13, with each next month’s start date in the row below. In E2, use this formula to total the transactions from the date in D2 up to, but not including, the next month:

=SUMIFS($B$2:$B$100,$A$2:$A$100,