Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
You have the following chart, and want to see what it looks like changing the Actual series to use a line instead of a column. How would you do this?
Right click one of the blue columns ⇒ Change Series Chart Type, and change it to a Line chart
Right click one of the blue columns ⇒ Change Series Chart Type, and change it to an Area chart
Delete the chart, re-create it as a line chart, then right click the Budget line ⇒ Change Series Chart Type and change it to a Column chart
Don’t know
2
Intermediate
What was added to this combination chart in order to make it easier to identify the value represented by the Actual series for each month?
A Legend
Data Labels
Markers
Don’t know
3
Intermediate
Of the options given, what is the most efficient way to create this chart?
Create a line chart, right click any series, choose Change Series Chart Type and set the Budget and Prior Yr series to be Clustered Column charts
Create a column chart, right click any series, choose Change Series Chart Type and set Actual to a Line chart
Create a line chart, right click any series, choose Change Series Chart Type and set the Budget and Prior Yr series to use Stacked Bar charts
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement