Manipulate a worksheet chart in different ways: drag an edge of a chart to move it; drag a corner or side handle to change the chart size; with the shift key, drag a corner to change the size, keeping the same height-to-width ratio; with the command key, drag a handle to align with cell boundaries; control+D to duplicate the chart.
- [Voiceover] After creating a chart on a Worksheet,…you might want to manipulate it, move it around,…resize it, possibly duplicate it.…You can do this using various function keys…and the mouse.…I'd like to create a chart based on the data here.…For Domestic, Europe, and Asia,…highlighting just these cells right here.…On the Insert tab of the ribbon,…I'll click Column.…I want to create a Clustered Column chart.…Click it, and there's a chart.…To move a chart, you can drag an edge.…You can drag right inside the edge…and move the chart, as well, too.…
Don't point toward the middle of the chart and drag…because you'll be moving just a portion of the inner part…of the chart, like that.…Control Z.…At the edge, or just inside the edge,…pretty easy to move it around wherever you wish.…If you want to resize a chart,…you can point to one of the four corners handles,…as they're called, or one of the four handles…on each of the sides, the midpoint of each side.…If you are dragging those handles,…there could be times when you're dragging a corner handle.…
Author
Dennis Taylor
Released
5/11/2016The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "Ten Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple right-drag
- Undoing and redoing with keyboard commands
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Applying formatting with keyboard shortcuts
- Accelerating copying and moving data with drag and drop
- Creating formulas rapidly
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome33s
-
-
1. Top Ten Shortcuts
-
2. Display and Navigation Shortcuts
-
Navigate within worksheets6m 38s
-
3. Selection Shortcuts
-
4. Data Entry and Editing Shortcuts
-
Accelerate data entry8m 11s
-
-
5. Formatting Shortcuts
-
6. Drag-and-Drop Techniques
-
7. Formula Shortcuts
-
Use AutoSum shortcuts4m 9s
-
Use rounding shortcuts7m 54s
-
Generate random numbers9m 13s
-
8. Operational Shortcuts
-
Realign imported text4m 20s
-
9. Data Management Techniques
-
10. Tips for Using Charts and Visual Objects
-
11. Ten Tiny Tips
-
Conclusion
-
Goodbye26s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: Manipulate chart placement with dragging techniques