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.

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.