The perfect combination of Excel and chart slides

The new year began, many friends not only to prepare a New Year's work plan, but also to do a year's summary report, with what can be more accurate and intuitive performance of these content? Of course, the chart slides, so you can use the modern projection equipment side presentation, vivid and persuasive.

It's easy to make a chart slide with PowerPoint, but it's a big headache to enter the data used in the chart. One is that we have raw data, again input data seems a little waste of time, and then a data table here processing data is not as convenient as Excel tables, there is no way to directly use the data in Excel tables to create a chart? There, we can use the two methods described below to avoid cumbersome and repetitive input process.

First, copy data directly into PowerPoint

To create a chart directly from the raw data in Excel, you must have a raw data file, and then do the following:

First step: Open PowerPoint, click Insert/Chart to insert a chart slide and PowerPoint will automatically insert an instance of a chart, just click on the "Edit/import File" on the toolbar and a "Enter Data Options" dialog box pops up (Figure 1). Select the worksheet you want to make a picture of. If you want to import only part of a worksheet, click the radio button in front of the selection, and in the following text box, enter the area you want to import. For example, we want to import the first two columns of a worksheet (10 data for the entire worksheet), which means "a1:b10." One thing to note here is that the selection must be a contiguous cell or row, and then "overwrite the contents of an existing cell" and click the "OK" button.

Figure 1

Step Two: When we import the data according to the above methods, we may find that the chart in the slide is far from what we asked for, such as all the columnar graphs are shrunk together (Figure 2), which requires us to adjust appropriately. You can see from the observation that a column in the datasheet is preceded by a column, this is used to display the data for the axis, select it and click Edit/Remove to delete it, so that the data series is displayed exactly in the middle of the chart, and then we should also delete the extra blank rows in the datasheet. Then click the menu "Data/Column series", so that the chart sorted by column, how, the overall effect has come out (see Figure 3)!

Figure 2

Figure 3

Create a link between Excel and PowerPoint datasheet

The action above is to copy the data in Excel directly into the datasheet on the slide, then change the data in Excel, and the chart slides won't change, so how do you make the chart change with the Excel data? We can do this by creating a link between Excel and the PowerPoint datasheet so that when the source data changes, it can be displayed immediately on the chart slide, as follows:

First select the range of data in Excel that you want to connect to the datasheet in PowerPoint, click Edit/Copy on the menu.

Then create a new PPT document and click Insert/Chart to insert a chart slide, and empty the pop-up data table input box all the data, and then click the Menu "Edit/Paste Link", the data in Excel will appear in the datasheet, other methods and the same as the first.

Later, if we change the data in Excel, the data in the datasheet in PowerPoint changes as well, and the chart changes accordingly. Using the above two methods can be removed from our repeated input of the pain, the need for such a friend may wish to try.

Tip: This hyperlinked chart method requires that the path to the Excel document and its corresponding PPT document not be changed, or the PPT document will not update the data with the changes to the Excel file.