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 I want to see the "car type" instead of the "quantity" value.
/Tobbe
5 Replies
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.
