Excel chart changing all data labels from value to series name simultaneously
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.
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?
Answer
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.