Join Dennis Taylor for an in-depth discussion in this video Placing and adjusting charts, part of Excel 2010: Tips, Tricks, and Shortcuts.
If you create a chart in Excel and put it in the same worksheet as the data,…sometimes you want certain kind of control over how the chart is placed.…If you have worked with charts, you probably know that if you'd like to move a…chart, you need to only click just inside the border and drag perhaps in one…smooth action here, like that, move it around wherever you want.…Sometimes you might have other charts with this, or you just want to move it a little bit.…If you hold down the Ctrl key as you click on a chart, you've put it into a…certain kind of mode, so that you can nudge the chart by simply pressing arrow keys.…
So, I'm pressing the Up Arrow right now and you see how this is moving the…chart just slightly upward. Or leftward, or downward.…If you work with graphics a lot, either objects or images like this, that might…be not too critical.…Something else you might want to do though, something different really, is…that when you click on a chart, you perhaps recognize that on each midpoint,…
Author
Released
8/12/2010- Creating charts with keyboard shortcuts
- Converting formulas to values by dragging
- Repeating Undo and Redo actions
- Displaying formulas instantly
- Navigating quickly through worksheets and across workbooks
- Formatting numeric, and date/time data in a flash with keystroke shortcuts
- Inserting dates or times instantly
- Grouping rows or columns to create collapsible regions
- Building data-entry shortcuts with Auto-fill
- Displaying unique items from large lists
Skill Level Intermediate
Duration
Views
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Excel 2010: Advanced Formatting Techniques
with Dennis Taylor3h 2m Intermediate -
Excel 2010: Charts
with Dennis Taylor3h 38m Intermediate -
Excel 2010: Macros
with Dennis Taylor2h 44m Intermediate
-
Introduction
-
Welcome1m 16s
-
-
1. Top Ten Shortcuts
-
Print Preview1m 7s
-
Instant date or time entry1m 16s
-
Undo/Redo/Repeat3m 19s
-
Zooming in and out quickly2m 10s
-
2. Ribbon and Quick Access Toolbar Tips
-
Keyboard command access2m 22s
-
3. Display Shortcuts
-
4. Navigation Shortcuts
-
Navigation shortcuts2m 30s
-
Navigating within worksheets5m 13s
-
-
5. Selection Shortcuts
-
6. Data Entry and Editing Shortcuts
-
Accelerating data entry6m 27s
-
Custom lists for rapid entry5m 54s
-
Cell editing tips2m 19s
-
-
7. Drag-and-Drop Techniques
-
Copy/Move acceleration tips3m 27s
-
-
8. Formula Shortcuts
-
Rapid formula creation3m 48s
-
AutoSum shortcuts2m 57s
-
Rounding shortcuts5m 14s
-
Generating random numbers3m 16s
-
Counting unique entries3m 11s
-
-
9. Operational Shortcuts
-
Controlling rows and columns5m 50s
-
Realigning imported text2m 27s
-
Handling blank cells4m 20s
-
-
10. Formatting Shortcuts
-
Formatting numbers6m 49s
-
Aligning data3m 49s
-
Creating custom formats6m 23s
-
-
11. Database Techniques
-
Sorting shortcuts2m 40s
-
Cleaning up spaces4m 47s
-
Identifying duplicates6m 10s
-
Splitting columns3m 57s
-
Ensuring unique entries2m 46s
-
-
12. Charting and Visual Object Tips
-
Placing and adjusting charts2m 37s
-
-
Conclusion
-
Goodbye9s
-
- 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: Placing and adjusting charts