| DAL4 A1.2 |
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.
A world-leading tech and digital skills organization, 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 programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.