How To Change Chart Types In Think-Cell

In this tutorial, we’ll show you how to change chart types in think-cell without having to re-build the chart. There are four situations that we cover:

  1. Switching between stacked, clustered, line charts, and area charts
  2. Switching between columns and line series within a chart
  3. Switching between column and bar charts
  4. Switching between other chart types

Switching between stacked, clustered, line, and area charts

Changing between stacked and clustered segment charts, line charts, and area charts in think-cell

You can very easily change between stacked column/row charts, clustered column/row charges, line charts, and area charts in think-cell.

Simply left-click on the chart, then you’ll see a blue border around the chart and a toolbar will appear. Toward the bottom of the toolbar, you can select the chart type you’ll like to convert to.

Free Download: Consulting Presentations

Download 120+ strategy consulting presentations for free

Looking for slide inspiration? Download 120+ consulting slide decks from top strategy consulting firms!

Switching between columns and line series within a chart

Changing series types in think-cell

Think-cell also allows you to change a series within a chart. This allows you to quickly change a column chart or bar chart into a combo chart.

To change the series types in think-cell, simply click on the series. You’ll see a floating toolbar appear. You can then select the chart type that you’d like for that series.

This screenshot looks similar to the first screenshot above. However, you’ll notice that there’s no blue border around the entire chart in this case. This is because we’ve selected the series and not the overall chart.

Switching between column and bar charts

Changing between column charts and bar charts in think-cell

Finally, you can very quickly change between column charts and bar charts in think-cell.

First, left-click on the chart, and you’ll see a blue border around the chart and a “pivot anchor” at the top of the chart. Click on the pivot anchor and drag it to the right or left to rotate the chart.

This can also be done with Mekko and Waterfall charts.

Switching between other chart types

If the three options above don’t solve your problem, then you might need to recreate the chart from scratch.

In this case, don’t delete the original chart. Keep the original chart and create a new chart beside it. Then try copying and pasting the data from the original to the new chart.

In some cases, you might have to adjust the format of the data. But in other cases, you can simply paste the data in the new chart and you’re good to go.

Best Selling Courses, Toolkits and Templates

Trusted by thousands of executives, consultants and freelancers

Value Proposition & Go-To-Market Toolkit
Toolkit

Product Value Proposition & Go-To-Market Toolkit

107 PowerPoint Slides | 23 Excel Sheets
$199
Course

The Executive-Ready Slide Decks Course

20 Lessons | 1.5 Hours of Content
$149
Toolkit

Product Development Toolkit

63 PowerPoint Slides | 8 Excel Sheets
$89