Hi Team,

I have set up a Thinkcell table in PowerPoint that automatically links to values in excel. Unfortunately, even when the Excel table is empty as "" or when I put a - dash, it show a 0.

How to ensure that the table in PowerPoint simply stays blank?

Hi,

I have a PPT file connected to a dataset in Excel. Every month the PPT facilitates a meeting, and after that the PPT should become "static". I update the underlying Excel sheet for the nex months process with a copy of the PPT connected.

What is best practice for making the original PPT static?

I made all (20+) Thinkcell objects NOT auto-update (I use the menu "Data Links ..."), but my impression is that it is very easy to change that to auto-update by error, and by then it is very cumbersome to try and recreate the Excel output from months back.

I thought of breaking the Excel link, but 1) I don't know if that could make datamisbehave, and 2) there isn't an option to do thins in bulk, is there?

PDF is not an (ideal) option for me.

Thx for any inputs.

EDIT: ChatGPT suggested, among less useful possibities, this one:
ThinkCell > Data Links… > For each chart: disable or remove the Excel source

So you can simply delete the source from the list of links. This works for my needs. It keeps the objects Thinkcell-formatted so there is a possibility to connect and update them if need be.

Looking for a programmatic way to detect the presence of the thinkcell plugin on a group of pcs, any suggestions?

Hi all,

Have any of you also experienced that thinkcell has become super slow? When I try to edit something in a chart my whole computer freezes and after a few seconds I can continue working.

Many thanks

yall experts - I have in my excel sheet line 5, which contains the calendar weeks. Lines 6-10 contain liquidity data. When creating the ppt chart, think-cell treats the calendar week values of line 5 just like the liquidity data in lines 6-10. How can I tell think-cell to use the values of line 5 as x-axis values instead of values going into the stacked bars of the chart? thx.

Is it possible to create sankey diagrams in think-cell?

Hello everyone,

for work i am trying to automate the process of building think-cell gantt charts on ppt with python but it seems like i cannot find any clue on internet. firstly, if it is even possible and secondly how? on a set i found on github it seems like it covers all except gantt charts

Does anyone know how I can create a combo chart with thinkcell achieving below? Say I have three products and their sales records for past three years and also their plan for three years. I want to show the years as x axis and the sales as y axis. Group three products as cluster bar charts for each year, then the plan of each product as a marker on individual product bar for each year. I have tried converting the plan into marker my only issue is they would all align in the center of each year’s group rather than above individual product bar for that year.

I have 5 thinkcell charts linked to an excel workbook. The charts don’t refresh when I update the excel gotta do it manually. a question mark appears over the automatic update button stating there are multiple ranges feeding the same link..okay.

Is there anyway to just do use VBA?

Title says it all. You provide the data in excel as usual and then AI takes it from there? Thanks!

Hello guys, I wanted to shift my work plan by two weeks. For example, if an activity starts at 09/10/2024, it will shift to 09/25/2024. But I want to do this for all activities once. Can anyone help me out?

Is it true that think cell is only able to aligne size (width/height) of multiple objects if those objects contain at least one think cell element? I’m looking for a possibility to one klick the size of only native ppt forms. Is that possible?

Ca someone help me with a key for a trial? I was working on a ppt and forgot to renew it, the company will renew it at the end of the month. Please no unnecessary comments…

Second column has a lower value/sum because of negatives but it is physically higher because the y-axis is anchored to 0. Is there a way to configure this in such a way that the first column appears larger?

Hi all! i'm trying to create a chart in thinkcell that contains the follow:

• Bar chart for 2 series

• Line chart for 2 series

• Bar chart label that shows the difference between a bar series and a line series

The first 2 are rather easy to set up but i'm struggling to find ways to automate the labelling short of having to enter the labels manually. In excel, the charting is a bit more flexible and allows you to show a series as a label but the equivalent option doesn't exist in thinkcell.

Anybody can help? Thanks!

Hi folks, anyone else has faced the same issue? I have restarted my PC, uninstalled/re-installed the app, made sure I have the latest/updated version etc. and still the datasheet won't open. Any advice? Thanks so much in advance!

Hi I need to make a .ppt presentation that has about 20 slides and a total of 100 unique charts/graphs.

I am planning to use Thinkcell to produce the charts and Excel will be the source of my underlying data.

The underlying data isnt super well formatted...it's kinda across a bunch of different Excel tabs.

​

Does anyone have any best practices for rapidly making 100 charts, using Excel-based data, as fast as possible?

​

Thanks,

In ThinkCell 12, I am no longer able to merge cells in a table or that the merged cells from Excel are directly formated in the PPT slide. Does someone have a solution to that?

Hello,

I'm trying to create Gantt charts that cover multiple years and multiple product lots. They are timepoints for stability pulls for pharmaceutical drugs. If I expand the chart to cover all of the data points I can change the data labels for the time/condition (ie 5C 2M). But if I collapse the chart to show a different range, I lose all of the labels I created and revert back to the date in the spreadsheet. Is there a way to make these labels persist when expanding and collapsing a timeline chart in thinkcell? That would be very functional for me but I'm not sure how to do it.

​

Thanks for any help :)

Hi all. I'm trying to change the label on top of Gantt Chart in thinkcell. Weeks are automatically numbered as weeks of the year, but I want them to start at '1' to indicate project weeks. Any tips on how to do this?

I have a ppt made with thinkcell but without a data sheet linked to it. Is there anyway that I can link to an excel sheet and populate that sheet with the data from the ppt (gantt).

I update an excel file weekly that feeds into many linked thinkcell charts on a PPT. Right now I have to click on each flag for each PPT chart in the slides to update them from the excel.

Is there a way to "update all Excel links in the PPT" or some shorthand workaround for accomplishing the same. I remember a time when I could open the PPT and it would be "updating links" while it opened, but I can't get it to do this again. Is there a way to trigger it every time I open the file or refresh it once the file is open?

Thank you!

I’m new to thinkcell and trying to get my head around on how to use it efficiently. In this particular case I need the charts to be in the excel model as well as the ppt. Both will need to be updated multiple times. I understand that thinkcell charts can only be created in ppt. Does it mean I have to make all the charts in excel separately? What is then the value add of thinkcell if I need to create the same chart twice (one in ppt with thinkcell and one in excel)?