home › Internet › How to transfer a table from word to powerpoint. Formatting chart elements

How to transfer a table from word to powerpoint. Formatting chart elements

Tables is one of the tools you can use to display information in PowerPoint. There are several ways how to make a table in powerpoint. Let's look at each of them. And you yourself choose which one will be more convenient for you to use in order to insert table into powerpoint presentation.

How to make a table in the fastest way

On the " INSERT» click the command « Table ».

How to Make a Table in PowerPoint - Table

Hover your mouse over the grid of squares to select the number of columns and rows you want in the table. In our example, we will insert a 4x5 table.

How to Make a Table in PowerPoint - Inserting a Table

The table appears on the currently selected slide.

How to Make a Table in PowerPoint - Insert a Table into a Presentation on a Slide

Click anywhere in the table and start typing to add text. You can also use the Tab key or the arrow keys on your keyboard to navigate through the table.

How to Make a Table in PowerPoint - Entering Data into a Table

How to insert a table in a placeholder

You can also insert a table by clicking the command " Insert table " in the placeholder.

How to Make a Table in PowerPoint - Inserting a Table in a Placeholder

In the window that appears, enter the desired number of rows and columns. Click OK.

How to Make a Table in PowerPoint - Insert Table Dialog Box

Table with given parameters will be inserted into the area.

Open the dialog box " Insert table"You can do it in another way. To do this, go to the " INSERT", click the command " Table" And in the window that opens, select “ Insert table ».

How to Make a Table in PowerPoint - Insert Table

How to make an Excel table in a presentation

If you need insert table fromExcel in PowerPoint, then for this:

Select the desired range in the Excel workbook and copy it, for example, by pressing the keyboard shortcut Ctrl+C.

How to Make a Table in PowerPoint - Selecting a Table in Excel

Go to the desired presentation slide and press the keyboard shortcut Ctrl+V. A table will appear on the current slide in the presentation.

How to Make a Table in PowerPoint - Insert Table from Excel

If you do not have a ready-made table in Excel, and you want to make a table in PowerPoint and then fill it out, then do the following:

On the already familiar tab “ INSERT", click " Table " and select " Excel table ».

How to Make a Table in PowerPoint - Excel Table

After this, a built-in table window will appear on the slide. Excel editor. Its size can be changed. Once all the information has been entered, click outside the window to close the window.

How to make a table in PowerPoint - Table editor window

Now you know, how to make a table in PowerPoint presentations in several ways.

You have a ready-made table in the document Microsoft Word or Excel? Do you want to transfer it to a Powerpoint file, but don't know how? Our article will help you solve this problem. The process of transferring a finished table from various office program documents is reliable and does not take much time. The main thing is to strictly follow all the points that we will talk about in our article.

How can you avoid wasting time creating a new table and transfer the already prepared one to a Powerpoint document?

First of all, we will tell you how to copy a finished table from a Word document into your presentation. To avoid any problems with formatting, strictly follow the algorithm of actions that we propose. To begin, open both documents. Expand the file with the table, and then move the cursor over it. A square icon will be displayed in its left corner. Using it you can select the desired table. After this, you will need to click on the “Layout” tab on top panel programs. It will appear only after selecting a table in the “Working with Tables” group. There you will see a select button.

Click on the arrow next to this button. After clicking, a drop-down menu will appear where you will need to select the “Select table” item. Once the table is highlighted, click on the Home tab. There will be a category “Clipboard”. You will need to click on the copy button. After this, the table will be saved to the clipboard. Roll up Word document and open your presentation. When Powerpoint opens, select the slide you want. Click the Home tab and then the Insert button. After this action, the table will be completely transferred to the Powerpoint document, saving your time that would have been spent on creating it. In the same way, this procedure is carried out with Excel documents.

Moving individual table cells

However, sometimes it is not necessary to transfer the entire table from the files of this program, but only a group of cells. This is done in the following way. To select a group of cells, move the cursor to the upper left corner of the table and move it so that only those you need remain marked.

