How to Show Percentage in Pie Chart in Excel?

How to Format Chart Axis to Percentage in Excel?

Last Updated : 28 Jul, 2021

By default, in Excel, the data points in the axis are in the form of integers or numeric representations. Sometimes we need to express these numeric data points in terms of percentages. So, Excel provides us an option to format from number representation to percentage.

In this article, we are going to discuss how to format a chart axis to percentage in Excel using an example.

Example: Consider the dataset shown below :

Plotting a chart

The steps are :

1. Insert the dataset in the worksheet.

2. Select the entire dataset and then click on the Insert menu from the top of the Excel window.

3. Click on Insert Line Chart set and select the 2-D line chart. You can also use other charts accordingly.

4. The Line chart will now be displayed.

We can observe that the values in the Y-axis are in numeric labels and our goal is to get them in percentage labels.

In order to format the axis points from numeric data to percentage data the steps are :

1. Select the axis by left-clicking on it.

2. Right-click on the axis.

3. Select the Format Axis option.

4. The Format Axis dialog box appears. In this go to the Number tab and expand it. Change the Category to Percentage and on doing so the axis data points will now be shown in the form of percentages.

By default, the Decimal places will be of 2 digits in the percentage representation. You can change it accordingly. In our case, we made it 0 decimal places.

5. Close the Format Axis dialog box.

And finally, the chart has data in the form of percentage representation on the Y-axis.

How to Show Percentage in Pie Chart in Excel?

rishabhchakrabortygfg

Improve

Article Tags :

Similar Reads

How to Show Percentage in Pie Chart in Excel?

Pie charts are mostly used as it is more appealing and easy to understand for any type of audience. It is divided into various parts and each part of pie charts denotes a subcategory of the original data set. This sub-category data is sometimes shown using the original values or sometimes using perc

How to Rotate Pie Charts in Excel?

A Pie Chart is a circular statistical graphic, which is divided into slices to illustrate numerical proportion.In this article, we'll see how we can create and rotate pie charts. How to make Pie Charts in Excel ? Follow the below steps to create a pie chart in Excel: Step 1: Formatting data for pie

How to Create a Forest Plot in Excel?

Forest plots are an excellent way to convey a multitude of information in a single picture. Forest plots have become a recognized and well-understood technique of displaying several estimates concurrently, whether used to demonstrate various outcomes in a single research or the cumulative knowledge

Power BI - How to Format Stacked Column Chart?

Formatting is a technique to enhance the looks of the charts by giving a cosmetic appearance to the chart title and chart legend. Titles are given to the X and Y axis to add clarity for the user. Formatting commands are applied to a chart for the identical reason they're applied to a worksheet: they

How to Format the Labels of the Y Axis in a Chart ?

The y-axis in a chart is a basic aspect of data visualization that indicates the significance of data points and contributes to the overall visual appeal of the chat. Draw the chart using the chart.js JavaScript library. Formatting the y-axis also aids in conveying the meaning of data points. Below

How to Format X Axis Time Scale Values in ChartJS ?

In Chart.js, formatting the x-axis time values involves searching for ways to present temporal data effectively. By default, Chart.js supports time series data and provides powerful options to customize the appearance of time labels on the x-axis. There are several approaches to format x-axis time s

Power BI - How to Format Column Chart?

A column chart is a vertical chart, which could present a single bar with multiple stacks in it. We have various options to format column charts, we can change the value of the x-axis, y-axis, its title, etc. In this article, we will learn how to format a column chart in Power BI and explore its var

How to Put Count and Percentage in One Cell in Excel?

In the real world, sometimes the user would like to present two or more values in a single cell. For eg in the sales report, we might need sales and the respective %share in the same cell. So in this article, we will learn how to display count and percentage in the same cell with the help of an exam

How to Create a Goal Line on a Chart in Excel?

Excel is a powerful data visualization and management tool that can be used to store, analyze, and create reports on large data. Data can be visualized or compared using different kinds of plots in Excel such as line charts, bar charts, etc. A goal line is also called a target line. It helps show ac

How to Create a Chart from Multiple Sheets in Excel

Creating a chart from multiple sheets in Excel is a powerful way to consolidate data and visualize it in a meaningful way. Whether you're working with different datasets on separate sheets or need to compare data across multiple tabs, knowing how to create a chart from multiple sheets in Excel can s