How to quickly create and update charts in PowerPoint | think-cell (2024)

In this chapter, a step-by-step tutorial will show you how to create a chart from a scribble like this:

How to quickly create and update charts in PowerPoint | think-cell (1)

A more elaborate presentation of the basic concepts of think-cell and details on the various chart types can be found in 3. Basic concepts and in the following chapters.

Contents

4.1
Inserting a new chart
4.2
Adding and removing labels
4.3
Entering chart data
4.4
Styling the chart

4.1 Inserting a new chart

With think-cell installed, you will find the following group in the Insert tab of PowerPoint’s ribbon.

How to quickly create and update charts in PowerPoint | think-cell (2)

Inserting a chart into your presentation is very similar to inserting a PowerPoint shape. Go to the think-cell group and click the Elements button. Then, select the required chart type.

In our example, we want to insert a column chart, which is represented by this button: How to quickly create and update charts in PowerPoint | think-cell (3)

Once you have chosen a chart type, a rectangle will appear with the mouse pointer, indicating where the chart will be inserted on the slide. When you are inserting or resizing a chart, you will notice that it snaps to certain locations, aligning with existing objects on the slide.

How to quickly create and update charts in PowerPoint | think-cell (4)

The chart is automatically selected after insertion, as indicated by a blue highlighted outline. If a chart you want to modify is not selected, you can select it by clicking on it.

4.2 Adding and removing labels

After inserting a new column chart, both category labels and series labels are shown automatically. There are several ways to remove and add labels. The easiest way to remove a single label is to select it and press the Del key. The easiest way to remove all labels of a particular type is to select the respective button from the chart’s context menu.

To remove the series label like in our example column chart, click How to quickly create and update charts in PowerPoint | think-cell (5) Remove Series Label in the chart’s context menu. To access the context menu of a chart, move the mouse to a point within the chart’s rectangle where there are no other objects and click the right mouse button. Read more about editing text labels in the chapter 6. Text labels.

How to quickly create and update charts in PowerPoint | think-cell (6)

4.3 Entering chart data

When you select the column chart, a datasheet button How to quickly create and update charts in PowerPoint | think-cell (7) Open Datasheet is displayed in the bottom right corner of the chart.

Click the datasheet button, or simply double-click the chart, to open the datasheet. The datasheet opens automatically after insertion of a new chart. Now, enter the data from our example column chart into the datasheet. Type in only the actual numbers. Do not round numbers or calculate totals—think-cell will do this for you. For most chart types, you can simply input the numbers the way you see them in the scribble, from left to right and from top to bottom. The tab key Tab can be used, just as in Microsoft Excel, to conveniently move to the next column in a row, and the enter key Enter can be used to jump to the first column of the next row.

The datasheet for our example column chart looks like this:

How to quickly create and update charts in PowerPoint | think-cell (8)

Note that the chart on the slide instantly updates to reflect the changes in the datasheet. It even grows and shrinks depending on the area of the datasheet that you use. Years are automatically inserted as category labels in the first row of the datasheet. The sequence of years is automatically continued when you start entering data in the following column.

Having entered the data, our example chart looks like this:

How to quickly create and update charts in PowerPoint | think-cell (9)

As you can see, think-cell has already performed a good deal of work to make the chart look “right.” In particular, it automatically placed all labels and added column totals. The next section explains the last few steps to finish our example chart.

4.4 Styling the chart

Every chart element consists of a number of features. In our example, text labels and column segments are the most important features of the column chart. Each kind of feature has a number of specific properties that you can change in order to give it a different look. To change a feature’s properties, you have to select it first. You can also select multiple features at a time to change their properties together.

Selecting features is very similar to selecting files in the Windows Explorer:

  • Select a single feature by clicking on it with the left mouse button.
  • Or select multiple features by holding down the Ctrl key while clicking.
  • You can also select a contiguous range of features by holding down the Shift key, moving the mouse pointer and then clicking with the mouse. Watch how the affected features highlight while you move the mouse with the Shift key held down.

