Forum Discussion

Christin800's avatar
Christin800
Copper Contributor
Jan 15, 2021

Excel Pivot Chart Formatting

Hello everyone,

does anyone know, whether it's possible to format the data labels in Excel Pivot Charts uniformly to a different type at once? When I right-click at the (Pivot) bar chart and select "including/inserting data labels", all bars get data labels. However, when I want to change the type of label (e.g. value, title, etc.), not all bars get formated, but only one bar. Is there a quick solution that I can permanently change the type (from value to data row name) of all data labels? Maybe also for all data labels from data that will be added in the future? A "global" setting for this spreadsheet?

Thanks in advance for any hint!

2 Replies

Resources