Home

Problems formatting pivot chart data labels in Mac v16

%3CLINGO-SUB%20id%3D%22lingo-sub-814149%22%20slang%3D%22en-US%22%3EProblems%20formatting%20pivot%20chart%20data%20labels%20in%20Mac%20v16%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814149%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20reformat%20the%20data%20labels%20in%20a%20pivot%20chart%20in%20Excel%20for%20Mac%20v16.28%2C%20only%20a%20single%20label%2C%20or%20sometimes%20a%20single%20series%20of%20labels%2C%20gets%20reformatted.%20Examples%20of%20reformatting%20I'd%20like%20to%20do%3A%3C%2FP%3E%3CUL%3E%3CLI%3EChanging%20text%20color%3C%2FLI%3E%3CLI%3ESelecting%20different%20content%20for%20the%20label%20itself%2C%20such%20as%20including%20Series%20Name%20and%2For%20Value%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20a%20couple%20of%20different%20methods%20of%20selecting%20data%20labels%3A%3C%2FP%3E%3CUL%3E%3CLI%3EClicking%20a%20single%20data%20label.%20All%20the%20Excel%20documentation%20suggests%20that%20selecting%20a%20single%20data%20label%20should%20select%20ALL%20data%20labels%3B%20only%20a%20second%20click%20will%20select%20just%20that%20single%20label%3C%2FLI%3E%3CLI%3EWith%20the%20pivot%20chart%20selected%2C%20on%20the%20ribbon%20choose%20Add%20Chart%20Element%20%26gt%3B%20Data%20Labels%20%26gt%3B%20More%20Data%20Label%20Options%3C%2FLI%3E%3C%2FUL%3E%3CP%3EBoth%20methods%20result%20in%20a%20single%20label%20or%20series%20of%20labels%20being%20selected%2C%20instead%20of%20all%20data%20labels%20being%20selected.%20And%20there's%20not%20even%20a%20way%20of%20shift-selecting%20to%20get%20other%20labels%20included.%20Screenshot%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20901px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127731iAB92DD598F6F6ECA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Image%202019-08-20%20at%208.19.25%20PM.png%22%20title%3D%22Image%202019-08-20%20at%208.19.25%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-814149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jheuer
Occasional Visitor

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:

 

Image 2019-08-20 at 8.19.25 PM.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies