Forum Discussion
TobbeStenberg
Jan 10, 2020Copper Contributor
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 ...
TobbeStenberg
Jan 10, 2020Copper Contributor
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.
Riny_van_Eekelen
Jan 10, 2020Platinum Contributor
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.