Home > Topics > excel > body text

What should I do if the abscissa text in an excel chart is too long?

coldplay.xixi
Release: 2020-07-13 15:42:52
Original
14592 people have browsed it

The solution to the problem that the abscissa text of excel chart is too long: first open the required table and select the column in the table; then manually modify the second parameter in the formula to the required abbreviation; finally After changing the formula, just press Enter.

What should I do if the abscissa text in an excel chart is too long?

Solution to the problem that the abscissa text of excel chart is too long:

1. Select the column in the chart. A formula will be displayed in the edit bar (=SERIES(Sheet5!$B$1,Sheet5!$A$2:$A$5,Sheet5!$B$2:$B$5,1))

二, Manually modify the second parameter in the formula to the abbreviation you want, but be sure to note that the abbreviation must be enclosed in double quotes "", and use external curly brackets {} (=SERIES(Sheet5!$B$1,{ "Guangda", "Feilong", "Feifei", "Three Granules"},Sheet5!$B$2:$B$5,1)), after changing the formula, press Enter to complete the modification

What should I do if the abscissa text in an excel chart is too long?

What should I do if the abscissa text in an excel chart is too long?

Related learning recommendations: excel basic tutorial

The above is the detailed content of What should I do if the abscissa text in an excel chart is too long?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template