| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered Data into Charts
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtered Data into Charts
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 JDB wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Does Excel support Auto fill on filtered data? | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| conditional format of data tables in charts | Charts and Charting in Excel | |||
Linear Mode