Still in the same “Home” tab, in the “Clipboard” group, click the “Copy” button. Minimize the Excel document and open your presentation. Select the desired slide and click on the “Insert” button on the main tab. After this, the necessary cells will be successfully moved, and your presentation can be shown at meetings and conferences. We hope that our article helped you learn how to work with tables in Powerpoint.

Despite the rule that a presentation should not be overloaded with a lot of information, sometimes you need to add an existing or new table to a slide. For example, created in the program Microsoft Excel. Let's look at the steps on how to insert a table into a presentation and how to create a table in it. We will use Microsoft PowerPoint 2010 as a program for preparing presentations (Actually, you can add it to PowerPoint 2007).

If the Excel table is already ready, then this can be done quite simply. To do this, select and copy the table (or the desired part of it). Then open the corresponding slide in the PowerPoint presentation and insert it.

You can also add a table to a presentation using Ribbon commands. To do this, on the ribbon, activate the “Insert” tab, then select the “Table” button. The button contains a drop-down list that allows you to select one of the options for inserting a table into your presentation.

By moving the mouse pointer over the cells, select the desired characteristics of the inserted table - the number of rows and columns.
The same can be done using the "Insert table" button
"Draw a table." In my opinion, adding a new table to a presentation is a rather inconvenient option, since you then have to do additional steps to select or add columns (rows).
"Excel table". As a result of insertion, a new table in Excel format appears on the slide, and the same tabs for working with the table that are in this program are immediately activated. This means there is no need to create a separate table file. Microsoft package Office, after all.

It is worth noting that, in fact, all these options in the drop-down list of the “Insert” button give the same result (table), only the order of actions changes. This is not bad, since you can insert the table into a powerpoint presentation and work with it in the usual way.

Another option for a table is to insert it directly from the slide. To do this, click on the pop-up button on the empty slide “Insert table”.

We have already noted that you can work with a table in the same way as in Microsoft Excel, if it was inserted as an “Excel Table”. To do this, you need to double-click on it.

Another sequence of actions can lead to this result. To do this, you need to find the “Object” button in the “Insert” tab, and then in the “Object Type” select one of the Microsoft Excel sheets.

If a ready-made table was inserted, then two contextual tabs on the PowerPoint ribbon will become available - “Design” and “Layout”. Thus, you can change the design of the table and its other characteristics.

So, there are a lot of options for adding a table to a PowerPoint presentation. Choose. In conclusion, let us remind you that a large amount of information usually does not benefit the presentation, making it more difficult to understand. Therefore, you may not want to insert the entire table. It's better to select only the required columns and rows.

Any presentation looks more impressive and clearer if it contains elements such as tables and diagrams. But PowerPoint's built-in tools don't have the same capabilities and are not as convenient as similar Excel tools. Therefore, it is important to be able to insert tables and charts created in Excel into slides.

This can be done using embedding or linking.

First of all, you need to understand the difference between “linking” and “embedding”.

If we do not need (and sometimes it is not desirable) to update a table or chart obtained from Excel in a presentation, then we use embedding. In this case, a static copy of the data is placed on the slide, i.e. the embedded object becomes part of the presentation and is no longer associated with the data source. The size of the presentation file naturally increases.

If we need to keep data obtained from Excel up to date, we should use binding. In this case, a link to an Excel object is placed on the slide; accordingly, if the source table or chart is changed, the data on the slide will also change.

Let's consider different ways linking and implementation.

1. VIA CLIPBOARD

We all know that working with the clipboard is done using commands Copy paste. But it should be noted that in presentations the command action Insert differs for tables and charts.

If you selected a table in an Excel file, run the command Copy, went to the slide and gave the command Insert, the table will be inserted as a PowerPoint table with the ability to edit using PowerPoint, but by default there will be no connection to the source. That is, it will happen implementation .

If you perform the same actions with the diagram, the diagram will be inserted as a PowerPoint diagram with the ability to edit using PowerPoint, and by default a connection will be established with the source. That is, it will happen tying .

