StationX
Start free

Browse › Excel Expert Productivity

Create and Modify Advanced Chart Types

Guided

Part of Excel Expert Productivity Topic: Essential IT

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this lab, you will record and edit macros to enable dynamic capabilities in a workbook.

  1. Create a chart that displays data on the left vertical axis and on the right vertical axis
  2. Use a function to convert the numeric grades to letter grades
  3. Select the Student Grades worksheet
  4. Create a chart that shows the distribution of letter grades
  5. Create a more complex chart