Make graph appear when clicking on picture?!

[Ed (from UK and useless with comuters!)]

Hi,

I'd like to either click on a persons name in a cell, or a picture
alongside, in order to make a graph appear in excel. This is because I have
90 people in a score chart of 12 categories and would like to view their
individual perofmances withough having to have 90 extra chart sheets
permanently on view!

Any help would be very very gratefully recieved!

Cheers,

Ed

 

[bj]

check out hyperlinks in Help

I hink they will do what you want

 

[Jon Peltier]

You could make one chart with everyone's data (with names in a column
and each category score in another column). Set up an AutoFilter using
this range, and use the filter on the Name column to display the name
you want to see. By default, Excel doesn't plot hidden data, so only the
visible series remains in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______