Home >Software Tutorial >Office Software >How to display data and percentages in a bar chart in an excel table_How to display data and percentages in a bar chart in an excel table

How to display data and percentages in a bar chart in an excel table_How to display data and percentages in a bar chart in an excel table

PHPz
PHPzforward
2024-04-24 14:37:361271browse

Question: How to make an Excel bar chart display data and percentages at the same time? Want to display both raw data and percentages in a bar chart? PHP editor Strawberry brings you a simple method. Continue reading below to learn how to easily implement this feature to make your charts more comprehensive and intuitive.

Step one: Open the excel table, select the table, click to insert a chart, select the column chart style, and click [OK].

How to display data and percentages in a bar chart in an excel table_How to display data and percentages in a bar chart in an excel table

Step 2: Right-click the value to be displayed and click [Add Data Label] to display it.

How to display data and percentages in a bar chart in an excel table_How to display data and percentages in a bar chart in an excel table

The above is the detailed content of How to display data and percentages in a bar chart in an excel table_How to display data and percentages in a bar chart in an excel table. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete