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 offer. 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 the top panel of the program. 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. Minimize the 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. Roll up 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.
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 Excel object, accordingly, if you change the source table or chart, 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 are in Excel file selected the table, executed 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 PowerPoint diagram editable using PowerPoint, and will be linked to the source by default. 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 highlight on the sheet Excel range cells or chart, 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 it in Explorer required file Excel. 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 diagram is associated with a source, then when double click Using the mouse for editing, the source file will open 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 opening a file from linked tables or diagrams, a dialog box appears asking you to update the links.
If you are not sure about the reliability of the source related files, press 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.
To established connection worked, it is required that the spreadsheet file is not 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
MS Word is a multifunctional program that has practically unlimited possibilities for working with documents. However, when it comes to the design of these same documents, their visual representation and built-in functionality may not be enough. That is why the composition Microsoft package Office comes with so many programs, each focused on different tasks.
PowerPoint- representative of the office family from Microsoft, advanced software solution, focused on creating and editing presentations. Speaking of the latter, sometimes it may be necessary to add a table to a presentation in order to clearly show certain data. We have already written about how to make a table in Word (the link to the material is provided below), in the same article we will tell you how to insert a table from MS Word into a PowerPoint presentation.
In fact, insert a table created in text editor Word, the PowerPoint presentation creation program is quite simple. Perhaps many users already know about this or at least guess. But still, detailed instructions It certainly won't be too much.
1. Click on the table to activate the mode for working with it.
2. In the main tab that appears on the control panel “Working with tables” go to tab "Layout" and in the group "Table" expand button menu “Select” by clicking on the triangle-shaped button located below it.
3. Select an item “Select table”.
4. Return to the tab "Home", in Group "Clipboard" click on the button "Copy".
5. Go to PowerPoint presentations and select the slide there to which you want to add a table.
6. On the left side of the tab "Home" click on the button "Insert".
7. The table will be added to the presentation.
- Advice: If necessary, you can easily resize the table inserted into PowerPoint. This is done in exactly the same way as in MS Word - just pull one of the circles on its outer border.
That's all, in fact, from this article you learned how to copy a table from Word to a PowerPoint presentation. We wish you success in further development of the package programs Microsoft Office.
Create tables, edit and format them, and import tables from Excel into PowerPoint
Presentation
Speaker Deck YouTube SlideShare
Skills 77-429
Theory:
- Creating tables
Video version
Text version
Tables is a great way to organize complex data that can be structured. A table consists of rows and columns at the intersection of which are cells containing data.
Working with data that is organized in tables is so convenient that the MS Office package has a separate application for working with spreadsheets - Excel. In PowerPoint, tables are not used to perform calculations or analysis, but to present data, with the resulting capabilities of working with tables. Although some restrictions in the design of PowerPoint tables seem strange, we will talk about this during the lesson.
Creating a table
There are a variety of ways you can create a table in PowerPoint.
Firstly, if the slide layout allows for it, then you can insert the table into universal filler, or special "Table" placeholder.
Secondly, if the slide layout does not include a table, then you can insert a table in the same way as in the MS Word word processor, using the tab "Insert"/"Table".
The difference between inserting a table using a placeholder and using the insert command is exactly the same as when working with text captions, i.e., by inserting a table into a placeholder, we can change its position on the slide by changing the slide layout, and by inserting a command inserts not in the placeholder - no.
Using a special field, you can select the desired number of rows and columns of the table. By using of this field you can create a table with a maximum dimension of 10 by 8, so if you need more, you should use the “Insert Table” command and specify the desired number of rows and columns in the dialog box.
Insert a new table using the Table command
Drawing a table
The next option from the “Table” command of the “Insert” tab is “Draw a table.” The table drawing command should be used if you have a table or, for example, its header, of a complex structure and you know how to draw it.
Working with the “Draw Table” command occurs according to the following algorithm:
- We draw the outline of the table - just a rectangle on the slide.
- Again with this command, which can now be accessed through an additional tab "Constructor", draw internal structure. There is one feature here: if we start drawing outside the outline of the table we just drew, we will be creating a new table, so we need to start drawing an internal dividing line inside the rectangle created in the first step.
The last option of the "Tables" command looks similar to the previous ones, however, it is radically different because it embeds, or imports, an object of the Microsoft Excel sheet type and this is the topic of the next question in the course.
- Importing tables
Video version
Text version
Importing a new table
The last option of the “Tables” command allows you to embed tables from the Excel spreadsheet processor. This can be convenient if you need to make calculations in a table. Executing the command "Table" / "Excel Table" actually opens an Excel workbook inside a PowerPoint slide, and working in such an imported table is done by Excel tools. In order to return to PowerPoint, you need to click any mouse button outside the embedded table.
In order to resume work with a previously imported Excel table, you need to double-click on the table with the left mouse button, or select the appropriate item in the context menu of the embedded table.
Importing a finished table
Often, when creating a presentation, tables with calculations in Excel are not created in PowerPoint itself, but are implemented previously prepared in a spreadsheet processor. And here are the options when creating data for the presentation:
- If you simply select the data on the sheet, copy it with Ctrl + C and paste it with Ctrl + V onto a presentation slide, then this will be equivalent to creating a regular table in PowerPoint, i.e. data calculation is not supported;
- if you select data on an Excel sheet, and then, in the drop-down command, select "Insert Special"/ , then a copy of the sheet with Excel data. Those. in the future, they can be corrected from the presentation itself, and the end result is similar to the command "Table" / "Excel Table";
- if you select data on an Excel sheet, and then, in the drop-down command "Insert" choose, as in the previous case, "Insert Special" / "Microsoft Excel Sheet Object" and don't forget to switch the switch on the left to "To tie", then the data in the presentation will look like in the previous case, but will be stored in the Excel file from which the insertion was made. Those. Changing the data in the Excel file will result in changing the data in the presentation.
Importing other objects
You can insert not only tables from Excel into the presentation, but also other files: text Word documents, WordPad, pictures, Excel charts and even individual presentations.
Using the “Object” command from the “Text” group of the “Insert” tab, you can call up the dialog box for embedding an object into the presentation.
From the list of objects, you can choose to create a new one or take information from a ready-made file. It is logical that the list depends on installed applications in the system, so, for example, if you do not have Visio, then it is impossible to create a new embedded object of this type.
- Changing the table layout
Video version
Text version
After creating a table, namely creating, and not introducing third-party objects, additional tabs appear on the interface ribbon "Constructor" And "Layout", conditionally united into a group "Working with tables".
For additional tabs to appear, you must place the cursor in the table.
Tab "Constructor" used to change appearance table, we will look at it in the next question, and the tab "Layout" is responsible for the table layout, no matter how trivial it may sound.
Adding Rows and Columns
When inserting a new table, it can be difficult to provide the required number of rows and columns; in fact, this is not necessary because adding new ones is quite simple and can be done in several ways.
Commands for adding new rows and columns are present on the interface ribbon on an additional tab "Layout", group "Rows and Columns". You can add new rows and columns from the mini-toolbar, which appears after selecting table cells and calling the context menu.
In both the first and second cases, a simple rule applies: how many rows/columns are selected, so many will be added when executing the corresponding command either from the interface ribbon or from the mini-panel. There is no need to select the entire row; just select one cell from a row or column. For example, selecting two cells, one under one, and executing the command to add new rows will add two rows, and executing the command to add new columns will add one column, because the selected cells are in the same column.
In addition, when filling a table with data, it is convenient to move to the cell on the left using the Tab key and, if the cursor is in the last cell of the table, then pressing the Tab key will create new line tables, but the Enter key will create a new paragraph in the current cell.
Removing Rows and Columns
Removing rows and columns is the same as adding them. We select the cells in the table of those rows or columns that need to be deleted and execute the delete command from the interface ribbon or context menu.
In addition, you can completely delete a row or column using the Backspace key (not Delete, Delete will simply clear the table cells of the contents), but in this case you need to select the entire row or column to be deleted.
Moving Rows and Columns
To move, you can use Drag and Drop techniques, interface elements, and hotkeys.
The essence of moving comes down to cutting data from one place and pasting it into another, and if the destination cells already contained data, they will be replaced.
Group commands are used to move rows and columns "Clipboard" tabs "Home", the same commands can be found in the context menu by calling it after selecting a row or column. And in conclusion, it should be said that the standard keyboard shortcut is Ctrl + X for cutting, and Ctrl + V for pasting data.
If you select (by dragging the mouse with the left key held down, or using the “Select” command on the “Layout” tab) a column or row and dragging it to another place, then the selected column/row will not be deleted, it will only be cleared of data, but if this The operation is performed using the interface ribbon commands discussed above, the context menu or a hot combination, then the column/row will be completely deleted. True, if you do not select the entire row/column, there will be no difference; the selected cells will simply be cleared, regardless of how the movement was made.
The copying operation is similar to moving, the cutting and copying commands are nearby, and the hot combination for copying is Ctrl + C, in the case of using “Drag and Drop”, you must additionally hold down Ctrl.
Hot combination
If you hold down while dragging a row or column Ctrl, then the data will be copied
Resizing Rows and Columns
Resizing both the table itself and its rows or columns will allow you to best present the data on the slide. To change the size of the table itself, when focusing it, you need to pull the small rings that are located at the edges of the table.
To change the size of columns/rows, you need to move the cursor to the border of the column or row so that it takes the form of a double-headed arrow and, holding down the left mouse button, change the size. In addition, you can quickly size a column to equal the widest entry in the column by double-clicking on the border when the cursor changes to a double-headed arrow. This method does not work for strings.
On the interface ribbon, on an additional tab "Layout", in Group "Cell Size" present additional commands to work with tables, you can set the size of the row and column at the intersection of which the cursor is located, and also quickly align the size of all rows or columns in the table.
But if you need to accurately set the dimensions of an entire table, then this can be easily done from the group "Table size" additional tab "Layout".
Change the alignment and orientation of text in a table
There are times when the table fits almost perfectly into the slide, but is just a little missing, literally a couple of millimeters. You can gain such millimeters when placing data in a table by reducing the internal boundaries of the cell. In the “Alignment” group, the “Cell Margins” command will allow you to change the size of the cell by fitting the data into it, you can change the internal borders of an individual cell or group by first selecting them.
In the same group, you can configure the orientation of text inside cells, as well as horizontal or vertical alignment, similar to how it is done for text fields.
Using the commands in the Alignment group of the Layout tab, you can adjust the orientation of text in table cells: horizontally (by default), rotated by 90 or 270 degrees, and also written in a column, when letters are written from top to bottom. In the latter case, the cursor takes a horizontal direction.
You can access text alignment and orientation commands using the sidebar “Shape Format” / “Text Options” / “Caption”.
Merging and Splitting Cells
The last table layout operations we'll look at are merging and splitting cells. To merge several cells, you need to select them and run the command "Merge Cells" from the group "An association" tabs "Layout", or select the same command from the context menu.
If the cells that were merged contained data, then the new cell will contain all of those records, broken down by row.
Splitting cells is also simple: place the cursor in the cell and press the split command; in the dialog box, enter the desired number of rows and columns into which you want to split. In this case, if you select several cells and execute the split command, the split will affect each individual cell. For example, if you need to turn 4 cells into two, they must first be combined, otherwise we will get 8 cells (4x2).
It is noteworthy that in the same Word, the process of splitting table cells is very similar, but the dialog box "Split cells" contains additional option "Merge Before Split".
In conclusion, all that remains is to note that you can separate cells by drawing borders, which we discussed earlier. Drawing is on the additional tab "Constructor" in Group "Draw boundaries".
- Formatting tables
Video version
Text version
Before looking at PowerPoint table design tools, it should be noted that moderate, well-thought-out design will look professional, while excessive use of colors and effects will distract attention from the contents of the table and will negatively affect the overall perception of the presentation.
If you are not sure about the design of the table, a win-win option is a table without any design at all. White background and black font, well, the borders can be made gray. Of course, you need to watch the presentation itself, but always keep in mind Golden Rule: “Data comes first.”
PowerPoint designs all new tables in the default style provided by the specific template. You may want to change the default table formatting. To change the table formatting, the additional “Designer” tab is responsible, which appears when you place the cursor on the table along with the additional “Layout” tab.
Design Tab Commands
Applying a table style
PowerPoint tables are formatted with default settings; you can quickly change the specified formatting by applying one of the styles that are located in the “Table Styles” group of the additional “Design” tab. Here you can completely clear the table formatting by selecting the “Clear Table” command; however, the contents will not be deleted.
The colors found in table styles depend on the current theme, meaning that if you select one of the styles and then change the presentation theme or simply copy the table into another presentation (with a different color scheme), the table's appearance will also change. Therefore, if you want to color the table so that the colors do not change, you need to color not using styles, but select separately the fill, effects (if necessary), font color from the standard set of colors, or use the “Other Colors” command and select the required color.
Additional Table Style Options
Pre-built table styles have separate elements: header row, total row, first and last column, which can be further highlighted. This selection is made by a corresponding mark in the “Table Style Options” group; here you can also visually separate even and odd rows and columns.
With the right approach, using the appropriate options, you can focus attention on the necessary elements, for example, results.
Managing table borders
The drop-down command for managing borders in a table and its cells works in conjunction with the “Draw Borders” group. Using the commands of this group, you can set the color of borders, their thickness and type, and using the border command you can specify where to apply this or that border. Essentially, the same thing can be done using the “Draw Table” tool, if you draw a pencil only along the borders of the table cells.
Among interesting features You can mark the diagonal division of the cell; to write text in such a cell, enter the left part, press Ctrl+Tab (this combination adds a tab stop within the table and also works in Word) and enter the second part of the cell.
The diagonal border of a cell, unlike other borders, is conditional, i.e. it does not limit the text and will take extra care to ensure that it fits nicely into the cell itself. You can also justify parts of the text in a table with spaces.
Filling a table with color
The fill color command is located above the borders and allows you to select the color of one or more pre-selected cells. At the top are the theme colors, they change depending on the theme or its color settings. Standard colors will always look the same.
Using the “Other fill colors...” command, you can select an arbitrary fill color, including by color code. The pipette will allow you to select a sample, unfortunately, the sample must be inside the PowerPoint presentation, this greatly limits its use, because You can’t open the color you like in the browser and take a sample; you have to use third-party applications.
Using the “Picture...”, “Gradient” and “Texture” commands, you can set a fairly specific fill for table cells, and you can select one picture for the header, and another for the main part of the table.
Most likely, if you set a pattern to fill cells, you should set a transparency level for it so that the text in the cells remains readable. This can be done at additional panel“Shape Format” in the “Fill” section (The panel can be called through the context menu).
The last option in the Fill drop-down command, Table Background, works similarly to a standard fill, with the only exception that it is applied to the entire table at once. You can see the table background only if the cells have no fill set or a transparent fill is set.
Borders, Shading, Design Tab Effects
Arranging a table with other objects
In PowerPoint, a table is a shape that can move freely around the slide. If there are other objects on the slide (pictures, tables, shapes, icons, SmartArt, etc.), then they are placed on the slide in levels; the later the object is added, the higher it is and can overlap other objects.
The possibilities of placing objects on presentation slides will be discussed in detail in the lesson on working with pictures, but now we will only describe the “Move back/forward” commands from the “Arrangement” group of the additional “Layout” tab. Using these commands, you can either immediately move the object to the very bottom/top by selecting “Send to Back”/“Bring to Front”, or to a level lower/higher using the “Move Back/Forward” commands.
Using the “Selection Area” command, you can view all the objects on the slide, their placement, and also arrange them there by simply dragging with the mouse or the triangular arrows at the top.
Since the entire presentation slide consists of objects, the command to arrange them is very relevant, which is probably why it can be found on the “Home” tab in the “Drawing” group or, when selecting a shape/drawing, on the “Format” tab.
Flashcards
So-called memory cards, look at the card and try to answer, clicking on the card will display the correct answer. Memory cards are good for remembering key lesson points. All classes this course equipped with memory cards.
Practice
In the practical part you will find tasks for the last lesson. After completing them, you have the opportunity to compare your version with the answer prepared by the lecturer. It is strongly recommended that you view the solution only after you have completed the task yourself. For some tasks there are small hints
Task 1: Adding a table
- Open the presentation from the previous lesson.
- On slide 25, select “Insert Table” in the placeholder, specifying 2 columns and 7 rows. Fill in the same way as the table below:
- Save the presentation for later. "Presentation lesson 4.1."
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, using PowerPoint capabilities, change the table style or add any 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 ().
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.
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 or Word to PowerPoint, select the original table. Execute in original application team Copy, then in Power app Point 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 ().
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 ().
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 right size tables, and then (with the active instrument Draw a table) drag the cursor to create columns and rows - .
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.
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, click right click mouse on the table style, and then in the context menu run the command 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
With Microsoft Office 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 this data and select desired type charts on the ribbon (tab Insert, group Diagrams) - .
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 comparison 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 you want to demonstrate is not the differences between data points, but the analogies across large data sets.
- 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 an 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- information on the diagram with additional information about a data token representing a single data point or value sheet cells.
- 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.
- Application special features for different types of diagrams. 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 indicates an increase in sales over a certain amount 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 into the presentation Excel chart 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. An Excel worksheet is separate file, and it is not saved 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.
- chart area (the area where the chart and all its elements are placed),
- plotting area (the area containing all data series, category names, division labels and axis names),
- data series (a set of related data elements displayed on a chart),
- axes (X,Y,Z),
- names on diagrams,
- data labels with additional information about the data marker (marker is one data point or worksheet cell value),
- legend.
Formatting chart elements
You can format the following chart elements separately (independently of the rest):
Click the chart element you want to format - a group will appear Working with charts with tabs Constructor, Layout And Format ().
Rice. 6.10.
On the tab Format in Group Current fragment select the chart element you want to format().
Rice. 6.11.
On the tab Format Perform one of the following actions:
Changing the type of an existing chart
For most flat charts, you can change the chart type for the entire chart, giving it a completely different look, or you can choose a different chart type for any single data series, turning the chart into a blended chart.
To change the type of the entire chart, click the chart area (or plotting area) to display the chart tools. The chart tools appear, containing tabs Constructor, Layout And Format. Specifically, to change the chart type for a single data series, select the data series. On the tab Constructor in Group Type select team Change chart type ().
Rice. 6.13.
Advice
If you often use a particular chart type when creating charts, you can set that type as the default chart type. After selecting the chart type and subtype in the dialog box Changing the chart type click on the button Make it standard.
Tools for formatting chart elements when activating a tab Layout are given on . As we can see from this illustration, here the user has the opportunity to change the labels, axes and background on the diagram.
Apply built-in chart styles and layouts (Design tab)
Instead of adding chart elements and formatting them manually, you can quickly apply a built-in chart layout or style to your data. PowerPoint has many convenient built-in layouts and styles from which to choose. You can then refine and customize the layout or style manually as needed by changing the layout or formatting of individual chart elements, such as the chart area (the area where the chart and all its elements are placed, data series, and legend.
To select a chart layout, click on the chart you want to format - the tools will be displayed Working with charts. On the tab Constructor in Group Chart Layouts Click the chart element you want to use. To view all available layouts, click on the button Additionally. An example of choosing a chart layout is given at.
Rice. 6.15.
When you use the built-in chart layout, the chart displays a set of elements in a specific order, such as titles, legend,
- 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.
Loading...
