Forum Discussion
Formatting lables in a chart
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
Google "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.
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.