What happens once the Insert tab is used in PowerPoint to insert a chart?
If needed, to edit the chart’s data again, select the chart. Then click the “Edit Data” drop-down button in the “Data” button group on the “Chart Design” contextual tab of the Ribbon. Then select either the “Edit Data” command to edit the data in the Excel worksheet in PowerPoint or the “Edit Data in Excel” command to edit the chart’s data directly in Excel. After making your changes, then close the workbook again.
Show
A survey is a technique that is applied by conducting a questionnaire to a significant sample of a group of people. When we carry out the survey, we start from a hypothesis and it is this survey activity that will allow us to confirm the hypothesis or to see where the problem and solution of what we are investigating lies.We know: fieldwork is hard work. Many hours collecting data, analyzing and organizing it until we have our survey results.Well, we don't want to discourage you (at Slidesgo we stand for positivism) but this is only 50% of the survey work.... If you have already created a chart in Excel, you can embed and link it to your PowerPoint presentation. When you embed an Excel chart in PowerPoint, any updates you make to the original Excel chart will automatically update in your presentation, as long as the files remain in the same location. This helps the data stay in sync, so you won't have incorrect or out-of-date information in your chart. To embed a chart from Excel:
To edit an embedded chart, double-click the chart. An Excel spreadsheet containing the chart's source data will appear. After you have finished editing, be sure to save the chart in Excel. Once you have embedded a chart, be careful not to delete or move the original Excel file. If the location of either the PowerPoint presentation or the Excel file changes, you may have to embed the chart again in order for it to display correctly. A chart is a tool you can use to communicate your data graphically. Displaying charts in PowerPoint allows your audience to see the meaning behind the numbers, and it makes showing comparisons and trends much easier. In this lesson, you will learn how to insert charts and modify them so they communicate information effectively. In many ways, charts are an ideal way to present information in PowerPoint 2010. They give you an illustration of your data. A chart can help you show your audience what your data means and why it's important. Plus, they can add visual interest to slide shows that are otherwise filled with text. To use charts effectively, you'll need to know how to insert and modify them. Optional: You can download this example for extra practice. Types of chartsClick the arrows in the slideshow below to view examples of some of the types of charts available in PowerPoint.
Identifying the parts of a chartClick the buttons in the interactive below to learn about the different parts of a chart. Horizontal AxisThe horizontal axis, also known as the x axis, is the horizontal part of the chart. In this example, the horizontal axis identifies the categories in the chart, so it is also called the category axis. However, in a bar chart, the vertical axis would be the category axis. LegendThe legend identifies which data series each color on the chart represents. For many charts it is crucial, but for some charts it may not be necessary and can be deleted. In this example, the legend allows viewers to identify the different book genres in the chart. Data SeriesThe data series consists of the related data points in a chart. If there are multiple data series in the chart, each will have a different color or style. Pie charts can only have one data series. In this example, the green columns represent the Romance data series. TitleThe title should clearly describe what the chart is illustrating. Vertical AxisThe vertical axis, also known as the y axis, is the vertical part of the chart. In this example, a column chart, the vertical axis measures the height—or value—of the columns, so it is also called the value axis. However, in a bar chart, the horizontal axis would be the value axis. Inserting chartsPowerPoint uses an Excel worksheet as a placeholder for entering chart data. Therefore, when you insert or edit a chart in PowerPoint, an Excel window will automatically open. The process is user-friendly, but if you are totally unfamiliar with Excel, you might want to review our Cell Basics lesson from our Excel 2010 tutorial. To insert a chart:
If a slide layout has a content placeholder, you can also click the Insert Chart command to insert a new chart. Inserting a chart in the placeholderTo enter chart data:The data that appears in the Excel spreadsheet is placeholder source data that you will replace with your own information. The Excel source data is used to create the PowerPoint chart. The placeholder source data and the corresponding chart
You can edit the chart data at any time by selecting your chart and clicking the Edit Data command in the Data group on the Chart Tools Design tab. The Edit Data commandCopying and pasting existing Excel dataIf you already have an Excel worksheet with data you want to use for a PowerPoint chart, you can transfer the data by copying and pasting it. When the Excel window opens, open your existing worksheet, select and copy the data, and paste it into the worksheet in place of the placeholder data. Be sure to drag the blue line to surround all the data you want to include in the chart. Importing a chart from ExcelIf you have already created a chart in Excel, you can import and link it to your PowerPoint presentation. When you insert an Excel chart in PowerPoint, any updates you make to the original Excel chart will automatically update in your PowerPoint presentation, as long as the files remain in the same location. This can be a convenient and time-saving feature for presentations that require frequent updating.
To edit an imported chart, double-click it to open the Excel placeholder. After you have finished editing, be sure to save the chart in Excel. Once you have imported a chart, be careful not to delete or move the original Excel file. If the location of either the PowerPoint presentation or the Excel file changes, you may have to insert the chart again in order for it to display correctly. Modifying charts with chart toolsThere are many ways to customize and organize your charts. For example, PowerPoint allows you to change the chart type, rearrange a chart's data, and even change the layout and style. Once you insert a chart, a set of chart tools will appear on the Ribbon. These are only visible when the chart is selected. You can use the three tabs grouped under Chart Tools to modify your chart. The Chart Tools tabTo change the chart type:
To switch row and column data:Sometimes when you create a chart, the data may not be grouped the way you want it to. In the clustered column chart below on the left, the Book Genre Sales statistics are grouped by genre, with a column for each year. However, you could also switch the row and column data so the chart will group the statistics by year, with columns for each genre, as in the chart on the right. In both cases, the chart contains the same data; it's just organized differently. Sales Chart before and after switching row and column data
To change the chart layout:
Some layouts include things like chart titles and legend labels. To change them, place the insertion point in the text and begin typing. What happens when you go to insert chart in PowerPoint?To create a simple chart from scratch in PowerPoint, click Insert > Chart and pick the chart you want. On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, click the arrows to scroll through the chart types. Select the type of chart that you want and then click OK.
What opens up with the chart when inserted into a slide?Inserting charts. PowerPoint uses an Excel worksheet as a placeholder for entering chart data. Therefore, when you insert or edit a chart in PowerPoint, an Excel window will automatically open.
What does Insert tab contains in PowerPoint?On the INSERT tab, you can add pictures, shapes, SmartArt graphics, charts, and more to get away from a presentation full of bullet points.
Which tab appears automatically after inserting a table in PowerPoint 2010?After inserting a table in PowerPoint 2010,Chart button is present on the Table tab appears automatically.
|