If the first chart type you select doesn’t work, you can try another one. If all you want to do is change the chart’s layout, such as by moving or removing the title, you can select from one of several pre-made layouts.
- [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.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.