Hi,
I am working on an excel spreadsheet as per attached to represent a sales dashboard for the company. So far I have managed to get the dashboard completed for the Company (first Tab) which represent various charts with zone criteria represented by coloured icons (>85 - green, 75-85 - yellow & <75 - red). However, I am struggling with the Individual Dashboard (second tab) which should work with the drop down list comprised of various sales agents which when selected should change the graph automatically to represent their work for the month and quarter along with the colour coding criteria in the zone section.
If someone can help me get this straight would be highly appreciated.
Regards, Sam
Bookmarks