Dynamic Pictures as Data Labels in Excel Graph from Pivot Table/Slicer

%3CLINGO-SUB%20id%3D%22lingo-sub-1623235%22%20slang%3D%22en-US%22%3EDynamic%20Pictures%20as%20Data%20Labels%20in%20Excel%20Graph%20from%20Pivot%20Table%2FSlicer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623235%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI'm%20trying%20to%20create%20a%20dynamic%20graphs%20based%20on%20a%20pivot%20table%20where%20slicers%20will%20be%20used.%20I'm%20trying%20to%20figure%20out%20a%20way%20for%20the%20data%20labels%20to%20be%20the%20relevant%20company's%20logo%20based%20on%20the%20slicer%20selections.%20I've%20figured%20out%20a%20way%20to%20have%20the%20labels%20show%20as%20dynamic%20to%20a%20cell%2C%20but%20when%20I%20select%20those%20cells%20as%20the%20data%20label%20range%2C%20they%20come%20back%20as%20blank.%20I%20know%20you%20can%20make%20a%20picture%20a%20specific%20data%20label%2C%20but%20it%20does%20not%20hold%20when%20the%20slicer%20is%20used.%20Anyway%20to%20do%20this%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1623235%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I'm trying to create a dynamic graphs based on a pivot table where slicers will be used. I'm trying to figure out a way for the data labels to be the relevant company's logo based on the slicer selections. I've figured out a way to have the labels show as dynamic to a cell, but when I select those cells as the data label range, they come back as blank. I know you can make a picture a specific data label, but it does not hold when the slicer is used. Anyway to do this?

0 Replies