How to make a circular diagram in a presentation. Create animated charts in PowerPoint. Importing charts from Excel

Various charts can be created in PowerPoint. First, let's create a blank slide. Next, in the "Insert" tab, click on the "Chart" button. Examples of possible objects will appear before us.

Let's create some kind of diagram. If you have Excel installed, this window will appear. Let's enter the required values.

As a result, I got the following diagram (it can be stretched in different directions, like a picture - by pulling the side edges):

Now the window Excel programs can be closed. If you need further changes, just click the "Change data" button and the program window will reappear.

All options for editing diagrams are located in the "Design", "Layout", "Format" tabs.

Design tab.

We can change the type of the chart, change the initial data and the style of design. For example, let's change the style.

To change the type of diagram, use the button of the same name in the left corner.

The elements of three-dimensional diagrams can be changed - rotated, change the angle of inclination, height and depth of the image. To do this, right-click on the diagram and select "Rotate 3-D Shape" from the context menu.

Let's rotate the diagram, give it a shadow, glow and frames.

As a result, we got the following diagram:

Layout tab.

Allows you to edit the selected chart element (title, legend, coordinate axis view and background).

Format tab.

Here you can style our diagram, create different effects, work with the font, change the size.

Adding a table to a slide

In Microsoft Office 2010, after you create a table in Office Word 2010 or Office Excel 2010, you can insert it into your Office PowerPoint 2010 presentation, and then use PowerPoint's capabilities to change the style of the table or add some 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 a group Tables click on the button table... Further, 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 numbers into the lists Number of columns and Number of lines() and click the button OK.

Rice. 6.2.

Advice

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

Copy a spreadsheet from other Office 2010 applications

To copy a table from Excel or Word to PowerPoint, select the source table. Run the command in the source application Copy then in Power app Point command Insert... The table will be transferred.

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

Rice. 6.3.

Next on the tab home in a group Clipboard click on the button Copy and in Power presentations Point 2010 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 you should choose an option Keep original formatting ().

Rice. 6.4.

Drawing a table

The table can be drawn. To do this, on the tab Insert in a group Tables click on the button table, and then select Draw table- the cursor turns into a pencil. To mark the outer borders of the table, drag the cursor diagonally to the desired table size, and then (with the active tool Draw 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 a group Draw borders select tool Eraser- the cursor turns into an eraser. Click the line you want to erase - it will be erased.

Change table style

To change the style of the table, click on the table, then in the group Working with tables in the tab Constructor select the desired style in the field. Table style sketches are displayed in the Quick Styles gallery in the - group. When you hover over a quick style, you can see the style change of the table you are editing. 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 a style for all newly created tables. To do this, right-click on the table style, and then in the context menu, run the command Default.

Note:

The author does not have the opportunity to highlight such sections as: adding a row (column), merging (splitting) table cells, deleting a column and a row, deleting the contents of a table cell, adding (changing, deleting) the fill of a table cell, adding and changing the background color of a table, changing sizing a table, resizing 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 "sharpened" for working with diagrams and allows you to present data using diagrams. different types... When creating a new chart or modifying an existing chart, you can choose from numerous chart types (such as bar or pie charts) and variations (such as stacked bar or 3-D pie charts). By combining different types of charts on the same chart, you can create a combo chart.

To create a basic chart in Excel that you can later modify and format, first enter the data for that chart in the worksheet. Then just select this data and select the desired chart type on the ribbon (tab Insert, group Diagrams) - .

Rice. 6.7.

A chart from Excel can be copied into PowerPoint 2010. When copied, the chart can be embedded as static data, or it can be linked to a workbook. If a chart is linked to a workbook that you have access to, you can set it to automatically update according to the data in the linked book each time you open the chart. Thus, 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 related data items displayed on a diagram. Each data series in a chart has a different color or designation, which is 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, changes organizational structure, sales data, and more. When creating or modifying an existing chart, you can choose from the many available chart subtypes of each type.

Histograms

Data that is arranged in columns or rows can be displayed as a bar graph. Bar charts are used to show changes in data over a period of time or to illustrate comparisons of objects. In bar charts, categories are usually plotted along the horizontal axis and values along the vertical axis. To present data in volumetric form using three axes (horizontal, vertical, and depth axis) that can be changed, use a volumetric histogram.

Charts

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

Pie charts

Data that is in a single column or row can be plotted as a pie chart. A pie chart shows the size of the elements of one data series. We recommend using pie charts if:

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

Bar charts

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

Axis labels are long.
The displayed values are durations.

Area charts

Data that is arranged in columns or rows can be displayed in an area chart. Area charts illustrate the magnitude of change over time and can be used to draw attention to a total value in line with a trend. For example, data showing profit over time can be displayed in an area chart to draw attention to total profit.

Scatter charts

Data that is arranged in columns and rows can be plotted as a scatter plot. A scatter chart 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 charts are commonly used to represent and compare numeric values such as scientific, statistical, or engineering data. Scatter plots are recommended when:

It is required to change the scale of the horizontal axis.
It is required to use a logarithmic scale for the horizontal axis.
The values are unevenly located on the horizontal axis.
There are many data points on the horizontal axis.
You want to display data efficiently spreadsheet that contain pairs of grouped value fields, and enter independent scatter plot scales to show additional information about the grouped values.
What is required is not to demonstrate differences between data points, but analogies in large datasets.
You want to compare multiple data points without regard to time - the more data you use to build 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 the weather forecast, you should collect data on the season in column 1 (X-axis), in column 2 (Y-axis) - on temperature. Then, in column 3, a temperature forecast will be built depending on the season.

Stock charts

Stock charts are very useful for displaying price information on an exchange. They require three to five datasets, depending on the subtype. As the name suggests, the stock chart is most commonly used to illustrate changes in stock prices. To create a stock chart, you need to properly order the output data. So, to create a simple stock chart maximum-minimum-close (ceiling-floor-close), you should place the data in columns with headings Maximum, Minimum and Closing in the appropriate order. Suppose you have some stocks and have fixed 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 quotation). You can also build a stock chart based on this data.

