1. Home
  2. Training Library
  3. Additional Resource Videos

New Charts Styles

Developed with
QA
Start course
Overview
Difficulty
Beginner
Duration
33m
Students
229
Ratings
4.7/5
starstarstarstarstar-half
Description

Additional information

Transcript

- [Instructor] There are multiple ways to change a chart style. Each column here has an individual color. I can select change color to select a different style, and you can see how that's affected the charts below. I can also try a monochromatic version of colors for a more subtle shading effect. I'll go back to standard colors. We can also use a series of pre-loaded chart styles to very quickly format the chart in a particular layout style. So here, I can click onto one of my styles, see the results and if I don't like it, I can pick a different style, and keep trying until I find something suitable. At present, the chart is laid out as follows: the sales for each vehicle are denoted by the district of north, south, east and west. However, if I click the switch row/column command, you'll see that I'm now displaying each district, north, south, east and west, with each vehicle represented as a different color. As this chart is still rather small on the spreadsheet, we can move this chart so that it will display in a larger environment on its own sheet. To do this, click the move chart command, select new sheet, rename the sheet to something appropriate, and then hit okay. To move the chart to another sheet, you can again click move chart, place it as an object within an existing sheet, and again, click okay to move it back.

About the Author
Avatar
QA
Training Provider
Students
8839
Labs
31
Courses
54
Learning Paths
33

QA: A world-leading tech and digital skills organisation

We help many of the world’s leading companies to build their tech and digital capabilities via our range of world class training courses, reskilling bootcamps, work-based learning programmes and Apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.