I have a spreadsheet that lists 575 departments with monthly totals for each
department. I need to create individual charts for each department that show
the monthly totals. I was able to create a dropdown list where I can pick
the department but I can't figure out how to correlate the correct row of
data to that department when I change it.

Example:

Dept Jan Feb Mar Apr May, etc.
500 x x x x x
501 x x x x x
502 x x x x x
503 x x x x x
504 x x x x x
etc.

I need to be able to have one chart, then a dropdown (or some selection)
that I can use to pick which department I want to chart, and upon making that
selection - the chart data changes to reflect the correct numbers for that
particular department. Any help would be greatly appreciated.