Data labels on secondary axis position

%3CLINGO-SUB%20id%3D%22lingo-sub-2747225%22%20slang%3D%22en-US%22%3EData%20labels%20on%20secondary%20axis%20position%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2747225%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20wondering%20if%20there%20is%20a%20workaround%20(Mac)...%20When%20I%20make%20a%20horizontal%20bar%20graph%20with%20primary%20and%20secondary%20axes%2C%20I%20do%20not%20have%20a%20choice%20for%20label%20position%20to%20be%20%22Outside%20End.%22%20Bars%20on%20the%20primary%20axis%20are%20stacked.%20But%20secondary%20axis%20bars%20are%20Clustered%20-%20Since%20the%20secondary%20axis%20is%20not%20stacked%2C%20why%20can't%20the%20labels%20be%20on%20the%20outside%20end%3F%3C%2FP%3E%3CP%3EIf%20I%20make%20a%20Column%20Graph%2C%20I%20am%20able%20to%20choose%20Outside%20End%20for%20the%20secondary%20axis%20(when%20the%20primary%20axis%20is%20stacked).%3C%2FP%3E%3CP%3EI%20can't%20figure%20out%20how%20to%20beat%20this%20with%20VBA%20code%20either.%20Help!%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E-Ashley%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2747225%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I am wondering if there is a workaround (Mac)... When I make a horizontal bar graph with primary and secondary axes, I do not have a choice for label position to be "Outside End." Bars on the primary axis are stacked. But secondary axis bars are Clustered - Since the secondary axis is not stacked, why can't the labels be on the outside end?

If I make a Column Graph, I am able to choose Outside End for the secondary axis (when the primary axis is stacked).

I can't figure out how to beat this with VBA code either. Help!

Thanks,

-Ashley

0 Replies