If we want to change the default paste options, we will have to useSpecial insert. For this purpose in select a range of cells or a chart on an Excel sheet and execute the command Copy, go to the slide and give the command Special insert. The placement of this command varies depending on the version of PowerPoint.

In versions up to and including PowerPoint 2003, it is located in the menu Edit. Beginning with PowerPoint 2007, this command can be found in the button drop-down list Insert on the tab home.

Dialog window Special insert as follows:

if a table is inserted

if a diagram is inserted

In both cases, you can select a radio button in this dialog box Insert/Link, and also select the format of the inserted object.

Additionally, as of PowerPoint 2010, context menu team present Paste Options, which allows you to select embedding or linking options.

When inserting tables, only embedding options are available

And when inserting diagrams - both embedding and linking

2. CREATION OF A NEW OBJECT

To create a table or chart on a slide using Excel, on the tab Insert in Group Text press the button An object,

for versions older than PowerPoint 2007, execute the menu commandInsert -- Object

and in the dialog box that openslooking for a line in the listMicrosoft Excel Sheet and press OK

After this, on the document page we see a fragment of an Excel sheet, as well as a ribbon with Excel tabs (or menus).

The same result will be obtained if on the tab Insert expand the list under the button Table and select an option Excel table.

Thus, we can embed an Excel table and work with it, using all the capabilities of this program, right on the slide.

If we want to create an embedded diagram, then in the dialog box Inserting an object on the tab Creationselect a lineMicrosoft Excel chart.In this case, not one Excel sheet will be created, but two: the first will contain an example of a chart, and the second will contain the original data for it, which should be replaced with your original data.

Once the table/chart has been created, clicking outside the object frame takes us back to the document. If you want to return to editing an object, just double-click on it.

3. CREATING AN OBJECT FROM A FILE

To do this, on the tabInsert in Group Text press the button An objectand in the dialog box that opens, set the switchCreate from file. Using a buttonReviewFind the required Excel file in Explorer. In this case, pay attention to the checkbox To tie. If it is not installed, then implementation tables or diagrams on the slide, but if you check the box, it will tying . Click OK.

The sheet that was active the last time the workbook was saved is inserted into the slide.

Perhaps it’s worth taking a little closer look at the differences in “behavior” between embedded and linked tables and charts created from a file.

If the object is embedded, i.e. connection with the source is not established, then double-clicking on the object will lead to the transition to editing mode. In this case, the PowerPoint ribbon (menu) will be replaced by the Excel ribbon (menu) with all the tools, but we will see the embedded object itself on the slide in a characteristic dashed frame.

If the table or chart is linked to a source, then double-clicking for editing will open the source file in a separate Excel window.

After changes are made to the source file, we save it, and then these changes are reflected on the slide in the associated table or chart.

Initially, PowerPoint resizes the inserted table or chart so that it fits completely on the slide. Because of this, large tables can be so reduced that they become unreadable. If we want, for example, to display part of a table on a slide, then we should learn how to change the size of the displayed object. The dimensions of the embedded object are controlled using dimensional handles at the corners and at the midpoints of the sides of the selection frame. In addition, the same dimension markers are available if you enter the editing mode of the embedded object.

What is the difference? If you move dimension markers while in edit mode implemented object, then you increase/decrease the number of visible rows/columns.

Was

It became

If you do the same operation without entering editing mode, then you simply stretch/compress the drawing.

Was

It became

Advice. If you plan to embed a diagram in a document, it is better to place it on a separate sheet.

When you open a file with linked tables or charts, a dialog box appears asking you to update the links.

If you are unsure about the reliability of the source of the linked files, click Cancel.

If option is selected Update connections, then the data in the presentation will be updated in accordance with latest changes in an Excel workbook.

For this link to work, the spreadsheet file must not be renamed or moved. If this happens, you can use the dialog box to re-register the path to the sourceConnections.

As you can see, in this dialog box there is an optionChange source, and Break connection, if it is no longer required. In addition, here you can choose how to update the connection:automatically or manually.

