Help, I know that this may be simple but I am a novice at using Excel and am

having trouble with charts.

I want a chart to automatically update some values based upon which section

I select from a drop down list of some sorts.

I have three sections of people, Section A has 21 staff, section B has 14

Staff and section C has 21 staff, set out as follows:

Section A has 21 staff, each one anonymous and labelled i.e A1, A2, A3,

A4.........A21

Section B has 14 staff, B1, B2.....B14

Section C has 21 staff, C1......C21

Like below:

Section Staff number hours worked

A A1 5

A2 4

A3 7

B B1 1

B2 8

B3 10

C C1 6

C2 4

I want to create a chart where I can select the section letter(A, B or C)

from a drop down menu of some sort and the chart will automatically update

with the staff numbers along the X Axis and the hours worked will be

displayed in the values section. Can anyone help me with how to do this?

Thanks

Paul