In this article, I will show you how to create quarterly charts in Excel.
Quarterly sales data preparation
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 plot such reporting graph easily.
Creating quarterly chart
Next step is to create a simple sales quarterly 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 rows and columns to group by quarter to make it look better:
Clicking ok will make the graph look like this:
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:
For the 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.