Create customized chart (in ClientDept worksheet):
Insert tab → charts section → insert column or bar graph → 3D Column
Chart tools → design tab → select data → Legend Entries → series values → Add chart data range: highlight cells C18:C20 (series 1) → click OK → Under horizontal axis select "edit" → highlight cells: C22:C24 (horizontal axis labels) → OK
Chart Tools → design tab → add chart element → Chart title → Above Chart → Clients Served Per Department
Chart Tools → design tab → add chart element → Axis titles → Primary horizontal axis titles → Number of Employees
Chart Tools → design tab → add chart element → Axis titles → Primary vertical axis title → Number of Clients Served
Double click on first cylinder → Right click for options → Change fill colour of cylinder to purple (or any other colour)
Double click on second cylinder → Right click for options → Change fill colour of cylinder to green (or any other colour)
Double click on third cylinder → Right click for options → Change fill colour of cylinder to orange (or any other colour)
Chart Tools → Format tab → insert shapes → Text box → insert 3 boxes for department names (ICU, ER, OR) → move to centre of cylinders → right click to bold text
Excel Advanced - Recommended Courses
For more advanced Excel Skills (such as Pivot Tables and VLOOKUP) please refer to:
LinkedIn Learning (free through the Toronto Public Library)
