From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Manipulate chart placement with dragging techniques
From the course: Excel 2016: Tips and Tricks
Manipulate chart placement with dragging techniques
- [Voiceover] After creating a chart, you probably would want to move it around a particular worksheet, you might want to reshape it, resize it, you might even want to line up its edges with the cell boundaries in a worksheet and you can also quickly make a duplicate of a chart, maybe because you want a chart showing the same data but of a different type. On this worksheet called Chart Data, I'm gonna be highlighting the data for Domestic, Europe and Asia for all 12 months. One of Excel's best shortcuts, let's create a chart right here on the worksheet, Alt + F1, and there it is. To move a chart, you can drag any edge, it's gonna be easier though if you drag just inside the edge and usually this works best either in the upper-left or upper-right, just click and drag. Don't click in the middle of a chart and drag because you'll be moving perhaps the inner portion of it. I'll press Control + Z to undo that. So just inside the upper-right or left border tends to be the easiest way to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.