OmniDocHow to make PPT histogram: steps and comparison chart settings
It explains the complete steps of making a histogram in PPT, including choosing a column chart or a bar chart, filling in the data table, adding labels, setting the vertical axis and color, and providing a checklist after completion, which is suitable for readers who need to compare values in different categories.
Key points of this article
- Use a clustered column chart to compare the numerical values of different categories, and use a horizontal bar chart when the category name is long.
- Unify the units and caliber before starting, and check the original numbers when the data comes from PDF or scanned copies.
- The vertical axis starts from 0 so that the difference in column height is real. Do not truncate the coordinate axis in order to highlight the difference.
- Data labels and conclusion-style titles allow readers to understand comparative relationships without having to read.
- After finishing, check the values, check the order of categories and whether the labels overlap, and if there are any problems, go back to the data table for modification.
When making PPT, many people need to compare the performance of several departments, the prices of several products, or the changes in the same indicator in two years. This type of content is suitable for using bar charts. Most of the people who search for "How to make a bar chart in ppt charts" already have data, but they are stuck in selecting the wrong chart type, failing to fill in the data, or the columns they make look wrong.
This article only talks about histograms, which are charts that compare numerical values by category. Line charts are used to view continuous trends over time, while pie charts are used to view the proportions of each part of the whole. The methods and applicable scenarios of the two are different, and will be explained separately in the comparison section in this article.
After reading, you can insert a bar chart into the PPT, fill in the data accurately, set the vertical axis, labels and colors, and know what to check when you are done.
How to make a bar chart in PPT chart? Use column charts to compare categories and conclude in one sentence
Insert the chart in PPT, select the column chart, fill in the categories and values in the data table, and then check whether the chart display is correct and you are done. The table below can help you choose specific methods based on your situation.
| your situation | Recommended practices | reason |
|---|---|---|
| Compare the numerical values of several categories, such as monthly sales of each department | clustered column chart | One column for each category, the height can be seen at a glance |
| Category names are longer, such as full product names or option text | horizontal bar chart | Horizontal arrangement makes text labels easier to read |
| To compare two years or two versions of the same category | Clustered column chart with multiple columns per category side by side | Comparison within the same group is more intuitive, and readers can compare group by group. |
| Depends on the proportion of each part in the whole | Pie chart or percentage stacked column chart | Column charts directly express absolute values and are not suitable for looking at proportions. |
| To see how the value changes continuously over time | Line chart | The broken line can better reflect the continuous trend. |
Before you start: Confirm these points first
1. The data is not a comparison between categories. Column charts are suitable for comparing categories with different names such as "East China, North China, and South China". If the horizontal axis is a continuous day or month, and the focus is on the trend, a line chart would be more appropriate.
2. Are the units and calibers consistent? Whether the amount is expressed in 10,000 yuan or yuan, and whether the statistical range is consistent, must be determined before drawing. When units are mixed, column heights can mislead the reader and be difficult to spot after completion.
3. Number of categories and name length. When there are many categories, the columns will become thinner and the labels will be easily crowded together. When category names are long, horizontal bar charts are usually better to read than vertical column charts.
4. Is the data source reliable? If numbers come from a scanned PDF or paper form, check the original data first. The PDF editor on the desktop client supports OCR on scanned PDFs and can export them to Excel. After exporting, the numbers can be copied into the chart data table, which is less error-prone than manual copying. The recognition results still need to be compared item by item with the original text, especially the decimal point and negative sign.
Steps to make a comparison histogram in PPT
- Insert chart. Select the slide where you want to put the chart, use the insert chart function of PPT, and select column chart in the chart type; if the category name is very long, you can select bar chart.
- Select the clustered style. When comparing only one set of data, a normal column chart will suffice; to compare two or more series, select a clustered column chart to display columns of the same category side by side.
- Fill in the data sheet. In the pop-up data table, fill in the category name in the first column, such as department or product name; fill in the series name in the first row, such as "2024" and "2025".
- Clear sample data. PPT will bring in several lines of sample data by default, and delete or overwrite them all to prevent residual values from being mixed into the chart.
- Check the row and column direction. After closing the data table, check whether the chart is as expected. If the categories and series are reversed, just switch the rows and columns in the chart's data settings.
- Add data labels. Show specific values for the bars so readers can read directly without having to estimate against the vertical axis.
- Set the vertical axis. Set the minimum value of the vertical axis to 0 to avoid exaggerating the gap caused by truncation of the coordinate axis.
- Write a concluding title and legend. Write the conclusion you want readers to see in the title, such as "Sales in East China are higher than those in North China"; place the legend at the top or on the right side, and do not cover the columns.
- Uniform colors. Use one color for one series, a bold color for the column to be emphasized, and light gray for the rest.
Check each item after completion
After the chart is completed, check the following points one by one, especially whether the numbers are completely consistent with the source data.
| Check items | How to see | What to do if there is a problem |
|---|---|---|
| Whether the value is consistent with the source data | Randomly select 3 numbers and compare them one by one with the original list | Return to the data table of the chart to modify it, and the chart will be updated simultaneously. |
| Is the order of categories reasonable? | See if the arrangement on the horizontal axis facilitates comparison, such as arranging values from high to low. | Adjust the order of rows in the data table |
| Whether the starting point of the vertical axis is 0 | Check whether the first tick on the vertical axis is 0 | Modify the minimum value of the coordinate axis to 0 |
| Are labels and legends clear? | Check whether the text overlaps and whether the colors can be distinguished | Shorten category names, use horizontal bars instead, or reduce the number of series |
| Whether the data has been identified or transformed | If numbers come from OCR or machine translated tables, check key figures | Compare it item by item with the original document. Do not use uncertain numbers directly for reporting. |
📊 Core comparison
Bar charts are just one type of chart commonly used in PPT. The comparison below can help you choose between several common charts.
| chart type | suitable for expression | Not suitable for expression | Key points of practice |
|---|---|---|---|
| Column chart (vertical) | Comparison of values across categories | When the category name is very long | Categories are placed on the horizontal axis, values are placed on the vertical axis, and the vertical axis starts from 0 |
| Bar chart (horizontal) | Numerical comparison with many categories and long names | Trends over time | Category indulgence axis, name reading is smoother |
| Line chart | Continuous change of value over time | Category comparison without sequential relationship | The horizontal axis is arranged by time, and there should not be too many data points. |
| pie chart | The proportion of each part in the whole | There are many categories or similar proportions | There should be no more than 5 parts, and the percentages should be marked |
❓ Frequently Asked Questions (FAQ)
1. What is the difference between column chart and bar chart?
The columns of a column chart are arranged vertically, and the columns of a bar chart are arranged horizontally. Both are fine when the category names are short, and the bar chart makes it easier to read the labels when the category names are longer or when there are many categories.
2. What should I do if the pillars are too thin or the labels are crowded together?
Reduce the number of categories to just the few you need to compare; or use a horizontal bar chart instead. You can also adjust the spacing between columns in the chart settings to make the columns wider.
3. I only changed the numbers in the table, but the chart did not change. Why?
Please make sure you are editing the data table that comes with the chart. If the chart is pasted into PPT as an image, it will not change with the data and the chart will need to be re-inserted.
4. Can the histogram directly represent the proportion?
Histograms directly express numerical values and are not good at expressing proportions. To express proportions, you can use a pie chart or a percentage stacked column chart.
5. How to turn the table in the scanned document into chart data?
First perform OCR recognition on the scanned PDF, then export it to Excel, and copy the required numbers from the table to the data table of the PPT chart. The recognized numbers should be checked against the original document to ensure that there are no errors in decimal points and positive and negative signs.
📝 Summary
The key to making a bar chart is to first choose the right chart type, then straighten out the data and units, and finally use data labels, a vertical axis with a starting point of 0, and a conclusion-style title to make the comparison relationship clear at a glance. By following the steps and checklist above, the problem of how to make a bar chart in a ppt chart can be solved in one production.
