Forum Discussion
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
- NikolinoDEPlatinum Contributor
Change the format of data labels in a chart
Edit titles or data labels in a chart
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Christin800Copper Contributor
NikolinoDEthank you for your quick reply!
The linked articles helped a lot to find the mistake.
Kind regards,
Christin