Join Dennis Taylor for an in-depth discussion in this video Create charts instantly with either of these keystroke shortcuts, part of Excel 2013 Tips and Tricks.
Creating charts can be a lengthy process, particularly if you get bogged down in all the many different formatting choices that Excel has available, but you can create charts very fast simply by selecting data and if we look at the data in this worksheet called Chart Data, we could possibly be highlighting this data right here, it's generally a good idea not to include totals along with detail data, but if we simply highlight the data here, there are two quick keystroke shortcuts that we might consider using. If we like to create a chart on a separate sheet, based on the selected data, simply press F11 and we're on a new sheet to the left of the sheet that has the data and here's our chart.
Some people prefer to work with a chart all by itself, you can print it all by itself from here easily and focus just on the chart itself. If you prefer to have a chart right on the same worksheet, for example, like the ones we see to the right here, based on the same data, we've got our data highlighted, simply press Alt + F1 and there's a chart, you're off to the races, so to speak. You don't have to do a whole lot more with this, obviously we'd want to change the title, possibly add some more information, but it really is very, very fast to get started with chart creation simply by using either of those shortcuts, F11 to take selected data and create a chart on a new sheet, or Alt + F1 to create a chart on the same sheet as the data.
Author
Released
7/16/2014- Converting formulas to values with a simple drag
- Entering today's date or time instantly
- Accessing Ribbon commands from the keyboard
- Creating split screens fast
- Navigating quickly
- Entering data more efficiently
- Performing calculations without formulas
- Applying formatting with keyboard shortcuts
- Using database techniques to work with Excel data
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate -
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced -
Excel 2013: Pivot Tables
with Curt Frye4h 20m Intermediate
-
Introduction
-
Welcome39s
-
-
1. Top Ten Shortcuts
-
Zoom in and out quickly1m 27s
-
2. Ribbon and Quick Access Toolbar Tips
-
3. Display Shortcuts
-
4. Navigation Shortcuts
-
Navigate within worksheets5m 24s
-
5. Selection Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Accelerate data entry8m 37s
-
Enhanced editing tools3m 2s
-
-
7. Drag-and-Drop Techniques
-
8. Formula Shortcuts
-
Create formulas rapidly5m 34s
-
Use AutoSum shortcuts3m 55s
-
Use rounding shortcuts5m 46s
-
Generate random numbers4m 27s
-
-
9. Operational Shortcuts
-
Realign imported text3m 41s
-
10. Formatting Shortcuts
-
11. Database Techniques
-
Clean up spaces quickly5m 16s
-
12. Charting and Visual Object Tips
-
13. Ten Tiny Tips
-
Conclusion
-
Next steps28s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Create charts instantly with either of these keystroke shortcuts