Library Workshops

Excel Intermediate - Learning Objective #7:

Creating detailed graphs and charts:

Skills and concepts covered:

• Intermediate Chart Tools
• Intermediate Chart Design

Activities:

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

For more advanced Excel Skills (such as Pivot Tables and VLOOKUP) please refer to: 

• LinkedIn Learning (free through the Toronto Public Library)
• Coursera: https://www.coursera.org/learn/excel-data-analysis (free Excel Course)
• Excel Resources (600+ Self Study Guides and Resources) (WallStreetMojo)
• Analysis ToolPak in Excel (WallStreetMojo)