Creating Quarterly Sales Chart by Clustered Region in Excel 365!!
Tags: creatingaquarterlysa
Published: 2021-08-07 06:16:34

---
title: Creating Quarterly Sales Chart by Clustered Region in Excel 365!!
published: true
date: 2021-08-06 11:59:59 UTC
tags: creatingaQuarterlySa
canonical_url: https://geekexcel.com/creating-quarterly-sales-chart-by-clustered-region-in-excel-365/
---

Have you ever tried **creating a Quarterly Sales Chart By Clustered Region** on your Excel sheet? Do you have any good methods for solving this task in Excel? Here I will introduce you to some quick tricks to deal with this problem. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Inserting The Clustered Column Chart

- Firstly, you have to **create the table with data**.
- For instance, we have shown the **company employee details** below.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-company-emp-details.png)<figcaption>Company EMP details</figcaption>

- Then, you have to click on the **Insert** tab.
- Now, in charts group, you need to find **2D column chart** and select the **clustered column** chart.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-cluserted-column-1024x552.png)<figcaption>Click on the Clustered Column</figcaption>

- Finally, after selecting the chart, you will get details in this chart format.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-2D-column-chart.png)<figcaption>Chart type</figcaption>

## Formatting the Quarterly Chart

- After selecting the clustered column chart, you need to **reduce the gap width**.
- For that, you have to **right-click** on any **column** in the chart and click on **format data series**.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-format-data-series.png)<figcaption>Click on format data series</figcaption>

- Then, the **sidebar** will open in Excel for the **formatting of the chart**.
- Now, you have to click on the **Series** Option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Series-option.png)<figcaption>Click on the Series option</figcaption>

- Finally, you need to **reduce the series overlap to 0** and create a **gap width** between **clusters 50%**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Reduce-overlap.png)<figcaption>Reduce the overlap</figcaption>

## Add Data Labels to Chart

- Firstly, you have to click on the **plus sign** on the right side of the chart, and click on the **data labels**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Data-Labels-2.png)<figcaption>Click on Data Labels</figcaption>

- Then, the **numbers are too large** to show on the chart, so you have to **abbreviate** the numbers by **thousands**.
- Now, you need to **select any data label** and go to the **Labels option** for formatting.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-label-option.png)<figcaption>Click on the Label option</figcaption>

- After that, you have to expand the **numbers option** and in the category, you have to select **custom**.

![](https://geekexcel.com/wp-content/uploads/2021/08/expand-the-number.png)<figcaption>Select Custom</figcaption>

- You have to write the following code in the **format code input box** , and click on the **Add** button.

```
 [>1000]#,##0,"K";0 
```

![](https://geekexcel.com/wp-content/uploads/2021/08/enter-the-code-1.png)<figcaption>Enter the code</figcaption>

- Then, after clicking the Add button, it will **add K** to represent **thousands** , and it will be done for the **series** you have **selected**.

![](https://geekexcel.com/wp-content/uploads/2021/08/add-k.png)<figcaption>Adds K to series selected</figcaption>

- Now, to **apply to every series** , you need to select **each of the series** and use **select this custom** formatting from type.

## Cleaning the Chart

- You need to **select the axis** and hit the **delete** button.
- Now, you have to **delete the grid lines** from the chart.

## Adjust the Legends

- Firstly, the **legends** are currently shown at the **bottom** of the chart.
- Then, you have to keep them on the **top** of the chart.
- For that, you need to **select the legends** , and go to the **formatting** option of **legends**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-top.png)<figcaption>Click on the Top in legend option</figcaption>

- Now, you can see **all the regions** are shown on the **top** of the chart.

## Name the Chart Appropriately

- You have to select the **Chart Title text box**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Chart-title-2.png)<figcaption>Click on the Chart Title text box</figcaption>

- Then, you need to **write the name** in the text box.

![](https://geekexcel.com/wp-content/uploads/2021/08/Write-the-name-in-text-box.png)<figcaption>Write the name in text box</figcaption>

## Verdict

From this chapter, you can get some clarification about **creating a Quarterly Sales Chart By Clustered Region In Excel 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**