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.

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:

Then select the stacked column option as shown below:

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

Clicking ok will make the graph look like as follows:

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

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

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.