think-cell takes care of correct and readable labeling. Avoid using PowerPoint text boxes to label your charts as they will be ignored by think-cell’s automatic label placement. When you create labels from think-cell’s context menu, the default content is taken from the datasheet or calculated by the program (in the case of column totals, averages, and the like).
In addition, you can always enter additional text or replace the default text inside think-cell’s automatic labels. When a label is selected, you can start typing, overwriting the current text. If you want to keep the existing text, enter text editing mode by pressing F2 and use the cursor keys and Home/End keys to navigate within the label text. This section explains how think-cell’s labels work in detail.
Here is a list of labels that are supported for different types of charts, and the buttons in the context menu to add or remove them:
|Label type||Chart types||Menu buttons|
|Category||column, line, area|
|Series||column, line, area|
|Point||line, area, scatter|
Note: Column includes stacked chart, clustered chart, 100% chart, Mekko chart, waterfall chart, and their rotated variations. Scatter includes bubble chart.
Additionally, some chart decorations also support labels:
|Label type||Chart decoration||Menu button|
When using think-cell, labels are automatically placed at their appropriate positions. A number of built-in rules ensures that labels are always placed for easy readability and pleasant aesthetics. These rules are specific to the chart type and to the type of the label in question. Here are some examples.
In general, think-cell automatically places all labels at appropriate positions. If a label can be placed at multiple positions, you can manually change think-cell’s placement decision:
Labels that do not show the drag icon when selected, do not offer alternative locations.
When manually placing a series label, alternative locations for the label will include any existing legend (Legend) for the chart.
Once you have manually placed a label at a specific position, think-cell will respect your decision and maintain the label’s position even when the chart layout changes.
If you want a manually placed segment label to be put back into automatic mode, drag the mouse pointer onto the target Drag here for Automatic or click the Enable Automatic Placement button from the label’s context menu.
Note: You can also drag multiple labels at the same time. To do so, use multi-selection (Multi-selection) and move one of the selected labels as a representative.
Many labels can be rotated by 90 degrees counter-clockwise or clockwise. To rotate a label, select it and drag the rotation handle to the desired position. Labels that do not show the rotation handle when selected cannot be rotated.
Note: You can also rotate multiple labels at the same time. To do so, use multi-selection (Multi-selection) and rotate one of the selected labels as a representative.
You can add arbitrary text to all labels that are created with think-cell. The numbers in the labels are updated whenever the datasheet changes, even when the label contains extra text. This is particularly convenient for annotations or footnote marks. To use this function, simply type into the text box as usual.
When you move the cursor or select text, you will notice that the numbers from the datasheet behave like a single character. This concept is called a text field. You can either overwrite the text field or add text before or after it, but you cannot change it. Any numbers that are based on the datasheet and are displayed in chart labels, are created as text fields. Each text field refers to a certain number created from the Excel data. This could be a single cell in the datasheet or a calculation involving multiple cells. Whenever the data source of the text field is changed, the numbers in the label are updated to reflect the change.
As long as you do not delete or overwrite a label’s text field, the numbers in the text box are kept consistent with the numbers in the datasheet. You may, however, choose to delete the field and replace it with some other text or numbers. In this case, the text in the label will no longer be updated.
It is not obvious when a numeric text field has been overwritten with some other number. To inform you that the label is no longer automatically updated, an exclamation mark pops up next to the label. The exclamation mark also pops up next to category or series labels if you entered text in the datasheet but then replaced the text field with custom text. Note that the exclamation mark is purely informative and that overwriting text fields is often perfectly legitimate.
To reset a label and (re-)insert text fields, use the label content control (Label content) or simply click on the exclamation mark, if there is one.
Note: Due to a limitation in Excel only the first 255 characters of text in a datasheet cell will be displayed in a label in PowerPoint. However, it is possible to work around the limitation by concatenating text in a formula, i.e., instead of Very long text ... you would type ="Very long "&"text ..." into the datasheet cell.
Note: Alt+Enter can be used to add line breaks to text in the datasheet while F7 can be used to spell-check datasheet text.
The font control applies to all text labels. Click on a font to change the setting of the selected features. When you change the font for the element, all text that is later created within the same element adopts the new font.
The number format control applies to text fields that display chart data. To use the number format control, enter an example number with the desired format. The actual number you enter is not important, it is only the number format that matters. The dropdown box provides quick access to the most common formats. Also, up to four of your most recently used custom formats are available in the dropdown box. Absolute and relative values can have different formats.
You can use the following punctuation characters for the grouping of thousands: comma, point, single prime and space. For the decimal point, you can use point, comma or momayyez. However, you cannot use the same character for the grouping of thousands and the decimal point.
think-cell can also use a number format that has been set in Excel. To use this, first choose the desired number format in Excel using the Format Cells... dialog and then select Excel Format from the bottom of think-cell’s number format control.
In the context of currency, some people use single prime as a symbol for million and double prime as a symbol for billion. If you want to use this convention with think-cell, start with entering millions into the datasheet or use the magnitude control to show the values in units of millions (see Magnitude). Then, enter the appropriate format string into the number format control. If you do not use the single prime in the format string, the numbers followed by a double prime always represent billions – even if there are no more numbers following the double prime.
Consider the number 3842.23 (or the number 3842230000 combined with a magnitude setting of ×106).
|Number format control||Output|
Values from data sources often have magnitudes that are not appropriate for data presentation. In think-cell, you can solve this problem by altering the magnitude of the labels without changing the data source.
Here is a simple example: Your Excel table is filled with seven-digit values (e.g. 3,600,000.00) but you would prefer to show values in units of millions. Simply select ×106 from the floating toolbar and the labels will show the appropriately scaled values.
Most labels have a label content control. Use the control to choose text fields with which to fill the label. For example, the segment labels in the column chart can show absolute values and/or percentages. (For details about filling in the datasheet refer to Absolute and relative values.)
Some labels only have one entry in this dropdown box. You can use it to restore the label’s text field if it was deleted.
With think-cell, creating data driven charts is quick and easy, but you still have to type the text. If you already have it available in some table or text file, think-cell can help you there, too.
The text may be in a file in Microsoft Excel or Microsoft Word or in any other kind of text file. In Excel, labels are naturally separated into table cells. In plain text files, labels should be organized in columns (separated by line breaks) or in rows (separated by tab characters).
Pasting multi-selections is not only possible with chart labels but can also be used with any native PowerPoint shape.
If the text from the source is properly separated by line breaks and/or tab characters, each of the selected shapes or labels in PowerPoint receives the corresponding text from the clipboard.