The following screenshot shows how all column segments of the second data series highlight in orange while they are collectively selected in a Shift-click operation:

How to quickly create and update charts in PowerPoint | think-cell (10)

When you select features, a floating toolbar containing the corresponding property controls will appear. For the selection of column segments as illustrated above, for example, the Fill Color control becomes available in the toolbar:

How to quickly create and update charts in PowerPoint | think-cell (11)

In our example, we want to change the shading of the second data series, as required by the scribble. Therefore, after selecting the column segments of the series, we choose Accent6 shading:

How to quickly create and update charts in PowerPoint | think-cell (12)

Note that the labels automatically turn white to make them easier to read on the dark background.

Finally, the numbers in our example chart are still displayed with incorrect precision. According to the scribble, they should be rendered with one decimal place precision. We simply have to select one of the segment labels, and the floating toolbar changes to include the Number Format control:

How to quickly create and update charts in PowerPoint | think-cell (13)

By typing the decimal place into the number format box, you can specify the desired display format and it will be applied to all numbers of the same type in the chart. Alternatively you can click on the arrow and select the desired format from the drop down box. Note that the actual numbers you type or select do not matter, they only act as an example of the required formatting (read more in section 6.5.3 Number format).

How to quickly create and update charts in PowerPoint | think-cell (14)

The scribble is now represented by a clear, professional looking chart. As you become familiar with using think-cell, you will be able to create a chart like this in less than one minute.

How to quickly create and update charts in PowerPoint | think-cell (2024)

FAQs

How to quickly create and update charts in PowerPoint | think-cell? ›

With think-cell

think-cell
think-cell helps you create stunning charts in minutes, boosts your slide layout and automates your regular reports. And all this with a single PowerPoint add-in.
installed, you will find the following group in the Insert tab of PowerPoint's ribbon. Inserting a chart into your presentation is very similar to inserting a PowerPoint shape. Go to the think-cell group and click the Elements button. Then, select the required chart type.

How do I update data in a chart in PowerPoint? ›

Under Chart Tools, on the Design tab, in the Data group, click Edit Data. Do one of the following: To edit data in PowerPoint, select Edit Data. This will open a window from your spreadsheet.

How do I refresh the think-cell chart in PowerPoint? ›

Set your Think-Cell chart to update automatically

By default, your chart will be set to update manually. You need to set it to update automatically. To do this, left-click on the chart and then click the icon that says 'Update Automatically'. This button looks like a circular refresh arrow.

What are the four steps for creating a chart in PowerPoint? ›

Try it!
  1. Click Insert > Chart.
  2. Click the chart type and then double-click the chart you want. ...
  3. In the worksheet that appears, replace the placeholder data with your own information.
  4. When you insert a chart, small buttons appear next to its upper-right corner. ...
  5. When you've finished, close the worksheet.

Can multiple charts be created at one time? ›

Hi, Multiple charts can be created in a sheet, but there are restrictions on the number of charts that can be placed in the same sheet. For example, the chart below includes an area chart, a bar chart, and a line chart. You can create charts with one column and multiple rows, or vice versa.

How do you update a chart to include new data? ›

On the worksheet, in the cells directly next to or below the source data of the chart, type the new data and labels you want to add. Click the chart sheet (a separate sheet that only contains the chart you want to update). On the Chart Design tab, click Select Data.

How do I update a table in PowerPoint? ›

In PowerPoint, right-click the data and select Update Link.

What option can we use to update the data Format in chart? ›

Format your chart using the Format task pane

If you click on a different chart element, you'll see that the task pane automatically updates to the new chart element. For example, to format an axis: Right-click the chart axis, and click Format Axis. In the Format Axis task pane, make the changes you want.

How do I update a chart in PowerPoint org? ›

Click a shape in the org chart and when SmartArt Tools appear on the ribbon, click either the Design or Format tab. Add more shapes to your org chart (to contain more names) or move shapes around in the Create Graphic group. Change the style of the org chart in the SmartArt Styles group.

