Chart with Hours

In this Excel charting tutorial lesson, you will learn how to create an Excel chart with hours in the best way possible.

Preparing data for chart with time

Let us start with the creation data for the hour by hour chart, which will have data flowing with hours:

chart hours data table

Creating a chart with hours

Now let's start creating a xy scatter graph:

scatter chart with smooth lines and markers

This is what the graph with time duration will look like:

chart with hours

Adding the dates to the data column A. Make sure the Axis Type is set to Time Axis. When you are creating a line chart, column graph or bar chart, Excel will automatically treat date data as a "Date axis". This means that each data point will be plotted on the x-axis based on linear time, rather than an equal distance from each other.

It will look like this now:

chart with hours example

The chart with hours is ready.