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?