From the course: Excel 2019 for Mac Essential Training “ - [Instructor] One of the great things about creating charts in Excel is that you can summarize many data sets using more than one type of chart. If the first type of chart you select doesn't work, you can try another. If all you want to do is change the chart's layout, such as by moving and removing the title, or perhaps, changing a background color, you can select from one of several premade layouts to do so. I'll demonstrate
these techniques in this movie. My sample file is the ChartLayout workbook, and you can find it in the Chapter 7 folder of the Exercise Files collection. The Column Chart I have on the right side of the screen, this summarizes sales data, or order counts, for four different categories across three different years, and each of the years is represented by a separate color. Lets say that I want to make my chart narrower, and that means that I want to have all three of the years in a single column
for each of the categories. I can change the chart type by clicking the chart, so it's selected, and then on the Chart Design Contextual tab, I can click the Change Chart Type button, and select a new chart. In this case, I want a Stacked Column chart, so I will point to Column, and then the second item on the top row is Stacked Column, so I'll click that, and my Chart Type has changed. It contains all of the data that I had before, but now you see it's not quite as spread out, and if I wanted,
I could make it narrower. Now if I want to change the charts layout, and that is different from the charts formatting, I can click the chart, go to the Chart Design Contextual tab on the ribbon, and then click the Quick Layout button. It's at the almost the far left edge of the Ribbon tab. In here, I see a number of different layouts. So lets say that I want to have the legend at the right, so I'll click the one here on the top left, I still have my title, that's Layout 1, I'll click it, and ya
see that I now have my stacked values, again, each year is a different color, and the categories along the bottom, and the legend has been moved to the right, and of course, you can drag or delete individual elements as well. For example, if I wanted to get rid of the title, I could select it, press the Delete key, and it's gone. After you create a chart, you can change everything about it, including its layout or even its type. Keep trying combinations of Chart Type and Layout until you find
the one you like.
Change chart types and layouts
Contents
-
Introduction to Excel 2019 for Mac
29s
-
What you should know
1m 11s
-
-
What can you do with Excel 2019?
2m 37s
-
Explore the Excel 2019 program window
3m 42s
-
Introduce the ribbon
3m 20s
-
Set program preferences
4m 12s
-
-
Open, create, and save workbooks
2m 49s
-
Set workbook properties
3m 52s
-
Create and modify templates
3m 33s
-
-
Select cells and groups of cells
4m 36s
-
Copy and paste cell data
4m 17s
-
Enter data using AutoFill and other techniques
6m 28s
-
Insert symbols and special characters
3m 38s
-
Create named ranges
4m 41s
-
Create an Excel table
4m 56s
-
Locate and change data using Find and Replace
4m 45s
-
Guide cell input using validation rules
5m 34s
-
-
Sort worksheet data
3m 23s
-
Create a custom sort order
5m 29s
-
Filter worksheet data
4m 13s
-
Insert, move, and delete cells and cell ranges
4m 7s
-
Split worksheets and freeze rows and columns
5m 20s
-
Create, edit, and delete headers and footers
3m 35s
-
-
Introduce Excel formulas, functions, and operators
2m 58s
-
Add a formula to a cell
4m 56s
-
Use relative and absolute cell references
4m 16s
-
Control how Excel copies and pastes formulas
3m 53s
-
Refer to Excel table data in formulas
3m 14s
-
Create an AutoSum formula
3m 34s
-
Summarize data on the status bar
2m 42s
-
Summarize data using IF and related functions, part 1
2m 31s
-
Summarize data using IF and related functions, part 2
6m 9s
-
Identify precedents and dependents
3m 9s
-
Manage Excel formula error indicators
4m 40s
-
-
Apply fonts, background colors, and borders
4m 38s
-
Apply number and date formats to cells
4m 13s
-
Manage text alignment
5m 29s
-
Manage cell styles
4m 31s
-
Manage Office themes
3m 14s
-
Create rule-based conditional formats
4m 18s
-
Define top ten conditional formats
3m 29s
-
Define data bar, color scale, and icon set conditional formats
6m 8s
-
Manage conditional formats
3m 41s
-
-
Create bar and column charts
3m 20s
-
Create line charts
2m 56s
-
Create XY (scatter) charts
2m 8s
-
Change chart types and layouts
2m 33s
-
Format chart elements
3m 58s
-
Manage chart axes and numbering
5m 35s
-
Create sparkline charts
5m 11s
-
Create funnel, waterfall, and map charts
5m
-
-
Import data from a comma-separated value (CSV) or text files
3m 43s
-
Create and format shapes
4m 26s
-
Add and adjust images
4m 59s
-
Add and format text boxes
4m 2s
-
Align and layer objects
4m 49s
-
-
Create a PivotTable
3m 21s
-
Pivot a PivotTable
2m 51s
-
Manage subtotals and grand totals
4m 55s
-
Change the data field summary operation and number format
4m 26s
-
Filter a PivotTable
4m 2s
-
-
Set AutoCorrect and automatic Replace options
4m 17s
-
Manage workbook comments
4m 19s
-
Print a worksheet or workbook
3m 50s
-
Set and remove print areas
3m 36s
-
Export workbooks to other formats
2m 59s
-
Further information
1m 2s
-