How to create a quarterly chart in Excel?

In this article I will show you how to create quarterly charts in Excel.

In order to do the same the first step will be to create quarterly Sales data chart for a company have centers in 4 continents.

Quarterly Sales by Continent

We have to arrange the data similarly to make it look easy to understand and to create the graph easily from the same. Next step is to create a simple graph from the same. Select the insert column chart option as shown below:

Insert Column Chart

 

Then select the stacked column option as shown below:

Stacked Column

Next we can change the look of the chart by switching the row and column to group by quarter to make it look better:

Switch Row Column

Clicking ok will make the graph look like as follows:

Quarterly Chart Basic

We can make more customizations like adding data labels as shown below:

Quarterly Chart Adding Data Labels

We can change the chart title to the quarterly sales by continent etc as shown below:

Quarterly Chart Template

Rest we can make other customizations like we do for other graphs like moving legends up etc as per the requirements.

I am attaching the Excel sheet with Quarterly Chart template for you.