Make graph appear when clicking on picture?!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
_______
 
Back
Top