Dynamically change the fill color of a Think-Cell chart

In this tutorial, we will show you how to dynamically change the fill color of a think-cell chart based on data in Excel.

Step 1. Highlight your Excel data and insert a Think-Cell chart

Dynamically fill a think-cell chart using Excel data. Step 1: Add a chart in Excel

First, ensure that your data is formatted the same way that it would be formatted in Think-Cell. Then highlight the data in Excel, navigate to Insert > Elements, then select the chart type.

Your data now has an orange background, which looks a lot like the formatting in a Think-Cell chart, and your PowerPoint window will now have appeared.

Simply insert the chart on your canvas. This will look just like a standard Think-Cell chart but (behind the scenes) it is connected to your data in Excel.

Step 2. Set your Think-Cell chart to update automatically

Dynamically fill a think-cell chart using Excel data. Step 2: Set chart to update automatically

Left-click on the chart, then click on the button that says Update Automatically. This button looks like a circular arrow and appears toward the bottom of the formatting popup box, just above the field to update your chart name.

Now your Think-Cell chart values should change when the data in Excel changes. Test this by jumping into Excel and playing with the numbers.

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!

    Step 3. Change your chart theme to use ‘Excel Fill On Top’

    Dynamically fill a think-cell chart using Excel data. Step 3: Set theme to inherit fill from Excel

    Next, we need to tell Think-Cell to use the cell fill color in Excel as the chat fill color in Think-Cell.

    To do this, left-click on the chart, then from the dropdown, select the theme that says Use Excel Fill on Top.

    Step 4. Add conditional formatting your Excel data cells

    Dynamically fill a think-cell chart using Excel data. Step 4: Add conditional formatting to Excel cells

    Finally, you need to navigate to Excel and add a conditional formatting rule that changes the cell fill colors dynamically.

    Importantly, you cannot use any conditional formatting rules that reference another cell or that is calculated dynamically across multiple cells.

    In my experience, the most effective conditional formatting to use for this is the ‘Format Only Cells That Contain’ rule. Just remember, when you use this rule make sure your number references a typed-in number and not another cell.

    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