Filtered Data into Charts

[Guest]

Hi,

I have a sheet of data that grows daily. Essentially it's a list of team
members, their teams and score in a particular area. My boss wants to see the
data graphically reproduced by team with the individual team members on each
graph. Is this possible. I've tried several things but can't seem to suss it!

The sheet is currently set up with team data in columns and the scores going
across the rows.

 

[Debra Dalgleish]

You could follow Jon Peltier's instructions to create a dynamic chart:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

Then filter the data by team, using an AutoFilter:

http://www.contextures.com/xlautofilter01.html

to see only the results for that team in the chart