In versions prior to PowerPoint 2007, this dialog box opens when you execute a menu command Edit - Connections.

In PowerPoint 2007, you can open it by clicking the Office Button and choosing Prepare -- Change links to files.

Starting with PowerPoint 2010, select the tab to do this File -- Details -- Linked Documents -- Edit File Links.

EXAMPLES

Add a table to a slide

In the package Microsoft programs Office 2010 after creating a table in Office Word 2010 or Office Excel 2010, you can insert it into an Office PowerPoint 2010 presentation, and then use PowerPoint's capabilities to change the table's style or add some kind of visual effect. However, you can directly (immediately) create tables right in PowerPoint. Specify the slide where you want to add the table. Then on the tab Insert in Group Tables click on the button Table. Next, the table can be created in two ways.

In the first method, select multiple rows and columns and then left-click ().

Rice. 6.1.

In the second method, run the command Insert table and then enter the numbers into the lists Number of columns And Number of lines() and click on the button OK.

Rice. 6.2.

Advice

To add text to table cells, click the cell, and then type the text. Then click in an area outside the table.

Copy a table from other Office 2010 applications

To copy a table from Excel applications or Word into PowerPoint, select the original table. Run the command in your source application Copy, then in the Power Point application the command Insert. The table will be moved.

So, for example, in Word 2010, click on the table you want to copy, and then in the group Working with tables on the tab Layout in Group Table click on the arrow next to the button Select, and then select Select table ().

Rice. 6.3.

Next on the tab home in Group Clipboard click on the button Copy, and in a PowerPoint 2010 presentation, select the slide you want to copy the table to and on the tab home click on the button Insert. Most often, in this case Paste options option should be selected Keep original formatting ().

Rice. 6.4.

Drawing a table

You can draw a table. To do this, on the tab Insert in Group Tables click on the button Table, and then select Draw a table- the cursor will turn into a pencil. To mark the outer boundaries of the table, drag the cursor diagonally to the desired size of the table, and then (with the tool active Draw a table) drag the cursor to create columns and rows - .

Rice. 6.5.

The drawn table can be edited. To erase a line on a tab Constructor in Group Draw borders select instrument Eraser- the cursor will turn into an eraser. Click the line you want to erase - it will be destroyed.

Changing the table style

To change the table style, click on the table, then in the group Working with tables on the tab Constructor Select the desired style in the field. Table style thumbnails appear in the Quick Styles gallery in the - group. When you hover your mouse over the Quick Style, you can see the style of the table you're editing change. In other words, in Power Point there is a preview (preview) of the table style.

Rice. 6.6.

While editing a table, you can change its outline, background color, and/or apply effects to table cells. Any existing table style can be assigned as the style for all newly created tables. To do this, right-click on the table style, and then run the command in the context menu Default.

Note:

The author does not have the opportunity to cover such sections as: adding a row (column), merging (splitting) table cells, deleting a column and row, deleting the contents of a table cell, adding (changing, deleting) a table cell fill, adding and changing the table background color, changing table size, changing the size of a column or row, and a number of other topics. We encourage the reader to use the Help and explore these topics on their own.

Create charts in PowerPoint and Excel

Using the app Microsoft Office With Excel 2010, you can easily create professional-looking charts and then transfer them to PowerPoint. Unlike MS PowerPoint, MS Excel is specially designed for working with charts and allows you to present data using charts of various types. different types. When you create a new chart or edit an existing chart, you can choose from a variety of chart types (such as bar chart or pie chart) and chart variations (such as stacked bar chart or 3-D pie chart). By combining different types of charts on one chart, you can create a combination chart.

To create a basic chart in Excel that you can later edit and format, first enter the data for the chart in a worksheet. Then simply highlight that data and select the desired chart type from the Ribbon (tab Insert, group Diagrams) - .

Rice. 6.7.

