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,
Section B has 14 staff, B1, B2.....B14
Section C has 21 staff, C1......C21
Section Staff number hours worked
A A1 5
B B1 1
C C1 6
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?