Chart with Hours

In this Article we will learn how to create the Excel chart with hours in the best way possible.

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

chart hours data table

Now lets start creating a xy scatter graph:

scatter chart with smooth lines and markers

This is how the graph will look like:

chart with hours

Adding dates to the data column A. Make sure Axis Type is set to Time Axis When you are creating a line, column 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 equal distance from each other.

It will look like this now:

chart with hours example