Join David Rivers for an in-depth discussion in this video Formatting chart elements, part of Migrating from Office 2007 to Office 2010.
…One thing that gets a lot easier here in Excel 2010 over Excel…2007 is the editing of individual chart elements.…Let me show you what I'm talking about as we…continue with our NoObstaclesHomeSales workbook here.…On the Sales by Region tab, if you skipped to this movie and…need to get caught up, open up NoObstaclesHomeSales6.…We're going to select this table that's already created with our sparklines and…our conditional formatting.…Let's select from Product in D3 across and down to Column H, row 8.…
That's the range we want to create the chart from and…just like we did in Excel 2007, we would go to the Insert Tab and…choose from the charts section the type of charts we want, how about Column?…And let's choose the first 3D option and automatically there it is,…we have our nice looking chart.…Let's size it down just a little bit in its height and…let's move it down just below our table.…And if you need to you can scroll down a little bit,…so you can see all of your chart.…
Now, if we wanted to, say, move the legend underneath,…
- Understanding the reasons to switch
- Customizing the ribbon
- Saving to the cloud
- Adding screenshots to files
- Understanding file formats and compatibility
- Using conditional formatting in Excel
- Saving presentations as video
- Importing Outlook contacts, calendars, email, and more
Skill Level Intermediate
Word 2010 Essential Trainingwith Gini von Courter8h 3m Beginner
Outlook 2010 Essential Trainingwith Karen Fredricks2h 55m Beginner
PowerPoint 2010 Essential Trainingwith David Diskin3h 24m Beginner
1. Getting Started
2. Migrating to Word 2010
3. Migrating to Excel 2010
4. Migrating to PowerPoint 2010
5. Migrating to Outlook 2010
- 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.