Time Series Graph

Are you responsible for preparing periodical reports? Does your company need you to create quarter reports? This Excel tutorial is perfect for you. Teach yourself here how to insert time series graphs in Excel.

First select your data.

data table

Then go to Insert > ScatterScatter with Smooth Lines. You will get a chart like this:

Scatter with Smooth Lines inserted

Edit horizontal axis. To edit horizontal axis right click horizontal and go to Format Axis. A tab will appear on the right.

format horizontal axis

Under axis options, change maximum to 4 and major (under units sections) to 1.

format axis min max

Delete horizontal gridlines. Your final graph will look like this.

time series graph ready

Template

You can download the Template here – Download