You can copy a chart from Excel into PowerPoint 2010. When copied, the chart can be embedded as static data or linked to a workbook. If the chart is associated with a workbook that you have access to, you can set it automatic update according to the linked workbook every time you open the chart. Therefore, charts created in Excel are fully compatible with other Office 2010 applications, such as Office PowerPoint 2010 and Office Word 2010, and both of these applications contain the same charting tools as Excel.

New term

All chart types except pie charts can contain multiple data series. Data series- a set of interconnected data elements displayed on a diagram. Each data series in a chart has a different color or designation indicated in the chart legend.

Chart types

Office PowerPoint 2010 provides many different types of charts and graphs that you can use to provide your audience with information about inventory, organizational changes, sales data, and more. When you create or edit an existing chart, you can choose from many available subtypes of each chart type.

Histograms

Data that is arranged in columns or rows can be depicted as a histogram. Histograms are used to show changes in data over a period of time or to illustrate comparisons between objects. Histograms typically display categories along the horizontal axis and values along the vertical axis. To present data in volumetric form using three axes (horizontal, vertical, and depth) that can be changed, use a volumetric histogram.

Charts

Data that is arranged in columns or rows can be plotted as a graph. Graphs allow you to depict continuous change in data over time on a single scale; thus, they are ideal for depicting data trends at regular intervals. In graphs, data categories are evenly distributed along the horizontal axis, and values are evenly distributed along the vertical axis. You may want to use graphs when you have text category labels to display evenly spaced values, such as months, quarters, or fiscal years. This is especially important if you have multiple rows - for one row you can use the category axis. Graphs can also be used when there are multiple evenly spaced numeric labels, especially years. If there are more than ten number labels, it is better to use a scatter plot instead of a graph.

Pie charts

Data that is arranged in one column or row can be depicted as a pie chart. A pie chart shows the size of the elements of one data series. Pie charts are recommended if:

Only one row of data needs to be displayed.
All values that you want to display are non-negative.
Almost all values you want to display are greater than zero.
Values belong to no more than seven categories.
The categories correspond to parts of a general circle.

Bar charts

Data that is arranged in columns or rows can be depicted as a bar chart. Bar charts illustrate comparisons between individual elements. A bar chart is essentially a bar chart rotated 90 degrees clockwise. The advantage of using bar charts is that category labels are easier to read.

The axis labels are long.
The output values are durations.

Area Charts

Data that is arranged in columns or rows can be depicted as an area chart. Area charts illustrate the magnitude of change over time and can be used to draw attention to a cumulative value along a trend. For example, data showing profits over time can be displayed in an area chart to bring attention to overall profits.

Scatter plots

Data that is arranged in columns and rows can be depicted as a scatter plot. A scatter plot has two value axes, with one set of values plotted along the horizontal axis (X-axis) and the other along the vertical axis (Y-axis). Scatter plots are typically used to present and compare numerical values, such as scientific, statistical, or engineering data. Scatter plots are recommended if:

It is required to change the scale of the horizontal axis.
You must use a logarithmic scale for the horizontal axis.
The values are not evenly spaced on the horizontal axis.
There are many data points on the horizontal axis.
You want to efficiently display spreadsheet data that contains pairs of grouped value fields, and you want to introduce independent scatterplot scales to show additional information about the grouped values.
What needs to be demonstrated is not the differences between data points, but the analogies in large sets data.
You need to compare many data points without taking into account time - the more data that is used to create a scatter plot, the more accurate the comparison will be.

To display table data as a scatter plot, place the X-axis data in one row or column and the corresponding Y-axis data in adjacent rows or columns. That is, for example, to build a scatter plot of a weather forecast, you should collect data on the season in column 1 (X-axis), and on temperature in column 2 (Y-axis). Then in column 3 a temperature forecast will be built depending on the time of year.

Stock charts

Stock charts are very useful for displaying information about prices on an exchange. They require three to five data sets, depending on the subtype. As the name suggests, a stock chart is most often used to illustrate changes in stock prices. To create a stock chart, you need to correctly organize the output data. So, to create a simple high-low-close (ceiling-floor-close) stock chart, you would put the data in columns with headings Maximum, Minimum And Closing in the appropriate order. Let's assume that you have some stocks and recorded their quotes for ten days and this data is stored line by line in four variables tag(day), hoch(maximum), tief(minimum) and ende(final quote). Based on such data, you can also construct a stock chart.

