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

schmitkl

New Member
Joined
Feb 13, 2019
Messages
5
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?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Watch MrExcel Video

Forum statistics

Threads
1,114,240
Messages
5,546,683
Members
410,754
Latest member
IainClover
Top