We are excited to announce that think-cell version 12 is now available
We are excited to announce that think-cell Version 12 is now available. Upgrading to the latest version is included in your annual licensing fee and ensures that you will experience the highest level of performance. It also delivers enhanced control of what you already love about think-cell, including the following new features:
You can create rotated line charts, also known as profile charts, and rotated combo charts in the same way as rotated stacked or clustered charts.
Similarly, for a rotated stacked or clustered chart you can use the chart type control to change the chart type to line, keeping the rotation.
The think-cell profile chart is an easy way to visualize even the most complex trends with data that indicates the value area and points of control related to specific topic areas.
Common use cases include: Company or product comparisons across various categories, personality profiles, market profiles for financial and banking industries.
Using a rotated line chart and error bars, you can create football fields. They can be used to visualize the low and high values for an item and the spread between them.
To create a football field chart:
You can directly select individual partitions in scatter and bubble charts. This makes it easy to give each partition a different fill color, if desired. Previously, you selected a partition line to choose the fill color to only one side of the line.
To create a chart with four partition fills:
This also works for areas bounded by non-linear trendlines!
You can now customize the layout of the internal datasheet as well as that of Excel links.
This is particularly useful when you want to link charts to an existing Excel sheet whose layout you do not want to modify. Let's say you have an Excel sheet laid out like this, and want to create a column chart out of the selected range:
In the resulting linked range, the first data row is misinterpreted as 100% values, and the first data column as series labels.
To get the correct interpretation of the data:
The link will now correctly interpret all linked cells except the first row as data values, with data rows representing series.
To label the series, simply right-click the chart, select Add Series Labels and replace the placeholder in the labels accordingly. The final result will look something like this:
Note: When working with the internal datasheet of a chart, you can find the Edit Data Layout button in the Quick Access Toolbar at the top of the window.
You can click Highlight on Slide in the Data Links dialog to highlight all elements linked to external sources on the slide, to further facilitate easy management of your data links.
Text linked to Excel is now listed in the Data Links dialog.
think-cell tables, text boxes and other elements are automatically resized and positioned. This advanced automation can be a great time-saver, but is also quite different from PowerPoint's standard mode. A new option allows you to have the best of both worlds, getting access to think-cell's new elements while controlling size and position yourself. You can find it in the 
Tools menu.
Lock Positions by Default is activated by default in think-cell 12.
When Lock Positions by Default is active, think-cell elements that you add have all locks closed.
For more detailed information, see Lock Positions by Default.
You can now align the horizontal (Align Objects Center) or vertical (Align Objects Middle) center of a think-cell layout element, or a group of think-cell layout elements with one another, or with the slide.
Just as with other alignments between think-cell's smart layout elements, this relationship will be maintained even when something causes the slide layout to change.
Let's say you want to have an image of a fixed size on your agenda slides that is always aligned vertically with the middle of the table of contents, which in turn is always in the center of the slide horizontally. You can now easily achieve this as follows:
Now you can add chapters, subchapters, etc. to your agenda as usual, and think-cell will automatically take care that the desired relation between slide, table of contents, and image is maintained.
You can now customize the appearance of the Gantt chart using the new element in the style file: From setting default background fills for different elements over fine-grained control over the properties of every single kind of line in the chart to new choices for the look of the date scale. For a detailed description, see gantt.
We have also added support to Gantt charts for fiscal years that always start or end on a particular weekday, and thus require leap weeks, as well as support for 4-4-5, 4-5-4, and 5-4-4 calendars. For example, including the following element in your style file will allow you to use fiscal years ending on the Friday closest to Janurary 31st, and with 13 week quarters following a 4-5-4 convention:
For a detailed description, see fiscalYear .
This means you can now use it on your Microsoft Surface Pro X, for example.
To place the chart on top of a picture or visual background, for example, simply right-click the axis and click the 
Delete button, or left-click the axis to select it and press the Del key. To add it back in, right-click a highlighted segment of the X-axis area, and select 
Add Axis Line .
You can now delete all disconnected data links in an open workbook. Simply click Delete Disconnected Links from think-cell's 
Tools menu in Excel, or right-click a linked range highlighted in red and select 
Delete All Disconnected Data Links from the contextual menu.
think-cell has expanded its cleaning and sanitization options, to help you prevent leakage of sensitive internal or client data, and has bundled them into a single Clean Up... dialog. For example, think-cell can remove all Comments and Presentation Notes, as well as any unused Slide Masters and Layouts embedded in the presentation. It can also automatically replace all numbers contained in the presentation with random ones. The same functionality is available when using think-cell's Send/Save Slides... dialog.
You can now predefine slide layouts in the style file which will be shown as thumbnails on inserting or moving a chart. Click one of the rectangular areas marked on the thumbnail to quickly and precisely insert the chart with that position and size. This is especially useful when combining it with slide templates to ensure consistent placement of charts on the slide in relation to other elements. Think of it as placeholders for think-cell charts, just more flexible. For detailed instructions on how to do this, see Predefining slide layouts for placing charts.
think-cell now comes with an improved tool for picking colors, accessible by selecting Custom... from any color control. It gives you a useful preview by immediately applying the selected color on the slide. You can also easily switch between choosing colors for different features of the selected element, such as fill color and font color, and even switch to choosing the colors for a different element simply by selecting it on the slide. If you want to select a predefined RGB color in either hex (#82a617) or decimal (rgb(130, 166, 23) or R119 G119 B119) format, simply enter it into the box bottom right.
How do I upgrade to think-cell 12?
In some instances, think-cell is automatically upgraded to the latest version to ensure continuity and performance. To see what version of think-cell you are currently running, click on “Productivity Tools and Resources” in the think-cell menu in PowerPoint and select “About.”
If you are not running think-cell 12 yet, please login to the Customer Portal and select the Download Menu and then click the Download think-cell button to get the latest version.
In the coming weeks, we will provide additional video resources and information, but please do not hesitate to reach out if you have any questions.
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved
