When you create a chart, Excel applies attractive but somewhat neutral formatting to it. You can change that formatting, either all at once by selecting a new chart style, or by formatting individual chart elements.
- [Instructor] When you create a chart,…Excel applies attractive…but somewhat neutral formatting to it.…You can change that formatting either all at once…by selecting a new chart style…or by formatting individual chart elements.…The chart you see on this worksheet is exactly…as Excel created it except that I edited the title.…So it went from Chart Title to Orders by Category and Year.…And I did that by clicking it, selecting the text…and typing it in the box.…
If you want to change the formatting of a chart,…all at once by applying a style,…select the chart and then…on the Chart Design contextual tab of the ribbon,…open up the style gallery,…which is here in the middle in ribbon gallery.…Click the expand or more button.…And you see all of the styles that are available to you.…The one that is currently applied is highlighted.…So you can see it here.…Let's say that I want to change to style 11.…
And it appears here.…It has a different font…and it looks like the layout has the legend…above the data…but below the title.…
- Creating workbooks
- Manipulating cell data
- Using core functions and formulas
- Formatting worksheet elements
- Creating PivotTables
- Collaborating with others
- Working with charts
- Adding images and shapes
- Saving workbooks
- Printing files
Skill Level Beginner
1. Get Started with Excel
2. Manage Workbooks
3. Work with Worksheets, Cells, and Cell Data
4. Sort, Filter, and Manage Worksheets
5. Summarize Data Using Formulas and Functions
6. Format Worksheet Elements
7. Work with Charts
8. Work with External Data and Objects
9. Explore PivotTables
10. Review and Share Your Spreadsheets
- 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.