Dynamic Chart Data Selection

[NeoPhyx]

Hi,

I'm am tasked with creating a graph of staff performance over a period of time (so that progress can be measured). The problem is that the number of staff is over 255. In fact, it closes in on 1000 staff members. What I need (I think) is a dynamic chart which only shows 1 staff member at a time, via some means of range selection method. Now the people using the sheet will not be excel saavy and won't be able to figure out a range to type in. Thus, I was thinking selecting the name of the employee would cause his data to be charted instantaneously as a line chart. Selecting another name refreshes the chart, etc. etc. Is this possible? Is there a better way of which I have not conceived?

Many Thanks,

Neo

[Magriza]

Hi,

There are a number of ways in which you could choose to display the name one at a time. It might be best to use a userform with a combobox so that, with so many names, the user might be able to start typing a name or letter to get to thet correct employee.

For the graph itself you only need to chart 1 set of data and then update the data (and not the chart) but using VLOOKUP or INDEX/MATCH or OFFSET

If you can post a sample of your data then we might get a better idea of how to provide specific help.

[pb71]

A pivot chart perhaps? See attached example with the employee's name as the column label (as you are using Excel 2007 you won't have the 256 columns constraint).