I'm trying to control the display of a chart (whether the whole chart is visible or not) using a checkbox form control. I've tried to do this using a named range and an indirect function in the formula:
=if($B$3=TRUE, Indirect(named_range),NA())
the chart occupies a whole expanded cell in another worksheet. I import a random picture where the chart is to be displayed under the checkbox, and when I try and assign a named range to this picture I get the message - 'Invalid cell reference'. I can forward the workbook on request.
Bookmarks