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.

    Downloadable PowerPoint Templates and Toolkits

    Your personal database of slide templates to use in any project

    PowerPoint Elements, Shapes, Graphics & Icons Pack
    Slide Templates

    PowerPoint Elements, Shapes, Graphics & Icons Pack

    Over 500+ slide elements: arrows, cycles, pyramids, flows, categories, timelines, charts, jigsaws, cogs and wheels, maps, icons and more!
    View Shapes Pack →
    Corporate & Business Strategy Consulting Toolkit
    Slide Templates

    Market & Competitor Analysis Template Pack

    37 templates for market sizing, segmentation, forecasts, trends, competitor analysis, product comparisons, and more!
    View Analysis Templates →
    Organizational Design and Operating Model Toolkit
    Slide Templates

    Value Proposition & Go-To-Market Template Pack

    Templates for product development, product positioning, roadmaps, pricing strategy, distribution models, and more!
    Coming Soon