spot_img

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 tableNow 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

Chart with Hours is ready.

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell