Excel图表同时将所有数据标签从值更改为系列名称 [英] Excel chart changing all data labels from value to series name simultaneously

问题描述

我在excel堆叠柱状图中遇到这个问题，同时尝试更改标签。

I am having this problem in excel stacked column chart while trying to change the labels. My graph has multiple columns and hundreds of stacked values (series) in each column.

通过选择图表，然后从布局 - >数据标签 - >更多数据标签选项 - >更多数据标签 - 标签选项 - >标签contains->（选择）系列名称，我只能得到一个系列名称替换其各自的标签值。对于堆积在列中的100多个系列我想要他们一次改变，有没有出路？为什么它不会立刻改变它们？

By selecting chart then from layout->data labels->more data labels options ->label options ->label contains-> (select)series name, I can only get one series name replacing its respective label values. For more than hundred series stacked in columns i want them all to be changed at once, is there any way out? why it does not change them all at once?

推荐答案

我知道这是老，但我想发布我想出的。我在枢轴表图表中有同样的问题。我无法一次更改所有标签。我做的是从图表中删除所有的系列。然后，我能够选择系列数据标签，并更改所有的标签。之后，我简单地添加了系列回来，它填充了所有的数据标签的系列信息。

I know this is old but I wanted to post what I figured out. I was having the same problem in the pivot table chart. I was unable to change ALL of the labels at once. What I did was remove the series from the chart all together. I then was able to select the "series" data label and have it change all the labels. After I did that I simply added the series back in and it populated all of my data labels with the "series" information.

这篇关于Excel图表同时将所有数据标签从值更改为系列名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！