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.
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
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!