OmniDocHow to display values, data labels and units in PPT charts
Explain how to display numerical values in a PPT chart: first open the data label, then fill in the unit with a numerical format, and finally check whether the label is consistent with the data source. Suitable for people who need to make the chart numbers clear at a glance before reporting.
Key points of this article
- Displaying values relies on data labels, which are three things together with axis scale and chart type, and can be set separately.
- Units can be written in numerical format, such as adding "ten thousand yuan" or "%" after the number, so there is no need to manually type each number.
- When there are many numerical labels, appropriately reducing the number of decimal places makes it easier to read than squeezing each number onto the column.
- After the source data is changed, the data labels will usually be updated accordingly, but the label text that has been manually changed will not change automatically and needs to be rechecked.
- Check on the target device before showing that the label is not blocked or overlapped with other elements.
When making reports, we often encounter the following situation: the heights of the columns of the chart are clear, but the audience cannot tell the specific heights. At this time, you need to let the chart display the values directly. Many people search for "how to display numerical values in PPT charts". In fact, what they want to solve is two things: one is to make numbers appear next to each data point, and the other is to make these numbers have units, such as "10,000 yuan", "%" or "person-time".
This article only talks about settings such as data labels and units. The axis scale of the chart, the choice of chart type, and the color and matching are all separate issues and will not be discussed here. After reading this, you should be able to label a chart with values, add units to numbers, and complete verification before delivery.
The operations in this article are based on general ideas. Different versions of the demo software will have different location of options, but the logic is the same. The desktop client of OmniDoc can process documents such as PDF and Word, and is mainly used for document translation and editing. The setting of chart labels must be completed in the PPT software used to create charts.
How to display values in PPT charts? One sentence conclusion
Direct answer: Use "data label" to display the numerical value, and use "numeric format" to add the unit. Do the two steps separately. Do not manually enter the numbers one by one.
| your situation | Recommended practices | reason |
|---|---|---|
| I just want specific numbers to be displayed next to each bar or point | Open the data tab and keep the default number format | The value comes directly from the source data. After changing the data, the label will change accordingly. |
| Numbers need to include units such as "10,000 yuan", "%", "person times", etc. | Add custom suffix to number format | The units are uniformly written in the format, and the labels are still dynamic values. |
| There are too many digits and the labels are crowded together | Set the number of decimal places uniformly, and change to integers or tens of thousands if necessary. | Reduce the number of characters and make it easier for readers to scan |
| The label needs to display other text, such as "year-on-year increase" | Use custom label text, or add a column of descriptive text | In this case, the label will no longer be updated with the data, and must be manually checked after changes. |
| The chart needs to be put into someone else’s Word or PDF | Complete the labels in PPT first, then export or embed them | Labels belong to the chart itself, and can be set up before exporting to save trouble. |
Before you start: Confirm these points first
Before you start, think about the following items clearly, which can save a lot of rework.
- Confirm whether the data source is correct. Data labels display the values behind the chart. If there are null values, text, or redundant total rows in the source data, the labels will also be incorrect. Check it in the form first.
- Determine the unit and order of magnitude. Whether the original number is "12345000" or "12.345 million yuan" determines how the number format is written. Decide first whether to use "yuan", "ten thousand yuan" or "hundred million yuan", and keep it consistent throughout the article.
- Determine whether all data points need to be displayed. If it's a 12-month line chart, it can be very dense to number each point. Key data can be kept with separate labels, and the rest can be deleted to allow readers to focus on the key points.
- Confirm whether the chart is a "real chart" or a picture. If the chart is screenshotted and pasted from elsewhere, labels cannot be set directly in PPT. Need to go back to the original data and regenerate the chart.
- Consider viewing environment. When projecting or viewing from a distance, the label font size should be large enough; when printing or placing it in a document, the label can be more compact.
Steps to add values and units to charts in PPT
Below is a set of common operations for common charts such as column, bar, line, and pie charts.
- Select the chart. Click in the chart area to confirm that the chart is in edit mode and not just the outline or text selected.
- Open the chart elements menu. Find the "Chart Elements" or similar plus button next to the chart, which usually brings together options such as title, legend, axes, and data labels.
- Check the data label. Enable Data Labels in the chart element and numbers should appear next to each data point. If the position of the number is inappropriate, you can adjust it in the label position options, such as placing it at the end of the column or in the middle.
- Set the number format. Enter the format settings of the data label, find the "Number" related options, select the normal numerical format in the category and set the number of decimal places. When an integer is required, set the decimal place to 0 to avoid unnecessary zeros in the label.
- Add unit suffix. In custom number formats, write the unit after the number, such as
0"万元"or0.0"%". The text within the quotation marks will be displayed as is, while the numeric portion will still change with the data. - Unify the format of similar charts. For multiple charts on the same page, the units and decimal places should be consistent. After checking one page, you can copy the format or compare them one by one to avoid writing "ten thousand yuan" on one page and "yuan" on the other.
- Adjust the label position and font size. If the label overlaps the column, line, or legend, change the label position or slightly reduce the font size. The font size of labels should form a hierarchy with the chart title or text size, and should not be more eye-catching than the title.
- Check whether the data is consistent with the display. Randomly compare several labels with the numbers in the source table to confirm that there are no errors in unit conversion. For example, if the source table is in integer yuan and the chart is switched to ten thousand yuan, the decimal places are reasonable.
Check each item after completion
After the chart is completed, do not put it directly into the text. First, go through it according to the table below.
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Whether all labels are displayed | Look at the data points one by one to see if there are any missing columns or points. | Check if data labels are enabled for the series and turn them on individually for the series if necessary |
| Are the numbers consistent with the source data? | Randomly select a few tags and return to the table to check | Check the source data. If the label text has been manually changed, regenerate it using numerical values. |
| Are the units correct and uniform? | Check whether "10,000 yuan", "yuan" and "%" are consistent with the description in the header | Modify the digital format and unify all charts of the same material |
| Are the decimal places reasonable? | Check whether the number of digits in the same column is consistent | Unify decimal places or use larger units |
| Whether labels are obscured or overlapped | Screen or zoom in to inspect dense areas | Adjust label position, reduce font size, or keep only key labels |
| Whether to update after changing the data | Modify a source data and observe whether the label changes | If the tag does not move, it means it has been manually changed and needs to be deleted and re-added. |
📊 Core comparison
There are four common ways to add values and units to charts. The difference mainly lies in whether the labels change automatically with the data and whether maintenance is convenient.
| practice | Whether the label is updated with the data | Suitable for the scene | Things to note |
|---|---|---|---|
| Data label plus number format | yes | Most numerical displays | The units are written in the format, so you don’t have to worry. |
| Data labels plus custom text | no | When explanatory text is needed | Data needs to be updated manually after changes |
| Write the unit in the axis title | not applicable | When the unit only needs to be stated once | Readers need to refer to the axes to understand the numbers |
| Write the unit in the chart title | not applicable | When the whole picture has only one unit | Just write it clearly in the title, but each label still has no unit. |
In most cases, it is recommended to use data labels plus number format first, and then use coordinate axes or titles to supplement explanations as necessary.
❓ Frequently Asked Questions (FAQ)
1. How to display data in PPT charts, is it the same thing as displaying numerical values?
Basically the same thing. Both refer to displaying numbers corresponding to data points on a chart, usually through data labels. If you want to display other columns in the original table, such as growth rate, you need to add this column to the data source first, and then set the content displayed by the label.
2. How to add units to the ppt chart? Can I type manually after each number?
Manual typing is possible but not recommended. Manually entered text will not be updated with the data, and it is easy to miss changes after changes. By writing the units into a number format, the labels will remain dynamic and can be modified more securely.
3. What should I do if there are too many numbers in the chart labels and they are crowded together?
First reduce the number of decimal places, and then consider changing the unit to "10,000" or "100 million". If it is still crowded, you can keep only the labels of key data points and delete the rest. The purpose of a chart is to help readers quickly grasp the key points, without showing every number.
4. The chart is copied from a web page or other file, why can’t I set a label?
If the copied content is an image, it does not contain editable data. You need to find the original data, regenerate the chart in PPT, and then set the labels and units.
5. Will the labels be lost after the chart is put into Word or PDF?
As long as the chart is an editable chart in PPT, the labels will usually remain with the chart. After exporting, please open the file to check whether the labels are complete and the units are clear. If the document needs to be translated into other languages, the numbers and units should be checked again after translation, because machine translation may change the way the units are written.
📝 Summary
The key to how to display numerical values in a PPT chart is to first open the data label, and then fill in the unit with a numerical format. If you do these two steps separately, the label will automatically change with the data. Once completed, check the data, units and overlaps one by one according to the checklist so that the chart can be used in the report to make the numbers clear to the audience at a glance.
