Forum Discussion
Formatting lables in a chart
Hi, all I want to show the series name inside the pivot diagram lables instead of the default "value". How do I set that for all lables? I can do it for an individual lable, but in my attached file ...
On a Mac myself. Select the label. Right-click "Format Data Labels..." and a screen similar to the one below should open on a PC as well. There you can choose which elements the Label should contain.
Trevlig helg!
Hi Riny_van_Eekelen
Thanx for the answer. That solution I found for the individual labels. But I need to open every single label to fix that in the whole chart. Thats not "do-able" as the result changes over time.
How to "select all" labels and do the same thing? I´ve got no success so far...
/TorbjörnGoogle "tells" me that on Windows you can clone Label options. Might work for you. Doesn't exist on Mac, though.
- Yes, I also saw that, but I can´t figure out HOW. I just don´t find the option "Data Label Series" on my installation of Office365.
