Jan 10 2020 12:33 AM
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
Jan 10 2020 04:02 AM - edited Jan 10 2020 04:03 AM
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!
Jan 10 2020 04:19 AM
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örn
Jan 10 2020 05:00 AM
Google "tells" me that on Windows you can clone Label options. Might work for you. Doesn't exist on Mac, though.
Jan 10 2020 05:06 AM
Jan 10 2020 06:55 AM
Figured out (even on a Mac) how the Cloning works. It works within Data Series when you have more than one data point in the series. Then you can format the label for the first point and then press "Clone" to copy to the other data points in the same Series. When I select a Data Series and press on Format Labels, all data points are selected and can be formatted in one go. Thus, I'm not sure what added value the Clone button has here. Would be nice if it would copy the selected format to all other Data Series. Perhaps someone someone else out here can elaborate.
In your chart, every single car is a data series of it own with one data point Therefore, you don't see the Clone button.