We help IT Professionals succeed at work.

looking up a chart from a data validation dropdown

wkraft used Ask the Experts™
The dropdown recognizes the named cells, which are in the column left of a series of charts.  I used Name Manager to create an "indirect" formula, which correctly identifies the cells.  I need the charts to change as the dropdown is changed.  When I paste a picture and try to use the "indirect" formula, I get an error (or am not allowed to type in the formula bar at all).
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

see attached file. I used a helper range name "display". This range name has the Indirect() formula. The dynamic image is populated by =display

You can't use Indirect in a dynamic image.

cheers, teylyn