How to Make a Bar Chart in Excel with Time

Visualizing data over time is one of the quickest ways to spot trends, understand performance, and tell a compelling story. While line charts get a lot of attention for showing continuous change, the humble bar chart is a powerful tool for comparing discrete time periods - like this month's sales versus last month's. This tutorial will walk you through exactly how to create and customize a bar chart with a time series in Excel, turning your raw numbers into a clear, professional visual.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use a Bar Chart to Show Data Over Time?

You might be wondering, "Shouldn't I just use a line chart for everything related to time?" Not necessarily. The best chart type depends on the story you're trying to tell.

• Bar charts (or column charts in Excel) are excellent for comparing distinct periods. They emphasize the magnitude of the value in each period. This is perfect for comparing monthly revenue, quarterly user signups, or weekly website traffic. Each bar represents a distinct, self-contained block of time.
• Line charts are better for showing a continuous trend or the rate of change over time. They connect the data points, which suggests a constant flow and helps highlight acceleration or deceleration. Use them when you want to show the overall journey of a metric.

For our purposes, we'll focus on the column chart, which is what Excel calls a vertical bar chart. It’s ideal for showing progression over time since we naturally read time from left to right.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready for Charting

Before you click a single button in Excel's chart menu, the single most important step is setting up your data correctly. A well-organized table makes the process seamless, a messy one leads to frustration and charts that don't make sense.

Your data should be organized into at least two columns:

1. A Date/Time Period column (e.g., daily dates, month names, quarters).
2. A Metric column with the numerical values you want to plot (e.g., Sales, Sessions, Downloads).

Here's an example of a perfectly structured table showing monthly website sessions:

Example Data Table:

+-------------+----------+ | Month | Sessions | +-------------+----------+ | Jan-2024 | 15,400 | | Feb-2024 | 17,250 | | Mar-2024 | 19,800 | | Apr-2024 | 18,500 | | May-2024 | 21,100 | | Jun-2024 | 22,500 | +-------------+----------+

The Golden Tip: Format Your Dates Correctly

This is where most people get tripped up. For Excel to recognize your time series, the values in your date column must be formatted as dates, not as plain text.

If you type "January," Excel sees it as text. If you type "1/1/2024," Excel recognizes it as a date. Getting this right ensures your chart's x-axis plots chronologically.

How to format your dates:

• Select your entire date column.
• Right-click and choose "Format Cells..."
• In the popup window, under the "Number" tab, select "Date" from the category list.
• Choose a format that works for you. You can always change how it's displayed on the chart later.

Step 2: Create a Basic Bar Chart in Excel

Once your data is neatly organized, creating the chart takes just a few clicks.

• 1. Select your data range. Click and drag your cursor to highlight all the cells in your table, including the headers ("Month" and "Sessions").
• 2. Go to the Insert tab. In the Excel ribbon at the top, click on "Insert."
• 3. Choose the Column Chart. Find the "Charts" section and click the icon that looks like a small column chart. A dropdown menu will appear with different chart types.
• 4. Select a 2-D Column Chart. For most time-series visualizations, the first option, "2-D Clustered Column," is the best choice. It's clean, simple, and easy to read.

And that's it! Excel will instantly generate a column chart on your worksheet. It should have the months along the horizontal (X) axis and the session values represented by the heights of the bars along the vertical (Y) axis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Customize Your Chart for Maximum Clarity

A default Excel chart gets an "A" for effort but a "C" for presentation. It gets the data right, but it lacks the professional polish needed for a report or presentation. Here's how to fix that.

You can access most customization options by clicking the green "+" icon that appears to the upper-right of your selected chart or by exploring the "Chart Design" and "Format" tabs that appear in the ribbon when your chart is selected.

Give Your Chart a Descriptive Title

Never leave the default "Chart Title" in place. Click on it and change it to something that tells the viewer exactly what they are looking at. Be specific.

• Bad Title: Chart Title
• Good Title: Website Sessions by Month
• Excellent Title: Website Sessions by Month (January-June 2024)

Add Axis Titles

While the month axis is often self-explanatory, the vertical axis needs a label so your audience knows what the numbers represent. Is it dollars, units, or percentages?

1. Click on your chart to select it.
2. Click the "+" icon.
3. Check the box for "Axis Titles."
4. Text boxes will appear on your chart. Click the vertical axis title and type in your metric name (e.g., "Sessions," "Revenue ($)").

Improve the Design and Colors

A splash of color can make your chart look more professional and align with brand guidelines. Avoid using clashing or overly bright colors that distract from the data.

• To change bar color: Right-click on one of the bars, select "Format Data Series...", click the paint can icon ("Fill & Line"), and select a new "Fill" color for your bars.
• To use a pre-set style: Click on your chart and go to the "Chart Design" tab. Here you can browse different visual styles that automatically adjust colors, add shadows, and more.

Add Data Labels for Quick Scans

Sometimes it's helpful for your audience to see the exact value of each bar without having to guess by looking at the axis. Data labels solve this.

1. Click the "+" icon next to your chart.
2. Check the box for "Data Labels."
3. Values will appear on top of each bar. You can click on these labels and use the formatting pane to change their font, size, and position.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Format the Time Axis

With time data, the horizontal axis might need some adjustments to be perfectly readable, especially if you have a lot of data points.

• Right-click on the date axis labels at the bottom of your chart.
• Choose "Format Axis..." from the menu.
• In the "Format Axis" panel that opens, look for "Axis Options." You can adjust things like the interval between tick marks ("Major Units") if the axis looks too crowded.
• Under the "Number" section, you can change how the dates are displayed without affecting the source data. For instance, you could change "1/1/2024" to display as just "Jan" or "Jan '24" by using a custom format code like mmm ''yy.

Common Pitfalls (And How to Fix Them)

Creating charts in Excel is straightforward once you know the steps, but a few common issues can trip you up.

• Data Plotted in the Wrong Order: If your months or dates are not chronological, it's almost always because Excel is treating them as text. Go back to Step 1 and make sure your date column is correctly formatted as a Date type.
• Chart is Too Crowded: If you're plotting a year's worth of daily data, a bar chart will become an unreadable mess of tiny bars. In this case, either switch to a line chart or aggregate your data by week or month to get a clearer picture.
• Misleading Vertical Axis: To give an honest representation of scale, your vertical (Y) axis should always start at zero for bar charts. While Excel does this by default, be cautious if you manually adjust the axis minimum, as it can exaggerate small differences.

Final Thoughts

Creating a bar chart with a time series in Excel is a fundamental skill for anyone working with data. By ensuring your data is structured properly, using the "Insert" menu to create the chart, and then customizing its titles, labels, and colors, you can easily turn a simple spreadsheet into a professional and insightful visual.

Manually preparing this data and building these visuals in spreadsheets is the reporting reality for many teams, but it does take time and effort. We built Graphed to remove this friction. Instead of downloading CSVs and building a chart from scratch, you can connect your data sources - like Google Analytics or Shopify - and simply ask in plain English: "Show me a bar chart of monthly sessions for the first half of the year." Graphed generates a real-time dashboard for you in seconds, saving you from the manual work and keeping your reports continuously up-to-date.