OmniDocExcel chart production specifications: title, axis and data labeling requirements
It organizes the general specifications for title, axis, unit, data labeling and color matching of report-type Excel charts, and provides judgment basis and checklist to help you make charts that readers can understand and can be directly included in reports.
Key points of this article
- The title of the chart should indicate the indicator, time range and data caliber. Only a title such as "Sales Status" should be written so that readers cannot determine what is in the chart.
- Each axis must have an axis title, and the value unit is written in the axis title; the value axis of a bar chart usually starts from zero.
- Data annotation only retains key values that need to be compared, and the numerical accuracy in the same picture remains consistent.
- The same indicator uses the same color in all charts throughout the report, and is accompanied by the chart number and data source.
- Use a checklist to check items one by one before delivery. It is less likely to miss items than adjusting by feel.
When doing weekly reports, paper illustrations, or business analysis, many people paste the Excel charts directly into the document after finishing them. As a result, it takes a long time for readers to understand what the coordinates represent and what caliber the numbers are. The value of a chart is to let people read the conclusion at a glance. If the title is vague, the axes have no units, and the colors change randomly, no matter how beautiful it is, it may be misunderstood by readers.
This article discusses the presentation specifications for reporting Excel charts: how to write titles, how to label axes, how much data to label, and how to unify colors. It is not a step-by-step tutorial, nor is it a collection of beautification techniques, but an answer to "what is the standard?" The following content is a general practice and is applicable to most office and academic scenarios. Specific requirements should also be based on the template of your institution or journal.
How to determine chart specifications? One sentence conclusion
The specifications of report charts can be boiled down to three things: let the title tell what to read, let the axis tell what the quantity is, and let labels and colors only serve for comparison. Recommended practices are given below based on common scenarios.
| your situation | Recommended practices | reason |
|---|---|---|
| Weekly business report for management | Write the conclusion in the title, such as "Income in East China grew quarter-on-quarter in the third quarter", and the subtitle indicates the time and caliber. | Management should read the conclusion first and write it clearly to avoid misunderstandings. |
| Illustrations for papers or technical reports | The title briefly describes the content, the legend is placed below the figure, and the figure numbers are arranged consecutively. | Figure numbers can be cited in the text, and the figure annotations provide additional explanations. |
| Chart has multiple series | The legend is placed in a prominent position, and the same indicator has the same color in all charts. | Inconsistent colors can cause readers to mistake them for different indicators. |
| Data with widely varying values | Only key values are marked, the rest rely on grid lines and scales to read | Marking every point will make the picture crowded and the key points will be submerged. |
| Charts that need to be used repeatedly | Fix the unit, font size, and color matching into a template, and then only replace the data | Unified templates can reduce omissions every time you rework |
How to write the title, axis and unit
Title: What to write and read clearly
The chart title should answer three questions: what indicator is being looked at, what time range it covers, and what the data caliber is. If you only write "sales situation", readers will not be able to judge; if you write "sales in each region in the third quarter of 2024 (10,000 yuan, including tax)", the information will be complete.
If you want to highlight the conclusion, you can put the conclusion in the title, and put the indicators and caliber in the subtitle or legend. Both writing methods are acceptable, the key is to maintain consistency within the same report.
Axis: name and unit are essential
Each coordinate axis should have an axis title to explain what it represents; the value axis should have units, such as "10,000 yuan", "%", and "milliseconds". The timeline should indicate the granularity, whether it is by day, week, or month. Units are only written on the scale numbers and not in the axis titles, which are often missed by readers.
The starting point of the value axis must match the graph type. The height of a bar graph directly represents the quantity and should usually start from zero, otherwise the proportion of the length of the bar will be exaggerated. The line chart mainly looks at the change trend. The starting point does not need to start from zero, but if the scale is cut off, it should be visible on the chart so that readers can avoid turning the wavelets into large fluctuations.
Data annotation: only keep the values that need to be compared
The purpose of data annotation is to allow readers to quickly read key figures. A common practice is to label only the highs, lows, target values, or numbers mentioned in the text, and leave the rest to the grid lines. If each column is hung with three decimal places, the picture will be very crowded and readers will not be able to grasp the key points.
Numeric precision should also be uniform. In the same picture, the percentage is kept to one decimal place, and the amount is unified to ten thousand yuan with the same number of digits, so that readers do not have to convert repeatedly.
Color: The same indicator remains consistent
Color is an easily overlooked norm. If the same indicator is used in different colors in different charts, readers will mistakenly think it is another indicator. It is recommended to fix one color for each major series and carry it through all related charts. Series that need to be compared, such as "actual" and "target", can be distinguished by dark and light or solid or dotted lines, and avoid distinguishing only by red and green to take care of readers with different color vision.
Common misunderstandings
Many people think that "complex pictures are professional." In fact, standardized charts are usually simpler: one less layer of decoration, one less irrelevant legend, one less color, and are often easier to read than the stacked effect. Another misunderstanding is that the more annotations, the clearer it is. Too many annotations will conceal the trend.
📊 Core comparison
Put common practices and frequently asked questions together for easy comparison and self-examination:
| chart elements | Standardized practices | FAQ |
|---|---|---|
| title | State the indicators, time, and caliber | Just write "overview" and "trends" |
| axis | There is an axis title, and the units are clearly written. | Unit is missing or only stated in a footnote |
| Value axis starting point | Histogram starts from zero | Truncate starting point, exaggerate differences |
| Data annotation | Only key values are marked, with uniform accuracy | Every point is marked and the decimal places are confused. |
| color | The full text of the same indicator is consistent | Change colors in different pictures of the same series |
| Captions and sources | With figure number, source and necessary instructions | No source, text and pictures do not match |
How to use it in practice
If the chart data comes from PDF reports or English materials, you can organize the original content first and then redo the chart according to the specifications. The following methods can be directly completed by OmniDoc:
- Upload the PDF, Word or Excel file to be processed on omnidoc.top, select bilingual comparison or translation only, and download the results.
- Check whether the chart title, axis name and legend in the translation are consistent with the original text. Professional terms and numbers need to be checked manually, and machine translation will inevitably be biased.
- If the original table only exists in PDF, you can use the PDF editor of the OmniDoc desktop client to export it to Excel, and then organize the data in Excel.
- Redo the chart in Excel according to the previous checklist: complete the title and caliber, add axis titles and units, and unify colors and number precision.
- Add the figure number and data source below the figure, use the figure number to reference in the text, and check the checklist item by item before delivery.
❓ Frequently Asked Questions (FAQ)
1. Does the title of the chart have to be written as a conclusion?
uncertain. Business weekly reports are usually suitable for conclusion-type titles, while papers and technical reports are more suitable for descriptive titles, such as "Figure 3 Response time distribution of each group". No matter what kind, the indicators and caliber must be clearly stated.
2. Can the value axis of the line chart not start from zero?
Yes, line charts are mainly used to observe changing trends. However, if the scale is truncated, it should be visible to the reader and avoid using a narrow scale range to amplify small fluctuations.
3. What should I do if there are too many data annotations and the graph is messy?
Prioritize deleting the annotations that do not participate in the comparison, and only retain the high points, low points, target values and numbers mentioned in the text. The remaining values can be supplemented with the help of grid lines and tables, and the complete data can be given in the text or appendix.
4. There are only original English charts, how to check after translation?
Check the title, axis name, legend and unit item by item to confirm that the translation and the original text point to the same indicator. Numbers, units and technical terms should be manually reviewed against the original table, and do not directly trust the results of machine translation.
5. Is there a unified standard for chart colors?
There is no standard color that applies to all scenarios. The general principle is: the entire text of the same indicator should be in the same color, and contrasting series should use clearly distinguishable shades or line types. Do not rely solely on red and green distinctions, and pay attention to still being able to identify them when printing in black and white.
📝 Summary
The specifications of report charts mainly fall into four aspects: title, axis, data labeling and color. The core is to allow readers to understand the chart without guessing. Fixing the above checklist into a template and checking it one by one before each delivery can reduce rework and allow the charts to truly play their role in the report.
