For a detailed description on how to place, resize and align a new chart, please refer to Inserting a new chart.Īfter insertion, the chart looks and behaves like a regular think-cell chart that has been created in PowerPoint. Switch to the slide where you want to insert the chart, or insert a new slide, and place the chart as usual: Click once to accept the default size or click, hold and drag to change the chart’s initial size. In PowerPoint, when the mouse pointer is on a slide, the familiar insertion rectangle appears.

If PowerPoint is not yet running, it starts automatically.

When you click on this menu item in Excel, the PowerPoint window is activated. Now select the desired chart type, in our case a Stacked Column chart, from the Link To PowerPoint menu in Excel’s think-cell toolbar:

But it is not strictly necessary, as the interpretation of a linked range of cells can be modified as explained in Fitting the data layout. This is the easiest case, as a link will initially be created using the default data layout for the selected chart type. The range we selected in our example perfectly fits the default datasheet of a Stacked Column chart, with rows representing series, columns representing categories, category labels in the first row, a second row where a value representing 100% would go, and a first column where series labels would go. To create the chart from Excel, select the desired data range in your Excel workbook, including series (in our example empty) and category labels: Let's say you want to recreate the example chart from Introduction to charting, but instead of entering the data into the internal datasheet in PowerPoint, you want to use it directly from an Excel sheet. 21.1 Creating a chart from Excel 21.2 Fitting the data layout 21.3 Updating a linked element 21.4 Creating a table from Excel 21.5 Creating Text Linked to Excel 21.6 Data Links dialog 21.7 Maintaining data links 21.8 How to compile the data 21.9 Frequently asked questions 21.1 Creating a chart from Excel When data in Excel changes, you can either update the charts on command or have think-cell do the update automatically. When the source data for your data-driven charts is available in Excel, you can create charts directly from the Excel application.

Think cell cracked