Join Dennis Taylor for an in-depth discussion in this video Copying and linking charts with Word and PowerPoint, part of Excel for Mac 2011: Charts in Depth.
- Not only can you copy an Excel chart…to a different worksheet or to it's own…separate sheet, you can also copy a chart…to a Word document or a PowerPoint presentation.…I've got both Word and PowerPoint open at the moment…and I need to copy this chart and paste it into Word.…Now, I might want to paste it as if it…were just a snapshot or picture,…or I could want to paste it so that…it's linked to the source data,…meaning if there are changes to the Excel chart,…I want that to be reflected in the Word document.…
So I'm right clicking in the chart area…of this blue chart to the right of the data.…We're on a sheet called "Chart Data"…so right click, copy.…I'll jump over to Microsoft Word with cmd + tab…and I'll simply right click and paste.…Now, let's jump back to Excel.…I'm going to make a change to the data.…Imagine I make a typo here.…Instead of putting in the 130 for this January number,…I slip up, put in an extra zero,…and as soon as I press return all of these…charts here, which are linked to the data of course,…
Author
Dennis Taylor
Released
7/7/2015- Creating charts with one click
- Selecting the right chart types
- Changing chart type or source data
- Choosing a chart layout and style
- Saving charts as templates
- Editing titles, legends, and labels
- Adding a data table
- Analyzing data with trendlines
- Formatting the chart
- Customizing different chart types
- Creating Gantt and frequency charts
- Creating in-cell charts
- Moving charts
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome54s
-
-
1. Creating Basic Charts Quickly
-
2. Understanding Excel Chart Concepts
-
Identifying chart elements2m 56s
-
-
3. Creating and Adjusting Chart Appearances with Charts Tab Choices
-
Changing a chart's type2m 52s
-
-
4. Using Chart Layout Tab Options
-
Linking titles to content1m 59s
-
Adding a data table2m 58s
-
Modifying axes11m 59s
-
Working with gridlines5m 8s
-
Adding error bars4m 55s
-
5. Using Format Tab Options and Other Visual Features
-
Adding shapes and arrows7m 55s
-
6. Customizing Specific Chart Types
-
Customizing line charts6m 18s
-
Customizing pie charts9m 20s
-
7. Changing a Chart's Data Source
-
8. Specialized Excel Charts
-
Creating combination charts4m 58s
-
Creating Gantt charts7m 2s
-
-
9. Printing and Sharing Charts
-
Printing charts4m 44s
-
-
10. In-Cell Chart Alternatives
-
11. Chart Manipulation Tools
-
Conclusion
-
Next steps37s
-
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: Copying and linking charts with Word and PowerPoint