When to Use Bar of Pie Chart in Excel 365? – Easy Tricks!!
Tags: usethebarofpiechart
Published: 2021-08-18 12:55:48

---
title: When to Use Bar of Pie Chart in Excel 365? – Easy Tricks!!
published: true
date: 2021-08-11 16:49:05 UTC
tags: UsetheBarOfPieChart
canonical_url: https://geekexcel.com/when-to-use-bar-of-pie-chart-in-excel-365-easy-tricks/
---

Have you ever tried to **Use the Bar Of Pie Chart** 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)**

## Creating and Customizing a Bar of Pie Charts

- Firstly, you have to **create the table with data**.
- For instance, we have shown the **list of items** below.

![](https://geekexcel.com/wp-content/uploads/2021/08/List-of-items.png)<figcaption>List of items</figcaption>

- Then, you have to click on the **Insert** tab.
- Now, you need to **choose Pie Chart** under the **[Chart](https://geekexcel.com/create-bar-charts-in-excel-office-365-simple-easy-steps/)**section.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-pie-chart-1024x451.png)<figcaption>Click on Pie Chart</figcaption>

## Add Slices of Pie to the Bar of Pie

- To **customize this bar of pie charts** , you have to **right-click** on any **slice of pie chart** and click on the **Format Data Series option**.

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

- Then, you need to click on the **Series** option.

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

- Now, in the **Split Series By** drop down, you have to select **custom**.

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

- After that, you need to **double-click** on the **bar chart** , and it shows **one more option visible**.
- You have to click on the **Points Belongs To** option.
- In our case, **currently** the selected point is **Eraser** , which belongs to the **first plot**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Clcik-on-the-Points-belong-to-option-1.png)<figcaption>First plot</figcaption>

- Now, to **move** the selected point to the **other plot of the chart** , you have to click on the **drop-down** and select the **second plot**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Second-plot.png)<figcaption>Second Plot</figcaption>

## Add Data Labels:

- Firstly, you have to **add the data labels** to show the percentage.
- Then, you need to click on the **plus sign** on the left of the selected chart.

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

- Now, you have to check for the **Data labels** option.

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

- After that, it shows the **numbers** but we want **percentages** to be shown on the bar and pie chart with the list of items.
- For that, you have to click on the **data labels** and go to **labels** of the **formatting** option.
- Now, you need to **check the percentage** and **category name** and **uncheck the value**.

![](https://geekexcel.com/wp-content/uploads/2021/08/percentage-format-1.png)<figcaption>Percentage format</figcaption>

- You need to show **decimal points** , move down in the same pane and expand **numbers** option.
- Then, in **categories** , you have to select **percentages** and in **decimal places** , you have to **select 1**.

![](https://geekexcel.com/wp-content/uploads/2021/08/decimal-value-1024x355.png)<figcaption>Decimal Values</figcaption>

- Now, if you don’t **need the legends** , you can **delete** them.

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

## Increase the explosion

- Firstly, if you want to take out the **other slice of pie chart** a little out, you can just **increase the explosion** from the **series** option.
- Then, you have to select the **other slice** by **double-clicking** on it and go to **formatting and increase the explosion**.
- Now, if you want to **increase the size of the column** in the pie chart, you can do that too here by **increasing or decreasing the plot size of the second plot.**

## Closure

Hope you like this article on how to **Use the Bar Of Pie Chart In Excel 365**. If you have any **questions** or **suggestions** regarding this lesson, feel free to use the **comments** section below to let us know.

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/) **!! **

**Read Next:**

- **[Excel Formulas to Increase a Number by a Certain Percentage ~ Quickly!!](https://geekexcel.com/excel-formulas-to-increase-a-number-by-a-certain-percentage/)**
- **[How to Use Formula Bar for Various Purpose in Excel 365](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**
- **[Excel Formulas to Generate Series of Date by Day ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-generate-series-of-date-by-day/)**
- **[Excel Formulas to Create the Series of Dates by Month ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-create-the-series-of-dates-by-month-simple-guide/)**
- **[Excel Formulas to Create a Series of Dates by Year ~ Complete Guide!!](https://geekexcel.com/excel-formulas-to-create-a-series-of-dates-by-year/)**