Making 1 chart (where you can select the specific variable) instead of having lots of grap

[ACrossley1]

Hi,

I have a a data set where there are 8 variables with 50 different people's data.

I want to produce a column graph which will indicate whether there has been an increase from year one.

However, I dont want to produce 50 individual graphs (one per person). What I want is ONE graph where I can select a specific person's data I want to look and their data will come up automatically when I select the name.

How is this possible?

Thanks.

[Olly]

Base your chart on a range which contains a lookup reference to your main data, based on the value of a 'name' cell (which may be controlled using data validation, or a listbox).

Easier to give specific advice if you attach a workbook.