Latest Lists

is it possible that vlookup in Excel will display a graph after clicking on a name in a drop down list?

i am creating a system and need to display a graph after clicking on a certain name in drop down list. could i use VLOOKUP to do this?

Public Comments

1. Not really. Vlookup can find the values for a chart, but not the chart itself. You could use some simple VBA to get the required chart in the same one that the tutorial below shows for finding the required picture. http://www.computergaga.com/blog/2011/11/lookup-a-picture-in-excel/ Or maybe a scenario similar to below where form controls are used to change chart data. http://youtu.be/5ElgimfYXKo