Hessel de Walle's Blog

The question is how can somebody just pick the graph he/she wants to see without seeing the other graphs? Nice to have for your Excel dashboard. Something like this: How did I do this? I created one sheet called graphs with three different graphs. Then I created three names One , Two and Three referring to a range containing the graphs One , Two and Three respectively. Like this: one = graphs!$G$1:$O$16 two = graphs!$G$17:$O$33 three = graphs!$G$33:$O$48 On a second sheet called whichgraphtoshow  in cell A2 I then created a picking list containing one , two and three . Yet another name refers to this cell: graphLookup =INDIRECT(whichgraphtoshow!$A$2) On the same sheet I then inserted a picture. The picture refers to the name graphLookup .  And it is all working! You can download  ExcelWhichGraphToShow.xlsx  via: https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing