Forum Discussion

jheuer's avatar
jheuer
Copper Contributor
Aug 21, 2019

Problems formatting pivot chart data labels in Mac v16

When I try to reformat the data labels in a pivot chart in Excel for Mac v16.28, only a single label, or sometimes a single series of labels, gets reformatted. Examples of reformatting I'd like to do:

  • Changing text color
  • Selecting different content for the label itself, such as including Series Name and/or Value

 

I've tried a couple of different methods of selecting data labels:

  • Clicking a single data label. All the Excel documentation suggests that selecting a single data label should select ALL data labels; only a second click will select just that single label
  • With the pivot chart selected, on the ribbon choose Add Chart Element > Data Labels > More Data Label Options

Both methods result in a single label or series of labels being selected, instead of all data labels being selected. And there's not even a way of shift-selecting to get other labels included. Screenshot:

 

No RepliesBe the first to reply

Resources