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

Start with the creation data for the hour by hour chart, which will have data flowing with hours:

Creating a chart with hours

Now, let’s start creating a xy scatter graph:

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

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.

You can also format the chart by changing the font size, adding gridlines, labels, title, adjusting the color scheme and other formatting options.

The chart with hours is ready.

Related posts:

How to Make a Pie chart How to Add Scroll Bar in Excel Chart Chart with confidence intervals