Join Dennis Taylor for an in-depth discussion in this video Resizing, moving, copying, and manipulating charts and other objects, part of Excel Tips Weekly.
- View Offline
- When you work with charts and objects…like the ones we're seeing on this worksheet to the right,…there are key stroke short cuts that you can use…as you redesign the look of these or create them.…Let's first create a chart, here.…With this data here, I'll just simply click in the middle.…Since it's surrounded by empty cells,…I can create a chart quickly simply with Alt F1.…By the way, a nice way to add a title…is simply to click the existing chart title place holder,…type equal, and click on a relevant cell…that has the data that you want to use for a title.…In this case, It's A1 and Enter.…
There we are.…In order to see the edges of this chart…a bit more clearly, I'm simply going to choose…one of the chart formats available on the design tab…that has a black background.…Easier to see the edges now.…As soon as you create a chart, either by…this short method that I just used, here,…Alt F1 or standard method, it's almost…always the case that you want to move it around.…You can move a chart by dragging…from the upper right hand corner.…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
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.