Surface Charts

Data that is arranged in columns or rows can be depicted as a surface chart. A surface plot is used when you want to find optimal combinations in two sets of data. Surface charts can be used to illustrate categories and sets of data that represent numeric values).

Donut charts

Donut charts resemble pie charts with the middle cut out. However, the difference is that donut charts can represent multiple series of data.

Bubble charts

Bubble charts are similar to scatter charts that can display additional series of data. This additional data series is displayed as bubble size. In other words, a bubble chart can display column data in a spreadsheet, with the X-axis values selected from the first column, and the corresponding Y-axis values and bubble size values selected from adjacent columns.

Radar charts

A radar chart has a separate axis for each category, with all axes originating from the center. The value of the data points is marked on the corresponding axis. If all the points in a data series have the same values, then the radar chart takes the form of a circle. Radar charts allow you to compare the cumulative values of several data series and plot the distribution of data according to their value.

Example 6.1. Create diagrams in PowerPoint

In PowerPoint applications, you can create a chart by clicking the Diagram on the ribbon (tab Insert, group Illustrations). You can then change the chart or its formatting using the appropriate tools. If you select a chart type in this window and click on the button OK, then the created diagram will be built into Office PowerPoint 2010. In this case, by default, both PowerPoint and Excell() will launch.

Once you've created your chart, you can make changes to it. For example, you can change the appearance of the axes, add a chart title, move or hide the legend, and add additional chart elements.

PowerPoint has the following options for editing a chart:

Change the appearance of chart axes. You can specify the scale of the axes and change the spacing between values or categories. To make the diagram easier to read, you can add tick marks on the axes and specify the amount of space between them.
New term
By divisions These are the unit marks that cross the axis and look like ruler divisions. Tick labels identify categories, values, and series in a chart.
Adding a title and caption to a chart. To help explain the data shown in a chart, you can add a chart title, axis titles, and data labels.
New term
Data signature- Chart information with additional details about the data marker representing a single data point or worksheet cell value.
Adding a legend and data table. You can show or hide the legend, or change its location. Some charts can also display a table of data.
New term
Legend- a frame that defines the patterns or colors of series or categories of data in a chart.

New term
Data table- a range of cells containing the results of substituting various values into one or more formulas.
Using accessibility features for different chart types. WITH various types charts, you can use a variety of special lines, such as swing corridors and trend lines, bars (such as up and down bars and error bars), data markers, and so on.
New term
Trend line- graphical representation of the direction of change in a data series. For example, a rising line represents an increase in sales over a certain number of months. Trend lines are used to analyze prediction errors, also called regression analysis. As an example, a chart with data on sales volumes is shown. The diagram shows a trend line with a forecast of sales that can be expected from one of the sellers in the next period. For other seller's data, the limits of possible error are shown.

Rice. 6.9.
Embed and insert a chart into a presentation

In Office PowerPoint 2010, you can add a chart or graph to a presentation in two ways.
- Can implement diagram into a presentation. When you embed data from a chart in PowerPoint, the information can be edited in Office Excel 2010 and the worksheet is saved as a PowerPoint file.
  New term
  Embedded object- data contained in the source file and inserted into the destination file as an object. Once embedded, the object becomes part of the target file. Changes made to the embedded object are reflected in the target file.
- Can insert an Excel chart into your presentation and link it to data in Office Excel 2010. When you copy a chart from Office Excel 2010 and paste it into a presentation, the data in the chart is linked to an Excel worksheet. If you need to change the data in a chart, you must make changes to the associated worksheet in Office Excel 2010. Excel sheet- this is a separate file and is not saved along with PowerPoint file. Displays a chart with associated data in a table called data table. You can enter data into this table manually, import data from text file or paste data copied from another program.