How do I refresh an Excel chart embedded in PowerPoint? ›

Right-click the embedded Excel object in PowerPoint, then select "Update Link" or "Refresh Data" to refresh it.

How do you edit multiple PowerPoint slides at once? ›

To make changes to all slides:
  1. Select the View tab, then click the Slide Master command.
  2. The presentation will switch to Slide Master view, and the Slide Master tab will be selected on the Ribbon.
  3. In the left navigation pane, scroll up and select the first slide. ...
  4. Make the desired changes to the slide master.

How do you change multiple shapes at once in PowerPoint? ›

To change multiple shapes, press and hold Shift while you click the shapes that you want to change. For more information about selecting shapes, see Select a shape or other object. Under Text Box Tools, on the Format tab, in the Text Box Styles group, click Change Shape, and then click the shape that you want.

How do you edit simultaneously in PowerPoint? ›

Share your presentation with others and collaborate on it at the same time
  1. Open your PowerPoint presentation, and at the top-right corner of the ribbon, select Share. and then select Invite People. ...
  2. Enter the email address of the person you'd like to share the presentation with. ...
  3. Click Share.

How do I update all links in a PowerPoint? ›

You can set all links to update automatically though. If you do this, they'll update whenever you open the presentation in PPT. Go to FILE | INFO then click "Edit links to file" on the right side of the screen.

Top Articles
Can PTO Be Denied? Tips for Handling Vacation Requests
7 Smart Tips to Avoid Checked Baggage Fees Every Time You Fly
Navicent Human Resources Phone Number
Washu Parking
Toyota Campers For Sale Craigslist
Ashlyn Peaks Bio
Beds From Rent-A-Center
Craigslist Phoenix Cars By Owner Only
Select Truck Greensboro
Nexus Crossword Puzzle Solver
Ladyva Is She Married
Thotsbook Com
Assets | HIVO Support
Lax Arrivals Volaris
Viprow Golf
Haunted Mansion Showtimes Near Millstone 14
Vrachtwagens in Nederland kopen - gebruikt en nieuw - TrucksNL
Ms Rabbit 305
China’s UberEats - Meituan Dianping, Abandons Bike Sharing And Ride Hailing - Digital Crew
Td Small Business Banking Login
Pearson Correlation Coefficient
Employee Health Upmc
Shoe Station Store Locator
Kroger Feed Login
Rugged Gentleman Barber Shop Martinsburg Wv
Scott Surratt Salary
Expression Home XP-452 | Grand public | Imprimantes jet d'encre | Imprimantes | Produits | Epson France
Best Town Hall 11
Osrs Important Letter
My Dog Ate A 5Mg Flexeril
Boneyard Barbers
Murphy Funeral Home & Florist Inc. Obituaries
Hypixel Skyblock Dyes
Hair Love Salon Bradley Beach
Craigslist Neworleans
Sam's Club Gas Prices Florence Sc
Indio Mall Eye Doctor
Best Restaurants Minocqua
Flipper Zero Delivery Time
Top 40 Minecraft mods to enhance your gaming experience
My Eschedule Greatpeople Me
Eat Like A King Who's On A Budget Copypasta
Accident On 40 East Today
Hello – Cornerstone Chapel
Sams Gas Price San Angelo
Iron Drop Cafe
Colin Donnell Lpsg
Noelleleyva Leaks
Frank 26 Forum
O'reilly's Eastman Georgia
Latest Posts
Article information

Author: Rueben Jacobs

Last Updated:

Views: 6109

Rating: 4.7 / 5 (77 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Rueben Jacobs

Birthday: 1999-03-14

Address: 951 Caterina Walk, Schambergerside, CA 67667-0896

Phone: +6881806848632

Job: Internal Education Planner

Hobby: Candle making, Cabaret, Poi, Gambling, Rock climbing, Wood carving, Computer programming

Introduction: My name is Rueben Jacobs, I am a cooperative, beautiful, kind, comfortable, glamorous, open, magnificent person who loves writing and wants to share my knowledge and understanding with you.