Surface charts

Data that is arranged in columns or rows can be plotted as a surface chart. A surface chart is used when you need to find the optimal combinations in two datasets. Surface charts can be used to illustrate categories and datasets 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 in which additional series of data can be represented. This additional data series is displayed as the size of the bubbles. In other words, a bubble chart can display data in the columns of a spreadsheet, with the X-axis being selected from the first column, and the corresponding Y-axis and bubble-sizing values being selected from adjacent columns.

Petal charts

A petal chart has a separate axis for each category, with all axes originating from the center. The value of the data points is plotted on the corresponding axis. If all points in the data series have the same value, then the radar chart becomes a circle. Petal charts allow you to compare the aggregate values of multiple data series and plot the distribution of data by value.

Example 6.1. Create charts in PowerPoint

In PowerPoint applications, you can create a chart by clicking the button 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 the button OK, then the generated diagram will be embedded in Office PowerPoint 2010. This will launch both PowerPoint and Excel () by default.

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

PowerPoint has the following options for changing your chart:

Change the appearance of chart axes... You can specify the scale of the axes and change the spacing between values or categories. For ease of reading, charts can be added on the division axes and the amount of gaps between them can be specified.
New term
Divisions are unit labels that cross the axis and look like ruler tick marks. The tick labels identify the categories, values, and series in the chart.
Adding a Title and Caption to a Chart... You can add a chart title, axis titles, and data labels to clarify the data displayed in a chart.
New term
Data Signature- information on the diagram with additional information about a 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 position. In some charts, you can also display a data table.
New term
Legend- the frame in which the patterns or colors of the series or data categories in the chart are defined.

New term
Data table- a range of cells containing the results of substitution of different values in one or more formulas.
Applying Accessibility to Different Chart Types... Various special lines can be applied with different types of charts, for example, swing corridors and trend lines, bands (for example, up and down bands and error bars), data markers, and so on.
New term
Trend line- graphical representation of the direction of change of a series of data. For example, a rising line indicates an increase in sales over a certain number of months. Trendlines are used to analyze prediction errors, also called regression analysis. As an example, a chart with sales data is shown. The chart shows a trend line with the forecast of sales that can be expected from one of the sellers in the next period. For other vendor data, margin of error is shown.

Rice. 6.9.
Embedding and pasting a chart into a presentation

In Office PowerPoint 2010, you can add a chart or graph to your presentation in two ways.
- Can to introduce diagram into presentation. When you embed data from a chart into PowerPoint, the information can be edited in Office Excel 2010 and the sheet 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 the data in Office Excel 2010. When you copy a chart from Office Excel 2010 and paste it into your presentation, the data in the chart is linked to the Excel sheet. If you want to change the data in the chart, you need to make changes to the linked sheet in Office Excel 2010. The Excel sheet is a separate file and is not saved with the PowerPoint file. A chart with related data is displayed in a table called data table... You can enter data into this table manually, import data from a text file, or paste data copied from another program.

Those who work in Microsoft Office PowerPoint know that, starting with the 2007 version, charts inserted into a presentation are essentially charts created using 2007 spreadsheets. This gives you tremendous control appearance diagrams, in particular, this applies to a huge number of visual effects. appeared in 2007 /

