I have a personnel resourcing workbook that is used by a number of different departments.
Each department is only interested in their own view of the data. Only a couple of senior managers care about global views of the data.
I have created a chart linked to a cell with a List data validation...