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.
- 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.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
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?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.