However, few people know that you can diversify the display of an Excel chart in a PowerPoint presentation by adding animation effects. At the same time, the control of animation of the diagram is quite flexible, which allows you to highlight and emphasize individual elements of the diagram, which will undoubtedly improve the perception of the data that needs to be conveyed to the audience of the presentation.

Let's walk you through the steps of how to insert a diagram and bring it to life by adding animation effects. As an example, I used the table of distribution of the share of Internet users in countries, in% of the population from.

1. Insert the chart into the slide.

For the chart, I chose a horizontal grouped cylinder chart. The choice is explained primarily by the fact that the source of information, the study of the Public Opinion Foundation, also uses this type of chart to display this data.

After inserting a chart into a slide in a PowerPoint 2007 presentation, another window opens - an Excel 2007 spreadsheet, from which data is taken to display in a chart on a slide. By default, it is filled with some kind of nonsense, which we only need to see how the diagram will look on the slide. Replace this data with your own. Pay attention to the signatures in the signature column, and data in the data column. Of course not a big problem then tell the Excel 2007 table where to get the data and labels for the chart - but why do we need extra work ?! Do not delete the entire data - along with the data, the chart plotting range will also be deleted, and you will have to mark it up again.

After inserting the data, adjust the data range to build the chart. to do this, drag a square in the lower right corner of the blue frame, placing it in the lower right corner of your range. The box should contain the labels of the categories (countries) and a column of numbers indicating the proportion of users. Do not forget to change the category labels (the first row of the table - this can help in creating a beautiful legend for the diagram.

As soon as you add data, it is immediately displayed in the chart.

The chart is formatted as usual Excel chart 2007.

You will get something like this:

Not bad, but for some reason Brazil was at the top, being the last in the table. the leader, Australia, on the contrary, moved down. This is because in the horizontal chart we used, the categories follow a vertical axis from bottom to top, as is common in mathematics. Let's change this order.

Right-click on the Y-axis labels (list of countries) and select "Axis format", and then check the "Reverse order of categories" checkbox.

The diagram is clearly better. Now I want to highlight the line with Russia. To do this, select the cylinder with data for Russia and from the context menu select "Data point format", specifying a different fill option for this data point:

2. Add animation to the diagram

On the "Animation" tab, select "Animation Settings"

The Animation Settings panel opens on the right side of the screen. If the Add Effect button is not active, it means that no objects were selected on the slide. Anamation can be configured for any object on a slide, or for a group of objects. For example, you can animate the entire diagram, or you can animate only individual points to which you want to draw attention. Click on the column showing the data for Russia so that only it remains highlighted.

Selected "Add Effect" - "Input" - "Rectangle"

By default, animation is applied to the entire chart, so let's set up animation effects for the chart. To do this, open the list of settings for the selected animation effect and select "Effect Parameters".

On the "Chart animation" tab, select one of the grouping modes:

The following effects are possible for grouping objects when animating a diagram:

As one object - the animation is applied to the entire diagram;
By Rows - Adds each data series to the chart one at a time. For example, if you have a bar chart showing quarterly sales by region, you can display bars by quarter over a specific period of time;
By Category - Adds each data category to the chart one at a time. For example, if you have a bar chart showing quarterly sales by region, you could display the bars by region over a period of time;
by series elements - adds one marker in each series to the chart. For example, if you have a bar chart showing quarterly sales by region, you could display bars for each region, one quarter over a period of time;
by category elements - adds a marker for each category to the chart one at a time. For example, if you have a bar chart showing quarterly sales by region, you could display bars for each quarter, one region over a period of time.

Note that if you chose to group by elements, then to the left of the diagram, animation numbers for each of the elements are shown.

By choosing the appropriate number, you can simply delete the animation of the elements you do not need in the list on the right to leave only what you need. You can also adjust the speed and other animation effects for each of the elements.

3. A final remark.

Be careful when choosing an animation effect for your chart: not all effects support separate animations for series, categories, and chart elements. For example, you can use the Bounce and Creep effects to animate only the entire diagram. If you want to use a specific effect that does not support animation of the chart components, you need to ungroup the chart and work with its components directly.

In order to talk about any phenomenon or proposal, in most cases, use electronic presentations... The purpose of the presentations is to draw the attention of the audience to the report with the help of colorful pictures, diagrams, tables, graphs.

Escort oral speech presenter's colorful pictures and tables included in the presentation slides greatly simplifies the understanding of the material presented. This also applies to charts and graphs, with the help of which you can, for example, show a change in a phenomenon or a comparison of data.

Despite the fact that the creation of tables and graphs is a specialization of the Excel application, the MS Power Point program also implements the ability to insert a variety of diagrams. Moreover, you can insert diagrams into a presentation not only through the clipboard.

You can simply insert a diagram into a presentation, in the insert tab you need to find the illustration block and click on the "Diagram" button. In the "Insert Chart" window that opens, select the type of chart required for this case. After clicking OK, the selected chart type will be inserted into the slide and an Excel window will open for entering data.

In the working area of slides, as a rule, there are links for inserting various objects, including diagrams. The presence of these links somewhat simplifies and speeds up the access to the window for inserting diagrams.

The chart insertion window can be called by pressing the corresponding button in the slide field

In order for the diagram in the presentation to be beautiful and understandable, you need to correctly fill in the data table for it, correctly sign the categories and series. You may need to change the chart type for this, which can be done right in Power Point.

You can change the chart type right in the slide designer

In the case when a presentation is drawn up on the basis of a ready-made report made in the Word editor, or the data for charts are available in Excel files, then our task is greatly simplified. This is due to the fact that the source documents already have ready-made diagrams, and we just have to transfer them to the presentation using.

It is done very simply: select the desired diagram in the source document and copy it to the clipboard. Then open the presentation slide and click "paste". If you later need to make changes to the chart, you need to link it to the original Excel file.

Paste the diagram previously copied to the clipboard by clicking this button

Data for the chart

Anyone who has ever tried creating charts in office applications knows that a chart is only a visual representation of the digital data that is recorded in a table. And, in order to change the diagram, you need to make changes to this original table.

Changes to the data of this table will immediately appear on the diagram.

You can open the table with the initial digital data by selecting the diagram with a mouse click and in the appeared tab "Constructor" click "Change data". Or call the drop-down menu by right-clicking in the diagram area. In the window that appears, you also need to select "Change data". Which of these two methods to use depends on the tastes and habits of each user when using the computer.

Data change

If a diagram is inserted into your presentation using the clipboard and you may need to change the data for the diagram, then, as mentioned above, you need to establish a link between the pasted diagram and the original file.

This link is established as usual from a diagram located in the presentation to an Excel file with a data table. After that, the opening of the original table is carried out in the same way as described above - by clicking the "Change data" button.

Linking the chart to the Excel file containing the original data

Thus, creating a visual diagram in a Power Point presentation is very easy, but the process is not complete without Excel. Therefore, for the convenience of inserting diagrams into Power Point, this table processor must be installed on the computer.

Surprisingly, the Gantt chart, which is one of the most well-known and used types of charts for management planning, is not present in PowerPoint. Recall that the Gantt chart belongs to the strip chart types that help graphically display an action plan for tasks and deadlines. This is why Gantt charts are often used when creating work projects.

However, Microsoft Office did not ignore this tool, including it in the program. Microsoft Project... You can take a screenshot (snapshot) of the diagram and paste it into PowerPoint. In some cases, this is a perfectly valid option, but it will not be possible to edit this information in PowerPoint.

In addition, presentations usually require very little data, otherwise there is a risk of overloading the slide with information and it will be difficult for participants in the presentation. Accordingly, it is quite possible to do without Project and make a Gantt chart in PowerPoint. For the sake of fairness, we must admit that the information is edited by means of Excel, in which it will be necessary to perform some subsequent actions.

How to build a Gantt chart - stages.

In Microsoft PowerPoint

Insert chart. To do this, use the command of the same name on the control ribbon, or the "Diagram" icon on a new slide.
Select the "Stacked Bar" chart type. A chart is added to the slide and Excel is displayed on the screen at the same time as PowerPoint.

Gantt chart in Excel

Reduce the number of columns in the table, remove row 3 as unnecessary.
Instead of the "Category" names, enter the names of the project (plan) tasks.
The Row 1 column is the start date of the tasks. In it, you need to set the appropriate digital indicators. For example, the ordinal month of the start of the task if months are a time criterion.
The Row 2 column indicates the duration of the task. Indicators must be specified. The units of measurement for all tasks must be the same.
Close Microsoft Excel.

In Microsoft PowerPoint (continued)

Select the first row of data and use the context menu to change the appearance, making it invisible. Those. it is necessary to execute: "Data series format", "Fill" - "No fill", "Border color" - "No lines".
Activate the chart and go to the "Layout" tab. Here you can adjust the display of captions.
Select "No" via the "Chart Title" button, since the title will be displayed in the title of the slide.
Add the names of the horizontal and vertical axes through the "Axis titles", if necessary.
Other settings that can be applied: Legend - None, Data Table - None.

It might be helpful to read: