Home

think-cell 7 – User Guide

Contents

1. sol dFill name bgl gt schemeClr val bg1 gt lt solidFi11 gt solidFill name tx1 gt lt schemeCle vale tx1 solidfill solidFill name accenti gt lt schemeCle vale accent1 solidFill names accent2 gt vale accent2 y SA a lt solidfill names hlink gt lt schemeClr vale hlink lt solidFill gt lt solidfill name folMlink gt 11 lt schemeC1lr vale folHlink lt solidFill gt lt solidFill name bg2 gt emeClr val bg2 gt lt solidFill gt v The editor automatically checks your file for errors You can display an error list by clicking on View gt Error List Make sure that there are no warnings or errors indicated before you save an edited style file Of course any other editor that supports XML also works The file needs to be saved with an xml exten sion Loading style files To load a style file choose Load Style File from the menu More In the dialog navigate to the folder with the style file choose the file and click Open It is used for any new charts in the current presentation For example after you load the sample style file example style complex xml from the styles directory in think cell s installation path the color and color scheme property controls will include customized items Customizing think cell 124 Vater em vert sean AMA If you want to apply a style s colors or color scheme
2. Add Grid Lines Add or remove gridlines j Add Title Add or remove an axis title You can drag the title to choose its placement w im Set Logarithmic Linear Scale Set the axis to a logarithmic or linear scale see Logarithmic Scale on page 47 m Add Second Y axis Add a secondary axis see Sec ondary Axis on page 47 j Fit Scale To Data Revert the scale and tickmark spacing to automatic sizing if they have been modified either by the user or by a same scale operation see Same scale on page 46 q Add Break Add a break at the current mouse pointer position see Value axis break on the current page gt IE Set Crosses At Between Categories Alter the crossing behavior for a line chart Value axis break Segment axis line area p Wa Use a value axis break to shrink a particularly large seg ment and enhance readability for the smaller segments To add a value axis break click the part of the seg ment or axis where you want the break to go and open the context menu When adding a value axis break the In menu Menu item js exact position where you right click a segment or axis makes a difference Any break you insert applies to the value axis if shown and to all segments sharing the same range of the axis For this reason you can not add a break to the axis at any position where there is a segment border in any of the chart s columns A break can only be added it at the mouse pointer location t
3. Again the query is executed locally returning either one computer system the one the query is running on or none gt lt m_bstrQuery gt select from Win32_ComputerSystem where Name ANNA or Name TOM or Name FRANK lt m_bstrQuery gt lt number of returned records equal to 1 gt lt m_eupdcondop val 0 gt lt m_nCount val 1 gt lt elem gt lt m_vecupdcond gt lt elem gt lt elem gt lt Second scenario all other users gt lt All other users receive think cell build 17883 gt lt m_bstrFile gt http example com setup_17883 exe lt m_bstrFile gt lt List of 1 condition that must be met to install the file gt lt m_vecupdcond length 1 gt lt elem gt lt m_bstrQuery gt select from Win32_Product where Name think cell and Versiong1t 1 17 883 0 lt m_bstrQuery gt number of returned records equal to 1 gt lt m_eupdcondop val 0 gt lt m_nCount val 1 gt lt elem gt lt m_vecupdcond gt lt elem gt lt m_vecupdscen gt lt CUpdatelnfo gt lt root gt Figure A 1 Example of an update xml file 119 B Exchanging files with PowerPoint This chapter covers some issues that arise when your coworkers use PowerPoint without think cell installed Loading files from think cell in PowerPoint Any files created by PowerPoint with think cell installed are 10096 compatible with PowerPoint This means that coworkers and customers who do not have think cell
4. marker shape 21 number format 35 segment sorting 2 quality assurance 13 rectangle rounded 79 registry 111 remove ink 88 reverse data order see datasheet ribbon 113 ridge 59 rotation 17 rounded rectangle 79 rounding addends and totals see think cell round numbers in charts see number format control row Gantt chart 69 same scale 46 save and send selected slides 86 scale Gantt chart 68 scale numeric see value axis scatter chart 62 63 scatter chart with lines see line chart secondary axis 47 security encrypted error reporting 13 116 Index 147 signed executables 12 segment difference arrow 49 segment sorting control 21 selecting 17 selection of multiple features see Multi selection series CAGR 51 setup see installation setup exe see msiexec shade Gantt chart 72 shortcut keys navigation 19 overview 142 Simplified Chinese 31 single prime see primes in numbers smoothed lines 40 snapping 16 special characters 86 stacked clustered char 38 submarine chart 59 support automatic update 12 online quality assurance 13 trouble shooting 12 symbols see special characters Tablet PC 88 TCROUND Excel formula 103 TCROUNDDOWN Excel formula 103 TCROUNDNEAR Excel formula 103 TCROUNDUP Excel formula 103 text field 34 label content 36 number format 35 think cell ribbon 14
5. think cell round 101 think cell toolbar 14 tickmarks 43 timeline chart see project timeline toolbar 19 toolbar controls see property controls Js Traditional Chinese 31 trendline 64 trouble shooting 12 update automatic 12 scripting see deployment update server 1 14 update xml 115 value axis 43 break 44 crossing behavior 44 gridlines 44 same scale 46 tickmark labels 44 tickmarks 44 title 44 VALUE Excel error value 105 value line 51 variable see text field visual basic see API waterfall chart 54 connector 55 weighted mean see value line y axis see value axis zoom panning 19 Index 148
6. 116 prerequisites 108 update scripting 114 difference arrow 49 category 50 segment 49 double prime see primes in numbers elements inserting 15 resizing 1 error bars 40 error reporting 13 116 Excel chart data entry 29 create chart from 90 data links 90 data rounding 101 group and outline 96 hidden cells 96 rounding see think cell round transpose linked data 91 update data link 92 feature layout settings 26 remove 18 selection 17 26 file name see case code files 110 flip columns see datasheet flip rows see datasheet font control 35 Frequently Asked Questions see trouble shooting Gantt chart see project timeline gap 48 group policies 112 g growth arrow see difference arrow Harvey ball 71 79 identifier see case code insert symbol see special characters inside label 33 installation 11 108 download 11 files see files firm wide see deployment first steps 11 group policies see group policies language 110 parameters REPORTS 116 RIBBONPPGROUPINSERT 113 RIBBONPPTABINSERT 113 RIBBONPPXMLNS 113 RIBBONXLGROUPINSERT 113 RIBBONXLTABINSERT 113 RIBBONXLXMLNS 113 UPDATESURL 115 registry see registry requirements ribbon see ribbon trouble shooting 12 inter
7. If you change the size of the legend s frame the legend text will be automatically reformatted to fit the new frame size To create a horizontal legend for example pull the left or right border of the frame outwards 9 Waterfall chart Icon in Elements menu ri In 29 Label Label Label Label Label Label A waterfall chart sometimes called bridge chart visu alizes an additive calculation with subtotals To create a waterfall chart simply type the calculation into the datasheet 1 2 3 4 5 6 4 Positive values result in segments going upwards nega tive values create segments going downwards Subtotals i e segments that go all the way down to the baseline ot the chart are easily created with an e for equals In fact you can use e in any segment that you want to be stretched to fit the rest of the chart All e segments are calculated by think cell and automatically kept up to date when data changes You can even begin the calculation with an e in the first column In this case think cell starts from the right most column and calculates backward to find the value for the e column Thus the following data sheet results in the same chart as shown above g You may enter two or more values into a single column If you have a column made up from more than one seg ment you can enter an e for at most one of them When both positive and negative values are used in a single column
8. Set to Right Left Axis button from the line context menu If a chart has two y axes then you can use the same 1E Set to Right Left Axis button to alter the y axis association of individual lines in the chart A secondary axis is a fully fledged value axis Value axis on page 43 and may be scaled independently C 450 30 29 28 400 4 27 26 350 4 25 24 23 300 4 22 Average temp 21 g p Ice cream sales 250 20 June July August g Gap width and category gap The basic spacing between columns in a chart is speci fied by the gap width Extra spacing between individual pairs of columns may be added by inserting a category gap The gap width for all columns can be altered by click ing on the baseline and dragging the handle a small distance The handle snaps to the default gap width In order to achieve a consistent appearance for chars throughout your presentation the default gap width should be used when possible 27 2013 Gap Width 110 Ctrl key to keep chart width Category gaps can be introduced by dragging the same handle further to the right until the category gap tooltip appears The handle snaps to multiples of the column width 19 2005 2007 Altering the gap width or introducing category gaps by simply dragging preserves the width of the columns re sulting in an increase or decrease of the overall chart width Chart decorations 49 You can ensure that the overall chart
9. for series 51 case code 87 case path 87 category axis break 48 category difference arrow 50 category sorting control 21 changing fonts 87 changing the language 86 checkbox 71 79 chevron 79 Chinese conversion 31 clustered chart 38 clustered stacked chart 38 color control 19 color scheme control 20 column break between 48 break within 44 gap between 48 column chart 38 144 E 10096 see 10096 chart clustered see clustered chart insertion 24 label content 36 simple 38 stacked 38 waterfall 54 combination chart 41 comparable scales see same scale compatibility 119 connector column bar 52 series 52 universal 52 waterfall 55 controls see property controls crosses at categories 44 crosses between categories 44 customization 22 121 data links see Excel data links dialog 93 data rounding see Excel datasheet 25 and text 34 data entry 29 flip columns 31 flip rows 31 reverse data order 31 transpose 30 waterfall 54 date format control 75 decoration 10096 indicator 52 CAGR 50 category axis break 48 difference arrow 49 series connector 52 universal connector 52 value axis 43 value axis break 44 Index 145 value line 51 default colors 22 deployment 108 installation 108 online quality assurance
10. g Note The case code textbox only works on the master slide not on individual slides Remove Ink If someone has used a Tablet PC to add ink annotations to the current slide you can get rid of all ink on that slide with a single mouse button click Simply use the option Remove Ink from the More menu More 2 Data Links m Insert Symbol Bd Save Selected Slides g Send Selected Slides S Remove Ink Presentation tools 9v Excel data 18 Excel data links When the source data for your data driven chars is available in Excel you can create charts directly from the Excel application When data in Excel changes you can either update the charts on command or have think cell do the update automatically Creating a chart from Excel For a step by step guide on how to create a chart from your Excel data using think cell please consider the ex ample from Introduction to charting on page 24 This is how the example chart data looks in Excel G H J K 2013 2014 2015 2016 8 4 30 7 81 9 179 3 18 65 3 174 1 381 To create a chart from Excel select the desired data range in your Excel workbook including series and cat egory labels The layout of your data must match the layout of think cell s internal datasheet Column charts are usually cre ated from data columns whereas bar charts are created from data rows Nevertheless it is possible to transpose the data source see Transposing
11. month name single character quarter decimal number quarter upper case roman number quarter lower case roman number year two digit year four digit line break e g ddd dd Insert custom text e g Quarter qq The actual single quote character e g W ww yy Example 5 05 Mon Monday M 07 9 09 Sep September 04 2004 Mon 05 Quarter IV WO7 04 Layout 14 Introduction to layout In addition to elements for charting think cell provides a growing number of elements and tools for general slide layout and for enhancing productivity when work ing with PowerPoint Basic elements can be used to cre ate complex structures to support the message you want to communicate with a slide see Basic elements on the following page The agenda tool automatically main tains contents and chapter slides that are always up to date see Agenda on page 81 And a number of ad ditional productivity tools make several tasks more effi cient when working with presentations see Presentation tools on page 86 15 Basic elements Pentagon Chevron Icon in Elements menu p The pentagon chevron is often used to describe pro cesses and their sequential steps If this element is se lected e g immediately after insertion you can start typing and the text will be displayed inside the element with automatic line breaks By double clicking a pen tagon you can convert it into a chevron and vice v
12. the same order they appear in the datasheet Categories in descending Y extent order will show the category with the greatest sum of values first and then sort in descend ing order Categories in ascending Y extent order will show the category with the smallest sum of values first and then sort in ascending order Basic concepts 22 Line style The line style control applies to the out lines of segments of column bar and pie charts basic elements agenda chapters 2 pt lines in line charts a chart s baseline and Eri SERM to value lines see Value line on page 51 5 You can also change a connector s ap pearance using the line style control In addition the outline of the plot area in all charts can be specified using the line style control t Outline colors You can change the color of an outline ie2 I Background 1 with this control It works for segments of ws column bar and pie charts as well basic je elements and agenda chapters B Accent3 Bl Accent 4 Bl Accent 5 Bl Accent 6 Bl Hyperlink Bi Followed erlink tc Red tc Gray Bi tc Green Smoke 1095 Smoke 20 pese Line scheme Bl Smoke 80 ll Smoke 90 The line scheme control specifies the appearance of lines in line charts The supported line schemes apply consis tent line styles and coloring to all lines in the chart Colors 4 NoM Colors Dash Mono Use Excel Fill on Top Marker shape
13. to conveniently move to the next column in a row and the enter key 4 can be used to jump to the first column of the next row The datasheet for our example column chart looks like this ufu B E E F A E D G 1 Category 201 2014 2015 2016 10096 2 Series 3 Series 8 4 30 7 81 9 179 3 4 Series 18 65 3 174 1 381 md Note that the chart on the slide instantly updates to re flect the changes in the datasheet lt even grows and shrinks depending on the area of the datasheet that you use Years are automatically inserted as category labels in the first row of the datasheet The sequence of years is automatically continued when you start entering data in the following column Having entered the data our example chart looks like this Introduction to charting 27 560 179 256 82 5 174 2013 2014 2015 2016 As you can see think cell has already pertormed a good deal of work to make the chart look right In particular it automatically placed all labels and added column to tals The next section explains the last few steps to finish our example chart Styling the chart Every chart element consists of a number of features In our example text labels and column segments are the most important features of the column chart Each kind of feature has a number of specific properties that you can change in order to give it a different look To change a feature s properti
14. 2015 Note You can also drag multiple labels at the same time To do so use multi selection Multi selection on page 18 and move one of the selected labels as a rep resentative Label rotation 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 Text labels 35 that do not show the rotation handle when selected can not be rotated ee t Series amp Note You can also rotate multiple labels at the same time To do so use multi selection Multi selection on page 18 and rotate one of the selected labels as a rep resentative Text fields 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 an notations 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 cel
15. A contains a sub chapter Al and there are no content slides between the agenda slides for A and Al then the agenda slide for A is automatically set to hidden in Power Point Similarly when the condition no longer holds the slide is automatically unhidden in PowerPoint g During slide shows a displayed slide number will jump whenever a hidden agenda slide is omitted To prevent this choose 3 Remove Hidden Agenda Slides from the context menu of any chapter heading to remove all such slides from the presentation To add content between a removed chapter slide and the first sub chapter slide choose 13 Insert Hidden Agenda Slides and navigate to the desired location in the presentation Multiple agendas in a single presentation It is possible to divide the presentation into multiple sec tions each with its own agenda To do this go to the first from the Elements menu A slide can be identified as a divider slide by a marker in its top left corner Chapters after a divider are not included in agenda slides before the divider and vice versa The different sections in the presentation have independent agendas Typically a divider is used to separate a backup section from the main part of the presentation In this case usu ally the backup section has it s own title slide which just says Backup with no agenda or overview on it This is where the agenda divider should be placed The chap ters after th
16. Option Explicit to avoid incorrectly typing the name of an existing variable or to avoid confusion in code where the scope of the variable is not clear If you do not use the Option Explicit statement all undeclared variables are of Object type http msdn microsoft com en us library y9341s4f 28v vus 80 29 aspx Option Explicit Sub UpdateChart_Sample Get the range containing the new data Dim rng As Excel Range Set rng _ ActiveWorkbook Sheets Sheet1 Range A1 D5 Get the think cell add in object Dim tcaddin As Object Set tcaddin Application COMAddIns thinkcell addin Object Get a PowerPoint instance Hold on to this object as long as you want to access the generated presentations There cam only be a single PowerPoint instance If there is no Programming think cell 139 PowerPoint running one will be started Otherwise the existing one is used Dim ppapp As Object Set ppapp New PowerPoint Application Dim pres As PowerPoint Presentation PowerPoint window visible Set pres ppapp Presentations Open _ Filename c llezample pptzr Untitled msoTrue PowerPoint window invisible Set pres ppapp Presentations pen Filename c example pptx Untitled msoTrue WithWindow msoFalse The name No1 must have been previously assigned to the chart using the control in the floating toolbar The final argument indicates whether the data
17. TITO iie redo ba R UC adea a AA 137 oe se oe re ce E es ee 137 PresentationFromTemplate rediris RR Re e aes 140 Keyboard shoriculs AA 142 Contents 9 Introduction 1 Product overview Welcome to think cell 7 This software is an add in for Microsoft PowerPoint and Excel that is specifically de signed to make the creation of business slides as fast as scribbling on paper Slides created with think cell intelli gently arrange themselves to look just right All the dec orations labels connectors arrows and the like are iust a mouse click away and are automatically placed precisely where they belong The look of all drawings is optimized to fulfill the requirements of a clean and professional slide design 2 Installation and update This chapter guides you through the installation of your personal copy of think cell If you are about to prepare the deployment of think cell in a larger organization you should skip this chapter and read the Deployment guide on page 108 System requirements To install and run think cell the following software must be installed Microsoft Windows Vista 7 8 8 1 or 10 Microsoft Office 2007 SP1 2010 2013 or 2016 with at least PowerPoint and Excel installed The installation of think cell requires about 80 MB of disk space First installation Installing think cell Please close all instances of Microsoft PowerPoint and Microsoft Excel before installing t
18. The marker shape control can be used to add or change markers for data points No Marker in line and scatter charts Note that the marker scheme control should be used in stead of marker shapes to add consistent markers to all the data points in a line or scatter chart g Marker scheme The marker scheme control applies consistent markers to data points in scatter or line charts The markers are automatically updated when data points groups and series are added or removed The marker scheme control should be pre ferred over the marker shape control when adding con sistent markers to an entire line or scatter chart No Markers Upc No Markers Colors Grayscale Use Excel Fill on To Changing default colors and fonts think cell can use PowerPoint s scheme colors for many elements and features e g axes text arrows etc These colors as well as font definitions are always taken from the default colors and fonts of your presentation file If the defaults are designed correctly think cell will follow seamlessly when you choose to switch the color scheme To adjust the default font settings simply change your presentation s slide master 1 In the ribbon go to View 2 In the group Master Views click on Slide Master 3 In the left pane showing the slide master and the dif ferent layouts with indentation select the slide mas ter Please note that when opening the slide master view the layout
19. You can save the file or continue to work on other charts or slides while the labeler is running In rare circumstances the labeler may not find an opti mal placement for all labels When this happens man ually placing labels will help Try to manually place one of the poorly placed labels and let the labeler automat ically place the remaining labels An acceptable place ment for all labels can normally be achieved by manu ally placing only a few problematic labels Scatter chart and bubble chat 64 Scatter chart Icon in Elements menu los n Y Axis Label 3 o Label 4 Label 2 o A Label Label dn Label 1 0 T T X Axis 0 1 2 3 The scatter chart uses the marker scheme control to con sistently mark data points belonging to the same group see Marker scheme on page 22 The marker shape control can be used to set the marker shape for individ ual data points see Marker shape on page 21 If you choose No Markers in the marker scheme con trol the markers for the data points are switched off In this case the labels are centered on the position of the data points However the automatic label placement may offset the labels from this position to prevent over lap It is not possible to both switch off the marker and hide the label for a data point g Bubble chart Icon in Elements menu 20 Y Axis 3 5 30 Label 2 5 1 5 1 0 0 0 T T T T X Axis 0 0 0 5 1 0 1 5 2 0 2 5 The bubble chart is a vari
20. and disabled for individual series in a chart In area charts it can only be applied to the whole chart because the series stack on each other Area chart Area chart Icon in Elements menu kA 10 8 6 4 Series 2 Series 0 2013 2014 2015 An area chart can be thought of as a stacked line chart with the data points representing the sum of the values in the categories rather than the individual values The appearance of area charts is set using the color scheme control Labels for the data points are not shown by de fault but may be displayed using the area chart AD Add Point Label context menu button The area chart gt Add Column chart line chart and area chart 42 Total context menu button can be used to display to tal labels Linear interpolation can be enabled using the Interpolate button see Interpolation on this page Area 100 chart Icon in Elements menu EA 100 0 5 o Series 60 40 Series 20 0 2013 2014 2015 The area 100 chart is a variant of the area chart with the sum of all the values in a category typically repre senting 100 If the values in a category total more or less than 100 then the chart will be rendered accord ingly See Absolute and relative values on page 29 for more details about specifying data values The labels of the area 10096 chart can display absolute values per centages or both Label content on page 36 Linear interpolation can be enabled
21. and the columns are wide enough to display all decimal places g Button Formula Description Let think cell round decide to which of the two nearest multiples to round to minimize rounding error KY TCROUND x n a TCROUNDUP x n Force rounding of x away from zero hull TCROUNDDOWN x n Force rounding of x towards zero I TCROUNDNEAR x n Force rounding of x to the nearest multiple of the desired precision Remove all think cell round functions from the selected cells Select or type the desired rounding multiple e Highlight all cells which think cell decided to round to the farther of the two closest multiples instead of to the nearest 4 The turning wheel indicates that think cell round is busy For optimal results with as little deviation from the un derlying values as possible you should use TCROUND wherever possible Only use the more restrictive func tions TCROUNDDOWN TCROUNDUP or TCROUNDNEAR if you must Attention You should never use nondeterministic func tions like RAND within any of the TCROUND formulas Excel data rounding 104 If functions return a different value every time they are evaluated think cell round will make mistakes calculat ing values Layout of the calculation The rectangular layout of the example above is only for sake of demonstration You can use the TCROUND func tions to determine the display of arbitrary summations spread across your Excel sheet Ex
22. become familiar with using think cell you will be able to create a chart like this in less than one minute Introduction to charting 29 5 Data entry Internal datasheet Every chart created with think cell has an associated datasheet except for the Gantt Chart that offers a calendar instead The datasheet is opened by double clicking the chart or by clicking the 53 button that appears when the chart is selected The data sheet also opens immediately when a new chart is in serted Open Datasheet think cell uses a customized Microsoft Excel sheet for data input which you can use in the same way as regular Excel You can use all the same shortcut keys you can enter formulas instead of numbers and so forth But of course you can also use an Excel file as a data source see Excel data links on page 90 To insert or delete a row or column you can use the respective buttons in the toolbar of the datasheet The standard buttons for undo and redo and cut copy and paste are available as well Absolute and relative values The think cell datasheet alternatively supports entry of absolute or relative values The distinction between the two types of data is made by the Excel cell formatting You can always toggle the interpretation of a column s data with the button Keep in mind that for the display in the chart it does not matter if you enter percentages or absolute values If you enter absolute values but want
23. buttons Category column line area 3 ES Series column line area i Sy f alt Segment column 42 Point line area d pd Total column area i gt Inside pie amp Outside pie e Activity Gantt X fr R Item Gantt F Scale Gantt f Note Column includes stacked chart clustered chart 100 chart Mekko chart waterfall chart and their ro tated variations 38 XYZ Series Series Outside Series Category Category Automatic label placement 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 For segment labels in column charts It there is enough space place all labels centered f a label is larger than the segment it belongs to put a colored rectangle underneath the label If two labels are too close together offset one to the left and the other to the right It there is not enough space inside a segment place the label outside the segment and add a line thot points to the related segment For inside labels in pie charts If there is enough space place them as close to the segment s outside border as possible Ifa label is larger than the segment it belongs to put a colored rectangle underneath the label Tex
24. cell and are created in the installation directory x64 tcaddin dll lt 25 MB x64 tcdiag exe lt 1 MB x64 tcrunxl dll lt 1 MB x64 d3dx9 43 dll approx 5 MB x64 dbghelp dll approx 2 MB The think cell installation does not write to folders other than the chosen installation folder While using think cell additional files are written to the following folders C Documents and Settingslluser l Application Datalthink cell C Documents and Settings user gt Local SettingslApplication DataNthink cell Windows Vista 7 8 8 1 and 10 C Users user AppData Roaming think cell C Users user AppData Local think cell Registry entries To interact with Microsoft PowerPoint and Microsoft Excel the installation of think cell creates some new keys in the following sections of the Windows registry Depending on whether you have a regular installation or a single user installation the keys are created in the HKEY LOCAL MACHINE or in the HKEY CURRENT USER section Software Classes CLSID gt gt i13EAB3858 AOEO 4A3B A405 FA4D525E85265 Deployment guide 112 Software Classes CLSID gt 1D52B1FA2 1EF8 4035 9DA6 8AD0OF40267A1 Software Classes thinkcell addin Software Classes thinkcell addin 1 Software Classes TCLayout ActiveDocument Software Classes TCLayout ActiveDocument 1 Software Microsoft 0ffice gt PowerPoint Addins thinkcell addin Software Microsoft 0ffice gt Excel A
25. cell has built in automatic update support If au tomatic updates are enabled and PowerPoint is started the software checks whether a new version is available The user then has the option to either accept or delay the update If you would prefer to have this function de activated please contact us If available think cell uses the Microsoft Background In telligent Transfer Service BITS to download updates BITS automatically frees bandwidth when the user needs it and hence does not interfere with dial up connec tions lt also recovers gracefully from network interrup tions common in mobile computing environments Before any downloaded code is executed the signature is checked for validity see Automatic update on page 12 for a security note with more details Each update is approximately 30 MB in size Updates are usually hosted on think cell s web server but you have the option to host updates within your own intranet To do so you need a web server such as Apache or Microsoft Internet Information Server IIS that all think cell users within your organization can access g The following files must be placed on the web server hosting your updates An XML text file typically called update xml that con trols the update process See below for a description of the update XML file format One or more setup_ lt version gt exe update files sup plied by think cell After placing the necessary files on the web
26. digits as it us unusual to use two digits for the first la bel only However if you select one of the labels in the middle and use two digits the first label will remain with four digits but all other labels between the first and the last label will be switched to two digits v x100 v Category v 14pt y 2013 15 2016 Same scale When there are multiple similar charts on the same slide itis often desirable that all of them share the same scale Only when two charts share the same scale are the physical sizes of their bars or columns comparable The following example shows two charts which have the same size but not the same scale Note that the col umn that represents 7 units in the waterfall chart is the same height as the column that represents 47 units in the column chart To make columns from different charts visually compa rable select all those charts together Then open the g think cell context menu of one of them and click the 3 E Set Same Scale button to resize smaller scales to match the largest one In the above example the result ing charts look like this When the data represented by a chart changes it is pos sible that this chart rescales If you still want to keep the same scale for multiple charts you may have to reap ply the same scale operation The same applies if you manually changed the scale of one of the charts To revert the same scale select one or multiple chart
27. e CM 26 o DOON ii br aia eB pod a ee ee i 27 heard o cesses tese me mae bed aci don RC RU P dap oon ide EAE de RR Ead aea ete e 29 Absolute and relative valuBS ciues eee a oe Y Ie edo Ge ac x Cobb P DEW BEN ROO ads 29 Tanpo na ihe daluh Lid does edetas Vado deo b et a dS og dedo og c iot Kobe ed dco Pe UR RO EORR 30 Reverse order in datasheet raros aep Na dre dO ARAL ORES Rar Reo iaces so e dd es 31 e To ODOR er EEEE A rE EARE 32 E 4 0 STE Bote EE En II 32 Automatic label placement ccoorimisiorinn reme eb bated thd RO RR Een deme danas 33 Monval label placement s eu isoell s ere aiii AD ea e PCIE e io i qe 33 TaT nm 34 Teu lobel propery CONTE sia red redo bens ade de bulo oye Pa ote del A a a aces 35 school MAA 36 7 Column chart line chart and area chart cc eee ee eee ee e 38 Columichart and stocked colum CMa a uua uso aene e e Re d UA e Ea ed Re En mde 38 EL ELE raras raras rene es SORA eee RO D SC CS TERCIO RO Ro ted RR 38 lOO chan x erick oe eat 39 10 11 12 13 Contents 5 Line CAG sid bv gas oe baw 6a Recs b hdd PSS SR ee RR es be eed REE OYA boy FEE Reed RO OH 39 A 4 Combination char uiae re bes a wed Unc dod Fc Red Ue ER RR UE Ue Rd a a 4 Chart decorations cluesescuu a EdesuEXG URP edd OE EEA HER FG ER EXessi suu DEKE ROR OOS A3 Scales and OxKES I Louc s kootu Kirra IG a VOL E POOR ex Ros RE LX EK Rue E C RE E Edd Kago d Gp Res e 43 Anmows dnd VOTES cies bees re e REEL GREGG EG em ELA
28. element The attribute name must match the value of the same attribute in the fill definition Example lt linefillRef name accent1 gt markerRef A reference to a marker defined in the markerLst element The attribute name must match the value of the same attribute in the marker defini tion Example lt markerRef name No Marker Choices in the marker scheme control fillmarkerSchemelst A list of think cell marker schemes that will be used in the marker scheme control of the floating toolbar see Marker scheme on page 22 Individual marker schemes are defined using the fillmarkerScheme child element Example lt fillmarkerSchemeLst gt lt fillmarkerScheme name Company marker scheme gt lt fillmarkerSchemeLst gt fillmarkerScheme A marker scheme consisting of a sequence of markers It is detined by referencing markers using the child element fillmarker The at tribute name contains the name that is used in the color scheme control Example g lt fillmarkerScheme name Company marker scheme gt lt fillmarker gt lt fillScheme gt fillmarker A combined marker style consisting of a marker reference using the child element markerRef and an optional fill color reference using the child element solidfillRef f markerRef references noMarker solidfillRef will be ignored Example lt fillmarker gt markerRef name Square gt lt solidfillRef name 0range gt lt fillmarker g
29. fill schemes are defined using the i11Scheme child element Example fillSchemeLst lt fillScheme name Company fill scheme gt lt fillSchemeLst gt fillScheme A color scheme consisting of a sequence of fills It is defined by referencing fills using the child element iiiRef The attribute name contains the name that is used in the color scheme control If the optional boolean attribute reverse is set to 1 the list of fills will be applied in reverse order start ing with the first fill for the bottom most series the second fill for the series above and so on Example fillScheme name Company fill scheme reverse 0 gt lt fillRef name White gt lt fillScheme gt Style file format 131 fillRef A reference to a fill defined in the fillLst element The attribute name must match the value of the same attribute in the fill definition Example lt fillRef name White gt Choices in the line scheme control InfillmarkerSchemeLst A list of think cell line schemes that will be used in the line scheme control of the floating toolbar Individual line schemes are defined using the 1nfillmarkerScheme child element Example lt lnfillmarkerSchemeLst gt lt lnfillmarkerScheme name Company line scheme gt lt 1nfillmarkerSchemeLst gt InfillmarkerScheme A line scheme consisting of a sequence of combined line styles It is defined by describing line styles using the child element 1n
30. flip ping elements on page 1 7 If you want to Hip the data i in the datasheet you can use the Flip Rows or Pr Flip Columns button in the datasheet s toolbar Note This function is particularly convenient to con vert data from former MS Graph charts because in MS Graph data is entered in headfirst order Note lf you have Microsoft s Chinese Conversion fea ture installed you will find the options Simplified Chinese and Traditional Chinese in the datasheet s More menu 6 Text labels 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 re place the default text inside think cell s automatic labels When a label is selected you can start typing overwrit ing the current text If you want to keep the existing text enter text editing mode by pressing F2 and use the cur sor keys and keys to navigate within the label text This section explains how think cell s labels work in detail Types of labels 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
31. has three handles YN AAA Value axes are usually scaled by think cell You can however manually scale a value axis by dragging the handles at the end of the value axis The values on the axis must always include the range between the low est and largest value in the datasheet If you do not want to show a specific value either remove it from the datasheet or hide the respective datasheet row or column Automatic value axis scaling can be restored by dragging the handles until the tooltip indicates Au tomatic Holding down A while dragging ensures that the value axis scale will not revert to automatic mode The tickmark spacing for value axes is usually calcu lated by think cell You can however manually ad just the tickmark spacing by dragging the middle han dle As you drag the handle will jump to supported tickmark spacings with a tooltip indicating the se lected spacing Releasing the handle will apply the indicated tickmark spacing to the axis Automatic tick mark spacing can be restored by reducing the tick mark spacing until the tooltip indicates Automatic The iE Set Same Scale button can be used to apply the same scale to multiple charts See Same scale on page 46 for further details Positioning the value axis A value y axis can be moved by selecting and dragging the axis with the mouse While dragging available alternative locations for the axis will be highlighted Dragging to the desired locatio
32. if you assign a blue fill and dashed outline to a highlighted top level chapter g heading all other highlighted top level chapters will be styled in the same way Agenda First topic e Second topic Third topic When styling the agenda think cell differentiates be tween the following types chapter is current and at top level chapter is top level and contains the current chapter chapter is top level but does not contain current chap ter chapter is current but not at top level chapter is an immediate child of current chapter and current chapter is top level neither chapter nor current chapter are top level and chapter is not on the path from the top level chapter to the current chapter but either one of its siblings is on this path or it is an immediate child of the current chapter chapter is in subtree of current chapter is not top level and not current and not in subtree of current but the top level chapter of this chapter is current Agenda 85 chapter is not top level and not current and not in subtree of current but this chapter is below the same top level as the current chapter any other chapter except table of contents chapter is in table of contents and chapter is top level chapter is in table of contents and chapter is not top level neither chapter nor current chapter are top level and chapter is on the path from the top level c
33. in the internal datasheet of a linked chart Auto update is disabled for the concerned chart How can link an existing chart to a data range in an Excel workbook Go to the Excel workbook and select the desired range Then switch to PowerPoint select the desired chart and click the HH Establish Excel Link button in the context menu For a detailed description refer to section Changing and removing links on page 95 To learn how to in sert a chart directly from Excel read section Creating o chart from Excel on page 90 My linked chart seems to ignore part of the Excel data range Why In addition to the main data the linked range in Excel contains some cells to the left and on top which are reserved for category and series labels It the selected range encloses only the main data part of the data will be interpreted as labels and will not show up in the chart If you are unsure about the required layout simply insert a new chart of the desired type in PowerPoint and refer to the layout of its datasheet For further information read section Creating a chart from Excel on page 90 g Why is Excel slow when I have lots of linked data ranges Excel performance can be improved by disabling au tomatic error checking To do this select from Excel s Tools menu Options click on the Error Checking tab and uncheck the Enable background error checking box For Excel 2007 and later go to the dialog Excel Options se lect F
34. linked data on the fol lowing page In addition to the data some cells to the left and on top are reserved for category and series la bels If you are unsure about the exact layout required simply insert a new chart of the desired type in Power Point and refer to the layout of its datasheet Then select the desired chart type from the Charts menu in Excel s think cell toolbar Percent More Charts bd nh di oai Stack lustered A ADOOS Stacked Column ch d Waterfall Mekko Mekko 9o Axis Unit Axis a m Area Area 10095 Line e lei Ex 9 x rm DR Scatter To Existing Bubble Chart When you click on this menu item in Excel the Power Point window is activated If PowerPoint is not yet run ning it starts automatically In PowerPoint when the mouse pointer is on a slide the familiar insertion rect angle appears Switch to the slide where you want to insert the chart or insert a new slide and place the chart as usual Click once to accept the default size or click hold and drag to change the chart s initial size For a detailed description on how to place resize and align a new chart please refer to Inserting a new chart on page 24 After insertion the chart looks and behaves like a regu lar think cell chart that has been created in PowerPoint Excel data links 92 96 26 31 8 65 2013 2014 2015 2016 Please refer to Adding and removing labels
35. list The marker shape can be specified using the child element symbol Example lt marker name Marker Circle gt lt symbol val circle gt lt marker gt symbol A marker shape based on the preset marker shapes defined in the Office Open XML standard The attribute vai specifies the marker type using the values circle triangle diamond square star x hollowCircle hollowTriangle hollowDiamond hollowSquare dash dot plus msdn microsoft com en us library documentformat openxml drawing charts markerstylevalues aspx Example symbol val circle gt Choices in the marker control markerLst A list of markers described by one op tional instance of the element noMarker and at least one instance of the element marker The markers de fined in this list are shown in the marker control of the floating toolbar see Marker shape on page 21 Example lt markerLst gt marker lt markerLst gt g noMarker When the user chooses this special marker style from the marker style control the marker has no fill color The attribute name contains the default name used in the marker style control which cannot be changed lt noMarker name No Marker gt Using colors lines and markers in schemes Choices in the color scheme control fillSchemeLst A list of think cell color schemes that will be used in the color scheme control of the float ing toolbar see Color scheme on page 20 Indi vidual
36. o9 cod T E 9 0 a od ee bo m lale a ee b o d 17 09 2013 H Tue of Week 38 With the crosshair highlighting click the right mouse button to open the context menu g Activity Implementation and system test Setup of pilots IT integration Internationalization Training I del mb a d aoo Ro ee d y A j Note If you want to open the row s context menu to insert a new row orto add some row label or decoration you must right click on the row outside the chart s date range area Refer to Row features on page 70 for more information The context menu for insertion shows the following but tons X Delete Shortcut Delete Delete the selected row separator line or milestone line f amp New Bar Create a new activity bar beginning at the crosshair position fig New Milestone Create a new milestone at the crosshair position E New Bracket Create a new bracket beginning at the crosshair position ffi New Shade Create a new shade beginning at the crosshair position fi New Process Create a new process arrow beginning at the crosshair position Note You can also create new items by clicking and dragging existing items while holding down the Cir key A copy of the original item is created at the new loca tion Project timeline Gantt chart 74 Moving items There are several ways to move existing items to an other date or row Obviously you can drag one or mul t
37. of contents and add or rearrange individual chapters All agenda slides are automatically kept in sync as you edit the presentation Inserting a chapter To start a new chapter of your presentation choose i Chapter from the Elements menu A new slide is in serted after the current slide which contains a new line Chapter The new line is selected so you can imme diately type the name of the new chapter overwriting the placeholder text The new slide is by default titled Agenda which can be changed if desired see Role Model on page 84 Reordering agenda chapters While editing an agenda slide you can change the order of chapters using the following methods select a chapter heading then press A inser to insert a new chapter select a chapter heading then hold Shit A A and use to move the current chapter up or down drag the chapter heading to a new location using the mouse or drag while holding Cir to duplicate the chapter If you move a chapter slides belonging to that chapter are moved along i e all slides between the agenda slide of the moved chapter and the agenda slide of the following chapter In the slide sorter view you can reorder agenda slides or copy paste and duplicate them in the same manner as normal slides If you change the order of chapters all agenda slides are updated accordingly Placing the agenda The agenda element is centered on the slide if you do not change the
38. of the snap points depends on your current zoom level If you hold down the key while dragging the angle of the partition line is constrained to the current angle or to that of a vertical horizontal or diagonal line Scatter chart and bubble chart 66 To make a copy of a partition line hold down the key while dragging This is an easy way to create parallel lines e g to mark a range of values You can change the background color of a set by click ing on the partition line and selecting a background color trom the toolbar To set the background color of the area on the other side of the line right click the par tition line and select Xs Flip Filled Side You can also simply double click the partition line Y Axis 4 0 3 5 3 0 2 5 1 Carrots 2 0 Apples A Oranges 13 1 0 0 5 0 0 X Axis 0 0 05 10 15 20 25 3 0 If you want to calculate the position and angle of the line based on the values in the char see Trendline on the preceding page 13 Project timeline Gantt chart Activity Responsible Implementation hdd PL roro MI and system test 1 i if EE ill Setup of pilots ar en BEE ee oc ie NH qoLOG Pilot installations up and running i mE R Sanderson i i eam 00005 0 a 3 1 i d ARA 1 40 31 13 Chinese EN Merialdo cc AAA translation Mr why raining opor oio od ot gor or d EM IT Support To PAG O o
39. one of PowerPoint s built in scheme colors The attribute vai specifies the color using the values bg1 tx1 accent1 accent2 accent3 accent4 accent5 accent6 dki 1t1 dk2 1t2 hlink folHlink bg2 or tx2 When using schemeC1r the name attribute of the parent solidFi11 element will typically be set to the same value as the val attribute Then think cell will use the name that appears in PowerPoint s scheme colors dialog js depending on the version of PowerPoint and the user interface language Example lt solidFill name accent2 gt lt schemeClr val accent2 gt lt solidFill gt srgbClr A fill based on a color defined using val ues for the red green and blue components The attribute val contains six hexadecimal characters for the three components Example lt srgbClr val FFOOFF gt sdrgbClr A fill based on a color defined using val ues for the red green and blue components The attributes r g and b each contain numbers between O and 255 Example adrgbOlr r 0 g 255 b 0 gt scrgbClr A fill based on a color defined using val ues for the red green and blue components The attributes r g and b each contain percentage val ues between 0 and 100 The percentage values may use integers or decimal numbers with 2 deci mal places and a dot as the separator Example lt sdrgbClr r 0 g 100 b 66 667 gt Style file format 128 prstClr A fill based on the preset color
40. placement To move it you can lock the top bottom left or right edge to a specific position For example if a logo or image is displayed on the left side of every agenda slide you can lock the left edge to leave enough space between logo and agenda and the agenda element will grow to the right to accomo date longer chapter headings You should choose the g correct agenda placement after inserting the first chap ter slide as subsequent chapter slides will then use the same placement automatically First you need to select the whole agenda element Po sition the mouse pointer so that all chapter headings are surrounded by an orange boundary and click once Al ternatively use PowerPoints lasso selection to include all chapter headings Afterwards the whole agenda is highlighted with a blue boundary and every edge shows three handles at both ends and in the center With the agenda element handles showing you place the agenda by dragging one of the handles to the de sired position along one of PowerPoint s rulers Drag one of the handles and a drag target 4 appears at a position along but slightly to the right of the left ruler or slightly below the top ruler When you move the mouse to this position a red helper line and a lock icon will ap pear while dragging along the ruler Once you release the mouse button the edge is locked at that position 4 3 2 1 0 1 is Agenda Second topic Third to
41. removing labels After inserting a new column chart both category la bels and series labels are shown automatically There Introduction to charing 26 are several ways to remove and add labels The easi est way to remove a single label is to select it and press the key The easiest way to remove all labels of a particular type is to select the respective button from the chart s context menu To remove the series label like in our example column chart click a Remove Series Label in the charts context menu To access the context menu of a char move the mouse to a point within the chart s rectangle where there are no other objects and click the right mouse button Read more about editing text labels in the chapter Text labels on page 32 2013 2014 2015 Entering chart data When you select the column chart a datasheet button Open Datasheet is displayed in the bottom right cor ner of the chart Click the datasheet button or simply double click the chart to open the datasheet The datasheet opens au tomatically after insertion of a new chart Now enter the data from our example column chart into the datasheet Type in only the actual numbers Do not round numbers or calculate totals think cell will do this for you For most chart types you can simply input the numbers the g way you see them in the scribble from left to right and from top to bottom The tab key can be used just as in Microsoft Excel
42. rounded solution exists Formulas involve other operations like multiplication or numerical functions Also summations where the same addend appears more than once are mathe matically equivalent to a multiplication You use different precisions in the second parameter of the TCROUND function You make frequent use of the specific func tions TCROUNDDOWN TCROUNDUP and TCROUNDNEAR You can try to restate the problem to get a consistent solution Try the following Use a finer precision for some or all TCROUND state ments Do not use TCROUND with multiplication or numerical functions other than and SUM Use the same precision second parameter for all TCROUND statements A Excel data rounding 107 Use TCROUND instead of the more specific functions TCROUNDDOWN TCROUNDUP and TCROUNDNEAR wherever possible Appendix A Deployment guide This chapter describes how to deploy think cell in a larger organization If you want to install a personal copy of think cell on your computer please refer to Installa tion and update on page 11 Workstation prerequisites To install and run think cell the following software must be installed Microsoft Windows Vista 7 8 8 1 or 10 Microsoft Office 2007 SP1 2010 2013 or 201 6 with at least the following components Microsoft Office Excel Microsoft Office PowerPoint Visual Basic for Applications trom Office Shared
43. server think cell must be installed with the UPDATESURL command line option specifying the location of the update XML file see Initial installation on page 108 e g UPDATESURL http example com update xml The update XML file must contain a list of scenarios with each scenario consisting of a set of conditions and the corresponding URL of a setup file The first scenario whose conditions are met determines the file that the computer will download and install By applying con ditions such as a list of machine or user names differ ent users can receive different updates For example new program versions can first be distributed to a small group of pilot users before they are rolled out in the whole organization Figure A 1 on page 118 shows a typical example of an update XML file Conditions within the file are written in the Windows Management Instrumentation Query Lan guage WQL which gives access to all relevant system parameters To learn more about WQL go to https www think cell com wql Notification about license key expiration think cell requires a license key and can be used up to and on the expiration date of the license key Deployment guide 116 The software will notify the user about the upcoming ex piration on every start of PowerPoint and Excel if the ex piration date is less than 14 days away It the license key is expiring on the 15th 30th 31st of a month a notifi cation is shown for the first ti
44. the calendar layout One line always represents precisely one month When you are done simply return to the PowerPoint slide by clicking the calendar window s OK button or by clicking on the slide The selected date range will then be applied to the chart If you want to discard your selection and keep the current setting click Can cel or press Esc Alternatively if you only need to adjust the beginning or the end of the range you can simply change these values with the mouse 1 Select a scale e g the bar showing months 2 Click and drag the handle that appears on the se lected scale The current date is displayed as a tooltip while you drag 3 When you drop the handle the chart is rearranged to accommodate the new date range While dragging the handles they snap to integral units of the selected scale You can quickly expand the chart to cover a large date range by dragging the handles of a scale with large units e g years or months 02 02 2014 Sun of Week 05 E Scale display When changing the date range or sss IO nora the size of a chart some scales as zen well as vertical separator lines may appear or disappear Based on the ws p range you select together with the cs l chart size and font size think cell Fit Scale to Data suggests appropriate scales and separators to show To make good use of this function you should first select the desired date range before ma
45. the line chart 42 Add Point Label context menu button If the category values of a line chart are strictly increas ing numbers or dates then the x axis will automatically switch to a value axis see Value axis on page 43 When dates are used the date format can be changed by multi selecting all category labels see Multi selection on page 18 and typing a date format into the control see Date format codes on page 76 If you want to show more labels than would fit next to each other horizon tally you can use label rotation see Label rotation on page 34 The horizontal axis can only switch from category to value mode if the following conditions are met All category cells in the datasheet contain numbers and Excel s cell format is also set to General or Number or all category cells in the datasheet contain dates and Excel s cell format is also set to Date The numbers or dates in the category cells are strictly increasing from left to right The y axis is not set to Crosses Between Categories see Positioning the value axis on page 43 If only this requirement is preventing a switch to the value axis mode you can use M Make Value Axis from the axis context menu to switch to Crosses At Categories and thereby switch to the value axis mode as well The line chart can also display a second vertical value axis Please refer to Secondary Axis on page 47 for fur ther information Column chart line chart and area
46. the mathematical sum of all values will be used to continue the calculation i e for two seg ments of values 5 and 2 the gap between the connec tors on the sides of the column will be 3 At the same time all individual segments are always displayed with the correct extent To visualize the mathematical sum of the signed segments the connector will use an anchor that may not correspond to the top or bottom of any individual segment Due to the complexity of the waterfall chart concept only simple charts can be created by using the datasheet alone If you notice that the chart does not build up the way you want it to first finish typing in the data It is easy to reconfigure the chart later with the mouse In a basic waterfall chart every two columns are con nected by precisely one horizontal connector When selected these connectors show two handles Drag the connectors handles to change the way columns are connected in the waterfall Waterfall chat 56 Remove a connector with in order to start a new summation Add a connector by clicking wA Add Wa terfall Connector in the context menu Based on the initial example in the following chart the connector between the 1st and 2nd columns has been removed 41 35 29 6 mu L5 1 Label Label Label Label Label Label Whenever you drag a connector the entire chart rear ranges to accommodate the change and all equals columns
47. the mouse pointer while holding down the key see Multi selection on page 18 The axes of scatter charts and bubble charts can also be adjusted Please refer to Scales and axes on page 43 for details You may also use dates for the X or Y values When all cells in the datasheet for one axis contain dates and Excel s cell format is set to Date then the tickmark g labels of this axis show dates and you can format them accordingly see Date format control on page 75 Labels In both chart types up to two labels can be associated with each data point Labels can be added using the e Add Label button and removed using the ey Remove Labels button The label content control lets you select the format of the text field for each label allowing the display of the label text as well as the x y and size values see Label content on page 36 By default labels are disabled in charts containing more than 50 data points If required they can be enabled using the context menu The automatic labeler places labels as close to their data points as possible using connecting lines if necessary see Automatic label placement on page 33 The la beler starts as soon as the datasheet is closed restarting when data values labels or sizes are changed While the labeler is busy calculating the label place ments a rotating progress icon appears in the upper left corner of the chart and the concerned chart is high lighted with a light gray frame
48. to insert a full category gap and drag the gap arrow to the right until the tooltip shows 1 Category Gap this has to be repeated for all clusters If there is an even number of stacks in a cluster the label cannot be centered to the whole cluster Use a PowerPoint text box as a label in this case 10096 chart Icon in Elements menu The 10096 chart is a variation of a stacked column chart Column chart line chart and area chart 40 with all columns typically adding up to the same height i e 100 The labels of the 10096 chart support the label content property which lets you choose if you want to display absolute values percentages or both Label content on page 36 2013 2014 2015 With think cell you can create 100 charts with columns that do not necessarily add up to 100 If a column totals to more or less than 100 it is rendered accordingly For details about filling in the datasheet refer to Absolute and relative values on page 29 Line chart Icon in Elements menu KY 5 un Series Series O e N W dA 2013 2014 2015 The line chart uses lines to connect data points belong ing to the same series The appearance of the line chart is controlled by the line scheme marker scheme line style and marker shape controls in the floating toolbar See Formatting and style on page 19 for details on these g controls Labels for the data points are not shown by de fault but may be displayed using
49. to switch to the linked data range in Excel Enter the additional data below the linked range Then select the linked range by clicking on its border to show the familiar think cell user interface Drag a corner of the selection to include the newly entered data Excel data links 93 Finally return to PowerPoint When selecting the linked chart it is flagged to indicate that an update of its linked data has been detected 96 26 31 8 65 2013 2014 2015 2016 Click the v Update button next to the flag to incorporate the data changes from Excel in the chart The chart is updated and the flag disappears 2013 2014 2015 2016 After pressing T Update this button changes to 5 Re vert Click it to take back the changes you just made The Revert button is available until the PowerPoint file is closed or the Excel data source changes again In the later case it is replaced by the Update button Even if the chart is not updated or is updated and then reverted again the link to the Excel data source remains Thus you always have the option to update the chart later You can also let think cell automatically update the linked chart for you This option is available in the Data Links dialog Data Links dialog on the current page Note Linking a chart to data in Excel using think cell does not depend on the file names of the Excel or Power Point file Each chart as well as each data range in Excel is assigned a u
50. using the Interpolate button see Interpolation on the current page Combination chart Icon in Elements menu faf 50 40 30 20 10 0 2013 2014 2015 g A combination chart combines line and column seg ments in a single chart Line chart on page 39 and Col umn chart and stacked column chart on page 38 de scribe in detail the usage of lines and column segments in charts To convert a line to a series of segments simply highlight the line and select the gy Set to Segment Type button from the context menu To convert segments to a line simply highlight a segment of the series and select the Ty Set to Line Type button from the context menu The data sources of line charts stacked charts and combi nation charts have the same format 6 2 2013 2014 2015 This function can be used in stacked and clustered col umn charts as well as in line charts Column char line chart and area chart 43 8 Chart decorations Scales and axes Value axis In menu Chart Menu item Use this feature to display a value y axis Note The x axis of a Mekko chart is also a value axis Similarly scatter and bubble charts have two value axes that are always displayed In addition the x axis of a line chart may be a value axis rather than a category axis see Line chart on page 39 The x axes of all other charts are standard category axes Adjusting the scale of a value axis When selected a value axis
51. xr a tado ad e da 49 PO D 53 Waterfall chaft e esset deberes rins mda USUS We ek oS Eu ierdie deum id qued pd Ss 54 Percent of datasheet 100 as label content 56 Mekko cha ood cd Ei e ES 58 Mekko chart with 96 axis sce RR RR RR txt 4444444 ss 58 Mekko char with OPE sr e CREE EUR EIS URL CR TEC deo ee a er re 59 donc O 59 XE Ego oS es ed ES PRECEPIT 6 Scatter chart and bubble chart ccc a 62 Eais ra o oe Le bee de E E La ee eae oo a oe ees oa ae ae ena 63 OEP ONO 446 heideceaua hued asew oh baw hb ie eh eS ER edit vdd dtd bok adrndew n ca aed d gp ac es 63 Bubble chart 64 Trendline and partition x i ern eee A e 64 Project timeline Gantt chart o o ooooooooooror Rr hrs 66 Calendar SCONE ia NUR DI hae Se 66 A 69 Contents 6 AA 72 DOS Tomo DOCDIAD o c rr dre ede d EO I i ibi ee re gp UE dt bss 5 Language dependency qi seconde does deban e a dope te og Rr do c RO on Re blc ean be bee c cea 6 B acqui es ou re cies oe ie eo eee saw ITem 76 Layout 14 lniroduchoni DUBIE cosi oe ace esti eee ee ier deed eeu ewe Oe eh eee dee hb eee ee ed ees 78 13 BS EIS coe ee dae hide ee eee In 79 Pet C POSUI ou ccr Be ree ee HOE Re ded Ede re eee See ad 79 Rounded RSCG Oca c vk asser retira da abaratar sario ee hed bw eve Re des 9 No edes Porro 2 NEMPE 9 35 0 MOMM
52. 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 01 02 03 04 05 06 OF 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 OK Cancel Today s date is marked red Select the desired start date with a single click and select the desired end date with another click while holding down Ship You may also just hold down the mouse button and drag the mouse along to deter mine a range In the upper right corner you will find additional information about the selected period Alternatively you can use the cursor keys and to select a different date range To expand the range hold down while moving To edit a date range you can grab its beginning or end and drag it to the desired date To scroll the calendar one line at a time use your mouse s scroll wheel click the scroll bar arrows or drag the scroll bar handle To scroll the calendar one page at a time click onto the scroll bar above or be low the handle To jump to an arbitrary date select the desired month and year using the controls in the window s toolbar You can simply type in the desired year if you do not want to use the control s up down buttons The calendar immediately scrolls to the desired position You can vertically resize the window to see more months at a time and you can horizontally resize the Project timeline Gantt chart 68 window to adjust the font size The width of the win dow does not have an impact on
53. 175 gt lt prstDash val solid gt lt 1n gt prstDash A line style based on the pre set line styles defined in the Office Open XML standard The attribute val specifies the line type using the values solid dot dash lgDash dashDot lgDashDot lgDashDotDot sysDash sysDashDotDot which correspond to the Office Open XML standard sysDot sysDashDot g msdn microsoft com en us library documentformat openxml drawing presetlinedashvalues aspx Example lt prstDash val solid gt Choices in the line style control InLst A list of lines described by one optional in stance of the element noLine and at least one in stances of the element 1n The lines defined in this list are shown in the line style control of the floating toolbar see Line style on page 21 Example lt lnLst gt lt ln 1nLst To describe each entry in the list the w attribute of the 1n element is converted to points e g 3175 EMU to 1 4pt and displayed together with a visual representation of the dash type noLine When the user chooses this special line style from the line style control the line has no fill color The attribute name contains the name used in the line style control This element may appear only once within the list of lines Example noLine name No Line gt Style file format 130 Markers marker marker with a certain shape The attribute name contains the name shown in the marker style
54. 3 d tod pol Fontoura Visual Media 1 9 27 13 A ia i A EM E Fontoura TEE 10 11 13 10 25 13 12 3 13 1 Bachmeier Consultants 1 ee Ii REM GI Fontoura i 110 14 13 10 28 13 12 16 13 Gorman Rollout MA IEE Preparation ee Pte gt N Sanderson Execution ES a EEC R Sanderson Evaluation BN A tates as rot E 5 NE 10 13 13 Certification ofi ij EN i H WEM bod de Graaf a ot is 1 poso 4 1 binaryimagecomplete i EN Jr g ngoing evatuation i Pd A O dodi m Monthly steering 9 TE committee 9 10 13 30 8 13 11 5 13 12 3 13 11 7 14 p gt 4d 9 10 13 Xmas Launch 1 13 14 a Icon in Elements menu ac mm A project timeline sometimes called Gantt chart visu alizes project activities The scale of a project timeline is a calendar The duration of activities is represented by bars or process arrows whereas singular events are represented by milestones Calendar scale Naturally in a project timeline the scale is based on dates With think cell you can quickly change the visi ble date range The appearance of the scale is initially automatic but can be manually modified if needed Modifying the date range When inserting a new project timeline the calendar is initially scaled to show some time before and some time after the current date There are two ways to change the date range that is shown You can open a calend
55. 6 in time zone UTC 1 T separates date and time Changing the language Setting the language correctly is crucial if you wish to use PowerPoint s spell checker think cell adds extra options g to let you change the language of the text in a slide or in a complete presentation These options can be found in the Language menu item in the Review tab Simply select the desired language in the dialog and click either on Text on Slide to change the language of all text on the current slide or on All Text to change the language of all text in the presentation Changing fonts Changing the font of text within a large presentation can be a lot of work think cell s Replace Fonts tool can be used to greatly simplify the task The tool can be ac cessed in the Format menu of PowerPoint or the Edit ing group on the Home tab of the PowerPoint ribbon It replaces PowerPoint s Replace Fonts dialog The drop down boxes in the dialog can be used to select the font to replace and the new font and the font size can also be optionally adjusted Select the scope for the changes either Entire presentation Current slide or Selection and then click Apply to replace the fonts or click OK to close the dialog as well Automatic case code You can add a textbox to the master slide that always shows the file name or alternatively file path of the pre sentation If the file name is the same as the case code used to identify a project in your organi
56. 60 A Mekko chart with units sometimes also called subma rine chart or olympic chart is a two dimensional stacked chart As in the regular stacked chart the value axis and the datasheet of this chart are based on absolute values Width and height are controlled completely indepen dently Column widths are entered in the Width row on top and individual segment heights are entered as in a regular stacked chart Series 300 200 60 Series 90 64 79 Series 46 47 79 Series 6 9 22 1 2 3 4 5 6 Ridge In menu Chart Menu item Lal You can highlight the outline of the Mekko chart Click the hal Ridge button to add or remove a bold ridge Apples Oranges Pears Mekko chart 61 11 Pie chart Icon in Elements menu A pie chart is actually a special case of a 100 chart with only one category column of data Series 1 Series Series Each slice of a pie chart shows three handles when se lected Each of the handles can be dragged with the mouse to rotate the pie When rotating the handles snap at positions 0 90 180 and 270 making it easy to create an aesthetically pleasing layout The pie chart remembers which handle you were drag ging when rotating the chart and preserves the correct orientation even when the data is changed In addition you can drag the handles away from the pie in order to emphasize the respective pie slice Series W 19 pSeries Seri
57. C de d GRUPPE ER SEE 103 Treoblementina OUD GaN gt ctas y ORI SUI dra paolo andado RR E EDI CR d i dn 105 Appendix E o AR 108 Workstation prerequisifes esae sucks mr da A a a a da E 108 Contents 8 IL vi e TET ETT TET TOT OE OE QUO POET di ie od e pda tasa iaa 108 in 114 Notification about license key expiration oooooooooomooorrr RR es 115 CIENCIAS 5 cuo ore tur arb a9 E ses lod ut Hui qr RE UI ANN Lee Roi renee 116 Exchanging files with PowerPoint 0 0 0 0 0 cece ee e hrs 119 Loading files from think cell in PowerPoint RR een es 119 Reimporting think cell elements trom PowerPoint oo oooooooooo e 119 Customizing Minkels uad rice bete adea ede E Ene erae PE dd ter ded crx ede d 121 Creating a Tel S ie cr bor pat adem acd nn odo died o di dc e Cd Rod a bom dod cea e od aeo uc 122 e o 123 Dos oh E oa pa dr RP en ae Ae ee Oe ee i a 123 BE ne AAA 123 vou wn kg MMNEMMCTTC 126 Defining colors line styles and Markers oc ede succes ex ews enews bed hae TERCER CHER Rc C o bee v edes 126 Using colors lines and markers in scheMeS 1 ee errare 130 Lun EDEN IS osa ah os tur ke en ee ae VOD Ruth Ser Re ee Se a ee 132 US OE II otis ad Re dolos Bee ep eh UE he ee BL Ele D OR Ee ER UA ER eco ia 133 Customizing Harvey ball and checkbox o oooooooooorrr RR n nee ns 135 Programming
58. Clr val black gt lt fgClr gt bgClr Describes the background color of a pattern fill See gcir Choices in the fill color control fillLst A list of fills described by multiple instances of the elements noFill solidFill Or pattFill The fills defined in this list are shown in the color con trol of the floating toolbar see Color and fill on page 19 Example lt fillLst gt lt solidFill lt fillLst gt noFill When the user chooses this special till trom the color control e g for a segment the segment has no fill color The attribute name contains the de fault name used in the color control which cannot be changed Style file format 129 lt noFill name No Fill separator A horizontal line in the color fill line or marker list shown in the floating toolbar Example lt separator gt Lines In A line with certain weight based on a line type Line styles are used in line charts see Line chart on page 39 as well as for Universal connectors see Universal connectors on page 52 and water fall connectors see Waterfall chart on page 54 The attribute w describes the weight of the line The value for this attribute is noted in EMU English Met ric Unit 12700 EMU are equivalent to a line weight of 1 pt The attribute name contains a name used to reference this line style The line type can be speci fied using the child element prstDash Example 1n name Solid 0 25 pt w 3
59. Features Microsoft Graph from Office Tools The installation of think cell requires about 80 MB of disk space Initial installation The think cell installation files setup msi and setup exe understand the same parameters as Win dows msiexec command though not all combinations are recommended and supported Note that there is only one installer and think cell will use 32 bit or 64 bit as needed Use the setup exe if users shall install think cell by double clicking the setup file Use the following approaches for scripted or command prompt installations or if you need to force certain in stallation options Per machine setup msi qn TARGETDIR lt absolute path gt The executing account needs full administrator per missions e g when using a script started by remote maintenance software or when starting the installer from a command prompt which was launched with Run as administrator The installation will abort if the account has insufficient privileges Omit the ALLUSERS parameter g The other parameters are optional The qn parameter suppresses the Windows lIn staller user interface The default destination directory is APROGRAMFILES Nthink cell on 32 bit Windows systems and PROGRAMFILES X86 think cell on 64 bit Windows systems lf you set a different path with the TARGETDIR parameter make sure the destination is in the per machine context f you prefer you ma
60. Gray Bl tc Green Smoke 10 Smoke 20 Smoke 40 Bl Smoke 60 lll Smoke 80 Bl Smoke 90 White Light Gray Med Gray Bi Dark Gray B Black Light downward diagonal Y Light upward diagonal XN Wide downward diagonal Y Wide upward diagonal Dark horizontal Ill Dark vertical Outlined diamond 2 Diagonal brick R187 G224 B227 Custom Accent 2 v 3 pt 2013 2014 2015 Note that the labels automatically turn white to make them easier to read on the dark background Finally the numbers in our example chart are still dis played with incorrect precision According to the scrib ble they should be rendered with one decimal place precision We simply have to select one of the segment labels and the floating toolbar changes to include the Number Format control By typing the decimal place into the number format box you can specily the desired display format and it will be applied to all numbers of the same type in the chart Alternatively you can click on the arrow and select the 560 2016 g desired format from the drop down box Note that the actual numbers you type or select do not matter they only act as an example of the required formatting read more in section Number format on page 35 560 3 179 3 vwix100 v Abs 26 4 _ Ewan 2013 2014 2015 2016 The scribble on page 24 is now represented by a clear professional looking chart As you
61. PS to the think cell server Of all the information transmitted only the Minidump essentially memory content could potentially contain actual slide content fragments But in its operation think cell never stores actual slide content Storing text or images is completely left to PowerPoint Therefore it is very unlikely that the Minidump of the memory used by think cell contains any sensitive information You can test the error reporting mechanism by typing errorreporttest into any textbox within PowerPoint A message box confirms that an error report has been sent Automatic error reporting can be enabled or disabled by appending one of the following REPORTS options to the installation command line see Initial installation on page 108 REPORTS 0 Disable automatic error reporting REPORTS 1 Enable automatic error reporting Trouble shooting and critical errors In case of critical errors the user is asked whether he or she would like to file a support request think cell 6 build 23033 32 bit teaddin tcaddin layoutaddin pptdocwnd cpp 3361 This is only a test ID 14182974 Attach Following slides O all Current slide Request Support Ignore These support requests can also be sent manually Trou ble shooting on page 12 It is possible to change the default e mail address for support requests Append the following parameter to the installation command line see Initial installation on page 108 SUPPORTEMAIL sup
62. PTCC E 81 Gece heme 6 iscsesurasbenure race ee iSc de uahies vaned b Ge GALA A CRY edem ead 81 Recordar GOSS Chipre no voceeeksene e PSOE P EVEN Paw rra ide 81 Placing he AA 81 Multi level hierarchy Or CNO uou racio acte on cR URGERE back Re eee a dO OR ede pon 02 Multiple agendas in a single presentation o ooooooooooooooomrrr RR 83 Inserting a table of contents o ooooooo e he e res 83 U AS 83 Ui te ra eh Ge eb het ede ara oS ee ay Hh ee ee ee ot 84 DUE UV asa aes sk oh ek ea ee a ee 84 17 Presentohon TOUS os 22256420545 eorrrra nidad roseta ops 86 A OM DEN LL uu dd a rias a da Vd dada UE NES RP EAE E dvd Su S 86 Contents 7 Save and send selected slides 0 eee RR un 86 Arc 3o dk dolce rd EO E C ORC Red UE Yt f oim Ed BO deo FOR ETA ois 86 Si A 87 PU bes laco so rs ce heer eee eh PUR eee ebb eva Ge ew yoo ES 87 Pere Ine A 88 Excel data HB Bess duc SL uon 1 wa oru DO IPAE EHE n rote uda Re Rc qe Pur o SUR s Jo ERE SUR UU S n ed de t ons 90 ene Pr EBD A 90 Tea inked GIS issus a ra A e di y eroe e Vere el a aa il ida Rr Kee d 91 OOOO Inked CUNT seriste rak wo rociado rotar dara iio 92 E AS CET TOT II hey E E a E E E 23 Maintaining data A 94 near nl RETIRER TETTE TT TITO COT ER T TE TOTO OTT a IT 96 Frequently asked questions ccc ce RH res 97 19 Excel dale o A 101 ND Ru uis UNES PIS MEE ap TET ITE IET TEES I LOEO COLO ETT TL T TOIT 102 Lnetiops or mme cel ice a a o
63. Point file without the linked Excel file s being available linked charts simply behave as regular charts with an internal datasheet Using think cell you can change the chart s design and data without restriction Similarly you can freely edit an Excel workbook without the linked PowerPoint file s being available With think cell installed any linked data ranges that are not cur rently connected to an open PowerPoint presentation are highlighted with a light red frame Excel data links 96 As soon as you open both the data source in Excel and the chart in PowerPoint at the same time the link is reestablished In Excel the highlight of the linked data range changes from red to green In PowerPoint the chart s current data is compared to the data source It changes are detected the chart is highlighted in the data links dialog and it is tlagged when selected You can now manually update the chart to the latest data from Excel Changing and removing links To disconnect a chart from its linked data source simply select the button g Break Excel Link from the chart s context menu 560 2013 2014 2015 2016 From that point on the chart only uses the think cell datasheet in PowerPoint Similarly you can disconnect a linked data range in Excel from its charts Select the linked range by click ing on its frame When the frame turns blue indicat ing a think cell selection right click on it and select the X D
64. Ref to describe the background color of the Checkbox the child element 1n i11 to describe the Checkbox s outline and the list of sym bols characters and pictures in the child element choices Example lt checkbox gt lt fillRef name Light Gray 1nfill noLine lt 1nfi11 gt Style file format 136 lt choices gt lt glyph hotkeys xX2 gt lt solidfillRef name Pink gt lt font typeface Arial Unicode MS gt lt t gt amp 10007 lt t gt lt glyph gt lt glyph hotkeys qQ3 gt lt font typeface Arial Unicode MS gt lt t gt lt t gt lt glyph gt lt pic hotkeys uU4 gt Relationship Target up emf gt lt pic gt lt pic hotkeys dD5 gt Relationship Target down emf gt lt pic gt lt glyph hotkeys 0 gt lt t gt lt t gt lt glyph gt lt choices gt lt checkbox gt choices A list of choices to be used in a checkbox The list can contain any number of the elements glyph for characters and symbols and pic for pictures glyph A glyph character or symbol that is used as one of the choices of a checkbox The attribute hotkeys describes a list of hotkey characters that select the glyph The child elements solidFillRef describes the color of the character or symbol ont its font and t the character or symbol itself Example glyph hotkeys qQ3 lt solidfillRef name Blue gt lt font typeface Arial Unicode MS gt lt t gt lt t gt
65. The other parameters are optional qn may be used to completely suppress the in staller s user interface qb displays a progress bar and qb removes its Cancel button The default destination directory is ALOCALAPPDATA Nthink cell It is recommended not to set a different path with the TARGETDIR parameter but if you do make sure it has the appropriate permissions and ownership for the respective account Note With the LICENSEKEY parameter a license key can be specified during installation However see Js Group Policies on page 112 for a better method of distributing the license key which will help with future key updates See Ribbon in Office 2007 and later on page 113 Updates on page 114 and Online quality assurance on page 116 for details of additional options that may be specified on the installation command line Language think cell s user interface is available in English French German ltalian Portuguese and Spanish automatically detecting the user s language preference by using the same language as Windows and Office All supported languages are included in the same unified installation package If a language is not yet supported by think cell English is used It is not possible to alter this automatic language selection behaviour In the setup routine think cell uses the language cor responding to the Windows regional settings After in stallation think cell uses the same language as in the m
66. There can only be a single PowerPoint instance If there is no PowerPoint running one will be started Otherwise the existing one is used Dim ppapp As Object Set ppapp New PowerPoint Application i I I I I Dim i As Integer For i 1 To 10 Modify the range value Note Avoid selecting the cell prior to changing it It ts very slow and has undesirable side effects BAD rng Select ActiveWindow Selection Value O rng Value i Generate a new presentation based on the Linked template Dim pres As PowerPoint Presentation Set pres tcaddin PresentationFromTemplate Excel ActiveWorkbook template pptx ppapp If you want to modify the new presentation before saving it this is the place to do it Save the new presentation pres SaveAs c output amp i amp pptx Explicitly close the presentation when we are done with it to free its memory Letting the object go out of scope is not sufficient pres Close Next End Sub Programming think cell 142 F Keyboard shortcuts Most keyboard shortcuts that you know from Power Point work with elements as well The same is true for keys that modify mouse operations like Ghit 1y click tor additive selection and r drag tor duplication ot shapes The following table shows the keyboard shortcuts frequently used with think cell and the ones that otter additional functionality over Microsoft Power Point Shor
67. a 100 Line Combination n EE Ss 20 A ll a 8 o Pie Scatter Bubble Gantt Timeline Inserting a chart into your presentation is very similar to inserting a PowerPoint shape Go to the think cell group g and click the Elements button Then select the required chart type In our example we want to insert a column chart which is represented by this button fed Once you have chosen a chart type a rectangle will ap pear with the mouse pointer indicating where the chart will be inserted on the slide When you are inserting or resizing a chart you will notice that it snaps to certain locations aligning with existing objects on the slide EHS 0p Presentation pptx Powerl Point 7 0 x FILE HOME INSERT DESIGN TRANSITIONS ANIMATIONS SLIDE SHOW REVIEW VIEW Sign in T 3 Eg Online Pictures In Shapes taf Connector a Pod o Sm separe A ya Screenshot T SmartArt More 5 N Table Pictures Elements Apps for Links Comment Tex Symbols Media Slide B e Photo Album pi Chart Office Slides Tables Images Illustrations gt 2 E a E 3 i Phase 1 Phase 2 Company A SLIDE900F90 X ENGLISH UNITED STATES NOTES Mf COMMENTS ZN NE c 277055 The chart is automatically selected after insertion as in dicated by a blue highlighted outline If a chart you want to modity is not selected you can select it by clicking on it Adding and
68. ains the linked data Time stamp of the last modification of the linked data Update or Revert button The linked Excel file must be open for these buttons to be available Auto checkbox indicating whether or not the chart is being updated automatically as soon as changes in the linked data are detected g The chart entry appears in bold when an update is pending You can leave the data link dialog open while you con tinue editing your slides and data Using the data links dialog you can efficiently manage all linked charts and their data sources Click on the heading of any of the described columns to sort the list of charts by that column Single click on a row to select the chart in Normal view or the slide in Slide Sorter view Double click on a row to create the same effect as a double click on the chart itself The linked Excel work book is opened and the linked data is selected If the data source is not available the internal datasheet is opened instead The Update and Revert buttons are the same as the ones in the upper right corner of the chart Click the Update button to incorporate data changes from Excel in the PowerPoint chart Click Revert to undo the update and return to the chart s previous state You can also click Revert to undo the latest automatic update Check the Auto checkbox to let think cell automatically update the chart whenever changes in the linked data are de
69. ant of the scatter chart with data points marked by circles The circle sizes are deter mined by the values in the Size column By default the Size value is proportional to the area of the circle The 5 Make Diameter Represent Size button in the context menu can be used to set the Size value to be propor tional to the diameter of each circle To enable a legend of the bubble size click s3 Add Bub ble Size Legend in the chart s context menu To change the bubble size used in the legend select the bubble and drag the handle that appears on the right boundary When you select one of the bubbles inside the chart a similar handle appears on the right boundary Change the bubble size by dragging it All other bubbles are scaled accordingly as the ratio between bubbles is al ways determined by the numbers in the datasheet s Size column Scatter chart and bubble chat 65 When two bubbles overlap the smaller bubble will be shown in front of the larger one To change the order choose Bring to Front from a bubble s context menu Trendline and partition In menu Chart data point Menu item E Trendline In scatter or bubble charts you can let think cell calcu late a trend line for a group of values A trendline is a graphical representation of trends in the group They are used for the study of problems of prediction also called regression analysis The trendline is calculated using linear regression so that
70. ar and select the dates you want Double click on a scale e g the bar showing months to open the calendar dialog Alternatively click the Open Calendar button in the chart menu July v 2013 2013 July August 3 September October November 44 December Mi Ya S TES 01 02 03 04 05 06 07 01 02 03 04 0i 36 01 MN TP Ss 08 09 10 11 12 13 14 05 06 07 08 09 10 11 02 03 04 05 06 07 08 04 05 0 PSICO 213 AS G a SO ZO 21220239 49 02 03 04 05 06 07 08 cy MTWTFSS MIO 15 16 17 18 19 20 21 2 22 23 24 25 2 27 284 12 13 14 15 16 17 18 CAROS s 0510 11 12 13 14 15 16 17 18 19 20 21 22 T4015 Mo SAS O 021022023224025 026 09 10 11 12 13 14 155 16 17 18 19 20 21 22 10 weeks 5 days 10 09 2013 24 11 2013 M TW TF S SEREI 29 30 31 26 27 28 29 30 31 23 24 2526 27 28129 40 30 4 25 26 27 28 29 30 23 24 25 26 27 28 29 3081 2014 January February March Ie UW MW aS 01 02 03 04 05 01 02 9s 01 02 AA ees 06 07 08 09 10 11 12 03 04 05 06 07 08 09 gt 03 04 05 06 07 08 09 MTWTFSS AI 13 14 15 16 17 18 194021224220 10 11 12 13 14 15 16 17 18 19 20 21 22 23 py 10 11 12 13 14 15 bey 18 39020021 22 23 1 MTWTF S SUMI 27 28 29 30 31 24 25 26 27 28 24 25 26 27 28 293051 April 7 May 18 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 FO 20 21 22 23 24 25 26 27 28 29 30 31 June 22 01 02 03 04 05 06 07 08 09 10 11 12 13
71. are updated Also based on the previous example in the following chart an equals column has been added and both ends of the highlighted connector have been moved 41 Label Label Label Label Label Label If connectors are conflicting with each other skew con nectors will result Remove some of the skew connectors to resolve the problem For example to create a build up waterfall with the total on the left enter the following data into the sheet f The resulting chart looks as follows am 4 Now drag the right handle of the highlighted connector to connect the equals column with the top of the last segment This is the resulting chart 9 If you want to create a build down waterfall chart use the y toolbar icon The default datasheet is then filled with values appropriate for a build down waterfall Apart from this there is no difference between a build up and a build down waterfall chart in think cell Waterfall charts can be decorated like column charts You can decorate axes add arrows change gaps etc see Scales and axes on page 43 and Arrows and values on page 49 By default the segment labels in waterfall charts show the extent of the segment which is always a positive value Negative values in the datasheet are represented visually by downward going segments However you Waterfall chan 57 can select a positive number and enter a leading or trail
72. ars to this row you cannot move it by drag and drop and you cannot delete it Otherwise it is just an additional activity row which is always there Adding and removing rows To insert a new row select an existing row and use the E Insert Row button in the think cell context menu Al ternatively press Ali inse If all other rows are deleted there is still the extra row left at the very bottom of the chart which you can click to open the context menu and create new rows The keyboard shortcut Ai F nser also inserts new rows while editing labels and the first label of the newly in serted row is automatically selected This way you can g add rows and keep typing without reaching for the mouse Likewise you can use AM and the cursor keys to move the cursor across labels You can also use the X Delete button in the think cell context menu to delete an entire row The keyboard shortcut for deletion is Delete Row features Each row not only contains timeline items bars pro cess arrows milestones brackets but can also have up to three labels a horizontal separator line and row shading The labels and decorations are added and re moved using the think cell context menu To open the menu move the mouse outside of the chart s date range area and right click on a row when it highlights Note When you right click a row inside the chart s date range area another menu opens that allows for insertion
73. ars when the mouse pointer is over it When you click it the frame turns blue to mark it as the currently selected feature Additionally a floating toolbar might appear lt contains a set of property controls you can use to give the feature a different look It is a good idea to explore a newly inserted element to get an overview of the features it is made of and their properties When you right click on a feature its context menu ap pears You use it to add additional features to the ele ment or remove those currently visible Series Series Series 2013 2014 2015 Buttons whose functions are unavailable for the current selection are greyed out The context menu of the entire element is invoked by right clicking the background of the element Features always belong to their respective elements and can themselves have further features As an example the vertical axis of a line chart is a feature of the chart itself while the tickmarks along the axis are features of the axis Consequently you use the chart s context menu to switch on or off the vertical axis and the axis context menu to toggle whether tickmarks are shown There are several ways to remove a feature Left click the feature to select it and press the or key on your keyboard Right click the feature to open the think cell context menu Click the X Delete button to remove the fea ture from the element Open the think cell context menu th
74. as is g To use the single quote character itself type two single quotes Language dependency The project timeline chart is language dependent The display of full or abbreviated month names as well as names for weekdays the default headlines for the activ ity labels and the default text for scale labels depend on the proofing language setting for Office This setting s value is used at the time when the elements are inserted You can alter the language used for language depen dent elements as follows 1 Alter the setting to the desired language by a clicking into a text box b choosing Review gt Language gt Set Proofing Lan guage C selecting the desired language in the dialog d clicking on Default and confirming with Yes e closing the dialog with OK 2 Use the appropriate context menu to remove and then re add the language dependent labels that you wish to update 3 Use the Scales menu to first hide and then re show the scales that you wish to update Code d dd ddd dddd ddddd WW MM MMM MMMM MMMMM qq 299 yy JIII Backslash Project timeline Gantt chart 77 Date format codes Description day of month day of month two digit day of week abbrev day of week full day of week single character week of year week of year two digit month number month number two digit month name abbrev month name full
75. at you used to add the feature Click the same button again to remove it Note You cannot remove data segments from a chart element in this way All data segments shown are con trolled by the internal data sheet If you delete a cell from the internal datasheet the corresponding data segment is removed from the chart element Basic concepts 19 Note Buttons which toggle the presence of a feature e g if series labels are shown in a chart or not change their state accordingly For example after you have cho sen SI Add Series Label to add series labels to a chart element the button changes to Remove Series Label In the following generally only the state of the button for adding the feature is shown Detailed information on all the available features is pro vided in the following chapters accompanying the re spective elements they apply to Multi selection You can quickly select a range of features that belong to gether this is called logical multi selection It works the same way as with files in Microsoft Windows Explorer Select the first feature in the desired range with a single left mouse button click then hold down and click the last feature in the range When you move the mouse while holding down Shift t the range of features that is going to be selected is highlighted in orange To add single features to the selection or to remove single features from the selection hold down Cir while clicking A
76. ate mechanisms refer to the contents of the online help of the Group Policy Management Console think cell s specific configuration options are de scribed in the think cell adm and think cell admx administrative template files which are located in think cell s installation directory in the subdirectory admin policy templates To make use of the new options depending on the file type for think cell adm In the Group Policy Object Editor use Add Remove Templates under Action for think cell admx Copy think cell admx and en US Mhink cell adml from admin policy templates to SYSTEMROOT PolicyDetinitions and SYSTEMROOT VPolicyDetfinitions en US re spectively Deployment guide 113 A new node think cell is added to the node Administra tive Templates in the following two places the think cell settings configured under Computer Configuration deter mine registry entries at HKEY LOCAL MACHINENSOFTWARENPoliciesN gt think cell and the think cell settings configured under User Config uration determine registry entries at HKEY CURRENT USERNSOFTWARENMPoliciesN gt think cell If settings are enabled at both places those under Com puter Configuration take precedence The items of the node think cell show the available set tings that can be controlled with group policies Each item has a description with the available values for this item You can use group policies to activate or deactivate think cel
77. ation of some activity Process arrows are similar to bars but contain text They grow and shrink vertically with the amount of text they contain To create an aesthetically pleasing layout all process arrows of a Gantt chart are resized to the same height if possible Milestones mark singular events Brackets are used to label periods of time which typ ically comprise multiple activity bars Project timeline Gantt chart 73 Shades are used to visualize non working times such as weekends or holidays They are usually labeled by an additional bracket below the chart Adding items To add an item to the chart move the mouse across the chart s date range area A crosshair helps you to track the row and date you are pointing at and a tooltip provides precise date information The dates that can be selected depend on the chan s date range and size and on your current zoom level If days are too small to be pointed at individually the crosshair snaps to firsts of weeks and firsts of months If even weeks are too small to be distinctively selected the crosshair only snaps to the beginning of months Wherever the crosshair appears it is possible to insert a new item When you move the mouse over existing items the crosshair disappears and the tooltip reflects that item s date or date span Activity Implementation and system test Setup of pilots IT integration Internationalization Training M
78. be rotated after insertion using a rotation handle Simply select the element and drag the rotation handle to the desired position Click with the left mouse button on the rotation handle and while holding the button down drag the handle to one of the four possible red highlighted positions and release the button 2013 2014 2015 Resizing elements When an element is selected resize handles are shown at the corners and in the center of the boundary lines To resize an element drag one of these handles You can also set two or more elements to the same width or height This also works if you include Power Point shapes in your selection First select all objects that you want to set to the same width or height see Multi selection on the next page Then choose E Same Height or li Same Width from the context menu of an Basic concepts 18 element included in the selection All objects will be re sized to the same height or width respectively 2015 The height or width of all elements is set to the largest height or width among the individual elements Selecting elements and features think cell s elements often contain individually se lectable parts that we call features For example a chart element consists of the segments corresponding to the values in the datasheet and may also contain labels axes difference arrows connectors and so forth You can distinguish a feature by the orange frame that appe
79. bel use its context menu or simply delete all text from the label it will then disappear To remove multiple labels at a time it is offen convenient to select all desired labels using the mouse together with or Ct keys see also Multi selection on page 18 Then choose the delete option from the context menu or press the key to remove all selected labels Labels spanning multiple rows In both responsibility and remark columns each label can refer to more than one activity Drag the handles that appear next to the label when you select it to de termine the activities it refers to You can only drag a label s handles across rows that do not already have a label in the same column and you cannot drag the handles across horizontal separators Responsible R Sanderson erialdo Se ii Ip and running Lx ot 3 31 13 Chinese nslation Mr Whu A bracket will automatically appear as soon as a label spans more than one row In this case you are free to remove the bracket by selecting it and pressing Delete or via the bracket s or the label s context menu ae e Responsible R Sanderson erialdo T em um ME NE Du pop Ip and running H H l 31 13 Chinese nslation Mr Whu Timeline items There are several types of items used in a project timeline to visualize periods of time and events The following items are supported by think cell Bars show the dur
80. bon group by the term think cell toolbar Using the think cell toolbar you can call most of think cell s functions Note We will also uniformly use the term Elements but ton to refer to the button Elements in PowerPoint and the button Charts in Excel After clicking on the Elements button the symbols in the first two rows represent basic elements see Basic ele ments on page 9 and agenda slides see Agenda on page 81 while the other rows represent chart types see Introduction to charting on page 24 The following elements are available iu ii ii hl s O z5BRIILIDERE m EMEN a e A Ho OU Known as column or bar chart 100 column or bar chart clustered column or bar chart build up waterfall chart build down waterfall chart Mekko chart with units Mekko chart with axis area chart area chart with axis line chart combination chart pie chart scatter chart bubble chart project timeline or Gantt chart table of contents chapter split agenda pentagon chevron rounded rectangle Harvey ball checkbox Page 38 39 38 54 54 58 58 4 4 37 4 61 63 64 66 83 81 83 79 79 79 9 Basic concepts 16 Furthermore there are f universal connectors to con nect the elements see Universal connectors on page 52 for more information And finally More offers additional valuable tools see Presentation tools on page 86 to facilitate your daily work with PowerPoint Insert
81. cel s 3 D references to other sheets and links to other files do also work Placement of TCROUND functions Since TCROUND functions are meant to control the out put of a cell they must be the outermost function Bad TCROUND A1 1 TCROUND SUM B1 E1 1 Good TCROUND A1 SUM B1 E1 1 Bad 3 TCROUNDDOWN A1 1 Good TCROUNDDOWN 3 A1 1 If you happen to enter something along the lines of the bad examples think cell round will notify you with the Excel error value VALUE Limitations of think cell round think cell round always finds a solution for arbitrary sum mations with subtotals and totals think cell round also provides sensible solutions for some other calculations involving multiplication and numerical functions How ever for mathematical reasons the existence of a con sistently rounded solution cannot be guaranteed as soon as operators other than and SUM are used g Multiplication with a constant In many cases think cell round produces good results when constant multiplication is involved i e at most one of the coefficients is derived from the result of an other TCROUND function Consider the following exam ple B C 1 TCROUND 1 3 0 TCROUND 1 4 0 TCROUND 3 A1 B1 0 The precise calculation for cell C1 is 3x 1 3 1 4 5 3 This result can be met by rounding up the value 1 4 to 2 1 1 2 5 However think cell round can only cheat by rounding up or rounding down Further de
82. chart 41 Smoothed lines IF you preter a smoother appearance of the lines in a line chart you can turn on this setting First right click on the desired line then use the Set to Smooth Line button Error bars Error bars can be used to indicate deviations By means of the error bars the following chart can be created 7 6 5 Mean 1 0 2013 2014 2015 2016 1 Create a line chart with three series The first series reflects the upper deviation the second series re flects the mean and the third series reflects the lower deviation 2 Right click the center line and choose 4 Add Error Bars from the context menu 3 Remove the series labels for the upper and lower series Select one of the error bars to change the marker shape and color for the upper and lower deviation and the line type of the bar for all error bars You can also select an individual error bar marker to change the properties for this marker only g A handle appears at each end when you select an error bar You can drag these handles to select which lines the error bars should span You can also visualize intervals instead of the deviation around a central value if you set the error bar to only span two adjacent lines Interpolation In line area and area 100 charts the Interpolate button can be used to display a chart with linear inter polation used for any missing data values in a series In line charts interpolation can be enabled
83. ct Set tcaddin _ Application COMAddIns thinkcell addin Object The following sections describe the available func tionality UpdateChart UpdateChart Name property control Available in the floating toolbar for a chart see For matting and style on page 19 you can set an arbi trary unique name to identify the chart when calling the function UpdateChart to update the data for the chart Signature tcaddin UpdateChart pres As PowerPoint Presentation strName As String rgData As Excel Range bTransposed As Boolean _ Description This function updates the chart strName in pres with the numbers contained in rgData The range rgData must contorm to the layout described in Creating a chart from Excel on page 90 g The char name strName is matched case insensitive It must have been previously assigned in Power Point using the UpdateChart Name property control described above It the chart is linked to any Excel data range when invoking this funtion the link is broken Afterwards the chart will not be linked to any Excel range Example To use this sample in Excel s Visual Basic for Appli cations window go to Tools then References and add the Microsoft PowerPoint Object Library When Option Explicit appears in a file you must explicitly declare all variables using the Dim or ReDim statements If you attempt to use an undeclared variable name an error occurs at compile time Use
84. ctions other than the ones mentioned above to connect results from TCROUND statements think cell round cannot integrate the components into one interconnected problem Instead the components of the formula will be taken as distinct problems which will be solved independently The results will then be used as input to other formulas In many cases the output from think cell round will still be reasonable There are cases however where the use of operators other than SUM and AVERAGE leads to rounded results which are far off from the result of the non rounded calculation Consider the following exam ple A B C 1 TCROUND 8 6 0 TCROUND 1 7 0 TCROUND A1 B1 0 In this case the precise calculation for cell C1 would be 8 6x1 7 14 62 Since cell Al and cell B1 are con nected by a multiplication think cell round cannot inte grate the formulas from these cells into a common prob lem Instead after detecting cell Al as valid input cell g B1 is evaluated independently and the output is taken as a constant within the remaining problem Since there are no further constraints value 1 7 from cell B1 is rounded to the nearest integer which is 2 At this point the precise calculation for cell Cl is 8 6x2 17 2 This is the problem that think cell round now tries to solve There is a consistent solution which requires rounding up 17 2 to 18 The result looks like this 1 9 2 18 Note that the rounded value in cell C1 w
85. d the data in Excel will then automati cally connect When updating the chart with the linked data any changes you made to the data in the internal datasheet will be overwritten How can use the internal datasheet instead of the linked Excel data source To disconnect a char from its linked data source use the E Break Excel Link button from the chart s context menu From now on the chart only uses the think cell datasheet in PowerPoint You can remove the link from a chart whether the linked Excel data range is currently open or not For the Excel side of the data link breaking the link of a chart has the same effect as removing the chart For further information read section Changing and re moving links on page 95 How can enable or disable Auto updating Go to the More menu and open the Data Links dialog This dialog displays a list of all linked charts in the cur rent presentation The Auto checkbox determines if a chart is set to update automatically g When selecting a chart in the presentation the corre sponding entry in the Data Links dialog will be selected and vice versa For a detailed description refer to section Data Links di alog on page 93 Why is my linked chart not updating although it is set to Auto update The PowerPoint side and the Excel side of a data link can only connect when both files are open at the same time Therefore when the data in Excel is changed while the PowerPoint pre
86. ddins thinkcell addin In 64 bit versions of Windows the following additional keys are created Software Classes Wow6432Node CLSID 13EAB3858 A0E0 4A3B A405 F4D525E85265 Software Classes Wow6432Node CLSID gt 1D52B1FA2 1EF8 4035 9DA6 8AD0F40267A1 Software Wow6432Node Microsoft 0ffice gt PowerPoint Addins thinkcell addin Software Wow6432Node Microsoft 0ffice gt Excel Addins thinkcell addin The license key and the settings for online quality assur ance and automatic updates are saved in the following section of the Windows registry Software Classes Software think cell If group policies based on think cell adm x see Group Policies on the next page are used in your network think cell may also use HKEY_LOCAL_MACHINE Software Policies gt think cell g HKEY_CURRENT_USER Software Policies think cell think cell changes no other sections of the Windows reg istry Group Policies think cell supports Windows group policies to centrally control think cell s behavior for a group of users or on a group of machines To use group policies you need to create a group policy object and link it to a site domain or organizational unit using the Group Policy Manage ment Console The following explanation requires an understanding and working knowledge of group policy concepts and administration For general information on Windows group policy concepts and details of their usage and upd
87. e wise to control the number format with the Excel link set it to Excel Format see Number format on page 35 Make sure to set the background color Programming think cell 141 and the number format of the respective cells in Excel before calling PresentationFromTemplate Example To use this sample in Excel s Visual Basic for Appli cations window go to Tools then References and add the Microsoft PowerPoint Object Library When Option Explicit appears in a file you must explicitly declare all variables using the Dim or ReDim statements If you attempt to use an undeclared variable name an error occurs at compile time Use Option Explicit to avoid incorrectly typing the name of an existing variable or to avoid confusion in code where the scope of the variable is not clear If you do not use the Option Explicit statement all undeclared variables are of Object type http msdn microsoft com en us library y9341s4f 428v7vs5 80429 aspz Option Explicit Sub PresentationFromTemplate_Sample Get the range to modify It ts more efficient to do this once rather than within the loop Dim rng As Excel Range Set rng _ ActiveWorkbook Sheets Sheet1 Cells 3 2 Get the think cell add in object Dim tcaddin As Object Set tcaddin _ Application COMAddIns thinkcell addin Object Get a PowerPoint instance Hold on to this object as long as you want to access the generated presentations
88. e think cell the smarter way to presentations think cell 7 User Manual Imprint think cell Sales GmbH amp Co KG ChausseestraDe 8 E 10115 Berlin Germany Tel 49 30 666473 10 Fax 49 30 666473 19 November 22 2015 This work is subject to copyright All rights are reserved whether the whole or part of the material is concerned specifically the rights of translation reprinting reuse of illustrations recitation broadcasting reproduction on microfilm or in other ways and storage on data banks Duplication of this publication or parts thereof is permitted only under the provisions of German Copyright Law of September 9 1965 in its current version and permission for use must always be obtained from think cell Software GmbH Violations are liable for prosecution act under German Copyright Law 02002 2015 think cell Softvare GmbH This product is protected by U S patents no 7 478 328 7 716 578 7 757 179 and 8 458 587 and pending U S 845 Third Avenue 6th Floor suppornt think cell com New York NY 10022 httos www think cell com United States of America Tel 1 800 891 8091 Fax 1 212 504 3039 patent applications serial no 12 698 365 and 13 360 015 think cell is a registered trademark The use of general descriptive names registered names trademarks etc in this publication does not imply even in the absence of a specific statement that such names are exempt from the relevant protective laws and
89. e Excel functions the think cell rounding functions take two parameters Excel data rounding 103 x The value that is to be rounded This can be a con stant a formula or a reference to another cell n The rounding precision The meaning of this param eter depends on the function you use The parame ters for the think cell functions are the same as for the equivalent Excel functions Refer to the table below for examples As in Excel think cell round can not only round to in teger values but to any multiple For example if you want to represent your data in 5 10 15 steps simply round to multiples of five In Excel you must use different functions depending on the desired rounding precision Examples are the ROUND and the MROUND functions which interpret the parameter n differently Using the dropdown box in the think cell round toolbar simply type in or select the de sired rounding precision think cell round chooses the appropriate function and parameters for you The following table provides some examples of round ing using the toolbar ROUND or MROUND together with their specific n parameter Toolbar 100 50 2 0 01 ROUND 2 0 2 MROUND 100 50 2 1 1 018 0 0 2 1 1 02 17 O 0 18 17 17 00 54 6 100 50 55 54 54 60 1234 1234 1200 1250 1234 1234 1234 12 8776 54321 8800 8800 8776 8777 8776 54 IF the values are not displayed the way you expect them to verify that the Excel Cell Formatting is set to General
90. e arrow Segment difference arrows can be added by selecting the 2 or 3 button in the context menu You can use the handles that appear when the difference arrow is selected to set the two val ues that are to be compared The ends of the difference arrow can be attached to column segments data points or to a value line if there is one Value line on page 51 column and waterfall charts 2 line and area charts Chart decorations 50 By default a newly inserted difference arrow stretches from the selected segment or category to the top seg ment of the next category You can also determine the desired start and end segment category for the differ ence arrow immediately by selecting the start segment and the end segment at the same time Then right click on one of them and select Ub Add Segment Difference Arrow To select multiple segments at a time hold down key while selecting see Multi selection on page 18 In case of a line or area chart select the corresponding data points instead of segments If the arrow is so small that the bubble would cover it up the bubble is automatically placed next to the arrow To manually optimize the layout you can drag the arrow itself as well as its label to other locations Automatic label placement on page 33 If you want to place the arrow between two columns you might want to create an additional gap between the columns Gap width and category gap on the previous page Category di
91. e disabled immedi ately With think cell disabled charts are presented as normal PowerPoint shapes To re enable think cell click the iig Activate think cell button in the think cell toolbar or ribbon group in PowerPoint There is no need to close the PowerPoint application in order to switch between think cell and plain PowerPoint Before you alter think cell elements without think cell be aware of potential compatibility issues chapter Ex changing files with PowerPoint on page 119 Note You do not need to disable think cell in or der to make your presentations accessible to coworkers or clients who may not have think cell installed Sim ply send them the same file you are working with if think cell is not installed they will find a presentation with normal PowerPoint shapes 3 Basic concepts This chapter presents the basic concepts that apply to working with all think cell elements Toolbar and Elements menu After installing think cell you will find the following group in the Insert tab of the ribbon in PowerPoint RE 3 Connector More Elements X bp e Pentagon Rounded Chevron Rectangle Harvey Ball Checkbox Chapter Table of Spit Agenda Contents Stacked 100 Clustered Build up Build down Mekko Mekko Waterfall Waterfall 9o Axis Unit Axis e m c uu Area Area 100 Line Combination e ke da O Pie Scatter Bubble Gantt Timeline In the following we will refer to the rib
92. e mouse button to pan the slide Just grab the slide with your mouse pointer by clicking the middle mouse button and move it where you need it If your mouse has a wheel instead of a middle button you can achieve the same effect by pressing down the wheel without turning it Note You probably know that in PowerPoint you can zoom in and out using the mouse wheel with the key held down Together with the panning feature from Basic concepts 20 think cell using zoomed views for slide design becomes easy and fast Formatting and style When you select an element or feature by clicking on ita floating toolbar might appear It contains property con trols to change the look of the feature Only the controls which are applicable to the selected feature are shown in the floating toolbar In this chapter several general types of controls are de scribed Through the course of the following chapters detailed information is provided for all property controls of the floating toolbar in the context of specific element and feature types Color and fill The color control applies to features pases No Fill that have a fill color and to lines in i line ch It d e ine charts It does not apply to text docui Text 2 because the text color and the text ie background color are always setau E Accent3 Bl Accent 4 tomatically B Accent 5 B Accent 6 1 E link The list contains Like Excel Cell if EE MN you have enabled U
93. ed O Text 1 X No Fill Background 1 Be Background 2 B ret Accent 1 Accent 2 B Accent 3 Bl Accent 4 M Accent 5 Bi Accent 6 Bl Hyperlink Bl Followed Hyperlink tc Red tc Gray Bl tc Green Smoke 10 Smoke 20 Smoke 40 BE Smoke 60 M Smoke 280 Bl Smoke 90 White Light Gray Mi Med Gray B Dark Gray B Black Light downward diagonal Light upward diagonal Wide downward diagonal Wide upward diagonal Dark horizontal MIN AS ZZ The list of available color schemes see Color scheme on page 20 v No Line All Fill Color All White PowerPoint Scheme PowerPoint Scheme rev Smoke Blue Scheme Smoke Blue Scheme rev Patterns Use Excel Fill on Top The colors of Harvey ball and checkbox see Checkbox and Harvey ball on page 79 The list of available lines styles for the line chart and all connectors The list of available markers for line charts and scatter charts The first sections describe creating and loading a style file and explain how to deploy it in an organization An understanding of these tasks is required in any case Af terwards you may either follow the Style file tutorial on page 123 to create your own style file or go through the format reference in Style file format on page 126 g Creating a think cell style Simple modifications to an existing style file can be made using any text editor A new think cell style file should be created using a dedicated XML editor I
94. ee columns are language de pendent see Language dependency on page 76 with Activity Responsible and Remark used as the de fault English headlines You are free to overwrite or re move them if necessary The labels to the left are intended for names of activi ties These labels are shown by default and each label belongs to exactly one row If you already have the text for the labels available in some other place where you can copy them to the clipboard you can quickly paste an entire label column see Pasting text into multiple la bels on page 36 g Note Unfortunately selecting multiple shapes in PowerPoint or labels in another Gantt chart does not work in this regard Lines of text in a word processor text editor or email or multiple cells in an Excel worksheet can be copied to the clipboard and pasted into activity labels as described above You can organize activity labels in a hierarchy using PowerPoint s Decrease Increase List Level buttons in the Paragraph ribbon group on the Home tab or hold down Shift AM and use the arrow keys f9 and G The vertical space between indented labels is reduced to show that they are grouped You can add up to two more columns if required The labels for the headlines are automatically added when a column is created The labels in the additional columns can refer to multiple rows see Labels spanning multiple rows on this page Initially a newly created label column is em
95. elete button The think cell frame is removed while the data itself remains untouched Any linked charts g will no longer be able to connect to this data range as their data source and will instead use their internal datasheets Note You cannot undo the removal of a linked frame but you can create a new link with an existing chart when you need it see below Whenever you remove one participant of a link either the data range in Excel or the chart in PowerPoint the other side does not get deleted with it Charts in Power Point fall back to using their internal datasheets and linked data ranges in Excel simply remain in place un til they are explicitly removed This is important because there may be other charts in other presentations linking to the same data source If you want to link an existing chart to an Excel data source first go to the Excel workbook and select the desired data range You can also select an existing linked range indicated by the colored think cell selec tion frame Then switch to PowerPoint and select the de sired chart If the chart is already linked to some other data source disconnect it as described above Now the Excel link button in the chart s context menu has changed to ib Establish Excel Link Click this button to establish a link from the selected chart in PowerPoint to the selected data range in Excel Note It you want to remove all data links from a pre sentation use the data lin
96. enus and dialogs of the installation of Microsoft Of fice Installed files The following files are required for think cell and are created in the installation directory tcaddin dll approx 20 MB manual de en les fr it pt pdf each approx 2 MB custom xml 200 KB sla rtf approx 100 KB splash bmp approx 100 KB Deployment guide 111 d3dx9 43 dll approx 2 MB dbghelp dll approx 2 MB tediag exe 1 MB tcdotnet dll approx 8 KB tcmail exe 600 KB tcrunxl exe 500 KB admin policy templates think cell adm approx 10 KB admin policy templates think cell admx approx 10 KB admin policy templates en US think cell adm ap prox 10 KB styles example style complex xml lt 10 KB styles example style default xml 10 KB sty sty xm es example style simple xml lt 10 KB es no slyle xml 10 KB schemas dml chart xsd 100 KB schemas dml chartDrawing xsd 10 KB schemas dml diagram xsd 100 KB schemas dml lockedCanvas xsd 10 KB l l X 2 0 o O Z X xm schemas dml main xsd lt 200 KB schemas dml picture xsd 10 KB x 3 xm xml schemas shared commonSimpleTypes xsd lt 10 KB xml schemas shared relationshipReference xsd lt 10 KB xml schemas tcstyle xsd lt 20 KB g On 64 bit versions of Windows Vista 7 8 8 1 and 10 the following additional files are required for think
97. ersa The appearance of the pentagon chevron is controlled by the fill color outline color and outline style con trols in the floating toolbar See Formatting and style on page 19 for details on these controls When moving or resizing a pentagon chevron snap ping helps you to align a new element with existing ob jects on the slide Additionally you can select multiple pentagons and chevrons e g having the same height and showing a process flow and change the height of all elements at the same time Rounded Rectangle Icon in Elements menu If a rounded rectangle is selected e g immediately af ter insertion you can start typing and the text will be displayed inside the element with automatic line breaks The appearance of the rounded rectangle is controlled by the fill color outline color and outline style con trols in the floating toolbar See Formatting and style on page 19 for details on these controls Checkbox and Harvey ball a In both responsibility and remark columns of a Gantt chart you can choose to display a checkbox or a Harvey ball instead of a text label using a row label s context menu see Row labels on page 70 You can also use these elements outside of a Gantt chart however In that case use the Elements menu in the think cell toolbar Icon in Elements menu Select the feature to configure its appearance using the floating toolbar Use the font size control see Font on page 35 to adju
98. es The labels of the pie chart support the label content property which lets you choose if you want to display absolute values percentages or both Label content on page 36 Additionally you can move each outside label to place it anywhere on the outer edge of the respective slice Series Series Universal connectors can be used to connect pie charts with other chart types see Universal connectors on page 52 12 Scatter chart and bubble chart Scatter charts and bubble charts are similar in many as pects both using an xy plot to visualize datasheet con tents The charts differ however in the style of markers used for the individual data points The datasheet for a scatter chart is organized as follows with each row representing a single data point A Dimension 2 Label 3 Label Label Label Label 7 Label B C Labd X Axis Y Axis Sie The datasheet for a bubble chart contains values in the Size column but is otherwise organized identically A 1 Dimension 2 Label 15 1 1 3 Label 23 2 2 4 Label 1 3 1 E C Lab X Axis Y Axis The Group column in the datasheet can be used to or ganize individual data points into groups In the above scatter chart datasheet the first three data points be long to group A while the remaining data points belong to group B Multiple data points belonging to the same group can be easily selected by clicking on a data point and then moving
99. es you have to select it first You can also select multiple features at a time to change their properties together Selecting features is very similar to selecting files in the Windows Explorer Select a single feature by clicking on it with the lett mouse button Or select multiple features by holding down the key while clicking You can also select a contiguous range of features by holding down the key moving the mouse g pointer and then clicking with the mouse Watch how the affected features highlight while you move the mouse with the key held down The following screenshot shows how all column seg ments of the second data series highlight in orange while they are collectively selected in a Shit click operation 2013 2014 2015 2016 When you select features a floating toolbar containing the corresponding property controls will appear For the selection of column segments as illustrated above for example the Fill Color control becomes available in the toolbar 21ptbold v m Accent 2 O Text 1 v pt In our example we want to change the shading of the second data series as required by the scribble on page 24 Therefore after selecting the column segments of the series we choose Accent 2 shading Introduction to charting 28 No Fill Background 1 B Background 2 B Tet2 Accent 1 IS Accent 3 Bl Accent 4 M Accent 5 Bl Accent 6 Bl Hyperlink Bl Followed tc
100. ext 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 1 In your source file select the text for all the labels or shapes and copy them to the clipboard C 3 or Edit Copy A B E D E F 1 fone two three four five 2 Switch to PowerPoint If the objects that are going to receive the text are not yet there create them now These objects can be native PowerPoint shapes as well as think cell labels 3 Multi select the shapes or labels that you want to fill with text For more tips on multi selection refer to Multi selection on page 18 4 Paste the text from the clipboard Ci or Edit gt Paste one two three four five Text labels 38 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 correspond ing text from the clipboard 7 Column chart line chart and area chart Column chart and stacked column chart Icon in Elements menu De 38 Series Series Series 2013 2014 2015 In think cell we do not di
101. f you need an unusual con nector that is not supported by the chart itself g You can also use the universal connector to connect two different charts The handles at the ends of the connector snap to connectable points while you move them The handle in the middle of the connector can be dragged to change the straight connector to one with a right angle 100 br Note The universal connector visually connects two objects but it has no effect on the calculation of the waterfall chart If you want a connector as part of a waterfall calculation you must use the specific water fall connector see Waterfall chart on the next page Standard connectors see Series connectors on the pre ceding page are also available for a number of chart types and should be used in preference to universal con nectors when possible Legend In menu Chart Menu item ms A legend can be used to clearly identify the various data series or groups in a chart A floating toolbar containing a line style and a font con trol Text label property controls on page 35 appears when the legend is selected letting you specify a line style for the legend box and the size of the legend text In addition chart specific property controls for the series and groups are available Chart decorations 54 14pt v No Line Series A X J Series A E Series B Series Ce o_O Series E Series C E _ v E PowerPoint Scheme Y
102. fference arrow Category difference arrows can be added by selecting the jg or L button in the context menu and connecting the ends of the difference arrow to the categories or columns that are to be com pared 22 2013 2014 2015 Arrow modes You can cycle through three arrow modes The button in the context menu changes accordingly and the number in the label is recalculated Show an arrow pointing in one direction and calculate the relative difference Show a double ended arrow and calculate the absolute difference Show an arrow pointing in the other direction and calculate the relative difference Chart decorations 51 CAGR arrow In menus Chart segment Menu item s This feature visualizes the compound annual growth rate The range of dates on which the calculation is based is taken from the datasheet cells that are associated with category labels The CAGR is automatically calculated and updated whenever the underlying data changes For the calculation to work correctly it is important that the respective datasheet cells contain the correct dates The CAGR from category A to B is calculated as 4 es with n being the number of years in the date range The 30 360 day count convention is followed to determine n when it is not a whole number The automatic display of the CAGR is based on a text label chapter Text labels on page 32 and supports font and number format properties Font on page 35 N
103. fillmarker which references a line a color and a marker The attribute name contains the name that is used in the line scheme control Example lt lnfillmarkerScheme name Company line scheme gt 1nfillmarker lt lnRef name Solid 18 lt linefillRef name accent1 gt lt markerRef name No Marker gt lt 1nfillmarker gt 1nfillmarkerScheme g Infillmarker A combined line style for line chars see Line chat on page 39 described by the child elements inRef linefillRef and optionally markerRef referencing a line a fill color and a marker respectively Example lt lnfillmarker gt lt lnRef name Solid 18 gt lt linefillRef name accent1 gt lt markerRef name No Marker gt lt lnfillmarker gt InRef A reference to a line defined in the 1nLst ele ment The attribute name must match the value of the same attribute in the line definition 1nRef as a child element of 1nfillmarker has the following restric tions lt may not reference the noLine line type and as MS Graph supports only the following four line weights in a line chart please reference lines with a width listed below Other values will be rounded to their nearest supported neighbor Supported line weights in line charts line weight in EMU pt 3175 0 25 9525 0 75 19050 1 5 28575 2 29 Example lt lnRef name Solid 18 gt Style tile format 132 linefillRef A reference to a fill color defined in the fillLst
104. gain this is the same way multi selecting files works in Microsoft Windows Explorer Using the keyboard to select a complete range is also possible Select a feature with a single left mouse button click and press Cr A All features that could have been included in a range together with the selected feature are selected as well Logical multi selection is particularly useful if you want to colorize an entire data series in a chart element or if you want to change the formatting of a range of labels You can even use multi selection to paste text into multiple q labels at once see Pasting text into multiple labels on page 36 Keyboard navigation In many cases you do not need the mouse to select other objects on a slide Instead you can hold down the 4l key and use the cursor arrow keys to select another object When a PowerPoint shape or think cell element is se lected Ali with cursor keys selects the next shape that is found in the arrow s direction When an element s feature is selected A with cursor keys selects the next feature of the same kind in the element However you can only shift the focus to features of the same element Use the mouse again to select a feature of another element Panning When editing a slide in a zoomed view like 400 it is often hard to move the slide around and locate the region that you want to work with next With think cell installed you can use the middl
105. h Label content on page 36 Mekko chart with 96 axis Icon in Elements menu EH 23 45 30 100 80 60 40 20 0 Apples Oranges Pears A Mekko chart with 96 axis sometimes also called marimekko chart or 10096 cost curve is a two dimensional 100 chart As in the 100 chart the value axis is based on percentages and column heights are shown relative to 100 In the regular 100 chart since the columns are scaled to relative heights there is no visual representation of absolute column totals The Mekko chart with 96 axis extends the 100 chart and uses variable column widths to represent column totals Thus the segment area is proportional to the ab solute value of the segments As in the 10096 chart by Js default the datasheet takes percentages and the 10096 equivalent values are entered explicitly in the row la beled Width As an example the above Mekko chart is rendered from the following datasheet Series 23 45 30 Series 19 096 13 096 20 096 Series i 5 0 8 096 Series 82 0 72 096 Aj ima Aa wil Alternatively you can also enter absolute values into the datasheet In this case for all columns that add up to 100 you can leave the Width row empty For details about entering relative or absolute values refer to Abso lute and relative values on page 29 Mekko chart with units Icon in Elements menu EH 200 150 100 50 Apples Oranges Pears Mekko chat
106. hapter to the current chapter Tips and Tricks You can use all four arrow keys for chapter shortcuts Shift A and for reordering chapters and Shift NHAN and for changing the hierarchy level In slide view double clicking a chapter heading takes you to the associated agenda slide A single click ac complishes the same during a slide show Selecting a chapter heading and changing the font size and style using the floating toolbar applies the same change to all other chapters of the same type How ever selecting part of the chapter heading text and using PowerPoint s controls e g for italicizing a proper name will change this chapter s text on all agenda slides but will not affect other chapters Role Model When the second and any subsequent agenda slide is inserted in a presentation it is created as a copy of the closest existing agenda slide including shapes on the g Agenda 86 slide and the master setting Thus if the user has ap plied a specific slide master or custom layout Power Point 2007 and later to an agenda slide this setting is inherited by all agenda slides that are created later 17 Presentation tools This chapter explains various small tools of think cell that can make life a lot easier Special characters Experienced PowerPoint users find the built in Insert gt Symbol tool inconvenient for frequent use With think cell installed there is a simpler way to insert special charac te
107. here is some part of the value axis big enough to display at least the two lines that visualize the break This is illustrated by the following example No break can be added to the very top part of the second col umn because the top of the third column is too close However within the range of the third column s seg ment there is enough space for the break Since both columns share this range of the value axis both seg ments are broken 400 E Chart decorations 46 2013 2014 2015 Note It you apply the same scale operation see Same scale on the following page to charts that have value axis breaks the breaks are automatically removed As long as breaks are present it is impossible to make the selected charts visually comparable Adjusting the break s extent You can adjust the size of a broken segment by dragging the lines that appear when you select the break These lines mark the range of the scale that is compressed to save space Drag the lines to determine the size of the compressed part of the scale If you drag a line far enough for the compressed range of the scale to take as much space as was orig inally required the break disappears The default is to compress the selected part of the scale as much as pos sible while leaving enough room for the break lines to be rendered Available break styles There are two types of break shapes supported by think cell The straight break as il lustrated above is com
108. hich is 18 greatly differs from the original value 14 62 Troubleshooting TCROUND formulas There are two possible error results you may come across when using think cell round VALUE and NUM VALUE The VALUE error hints to syntactical problems such as mistyped formulas or bad parameters For example the second parameter for TCROUND must be an integer value Also pay attention to use correct delimiters For example while in international Excel the tormula looks like this TCROUND 1 7 0 in a localized German ver sion of Excel it must be written as TCROUND 1 7 0 Another mistake specific to think cell round is the place ment of the TCROUND function call You cannot use a TCROUND function within another formula Please make sure that TCROUND is the outermost function of the cell s formula see Placement of TCROUND functions on page 103 Excel data rounding 106 ZNUM The amp NUM error results from numerical problems When the output of a TCROUND function is NUM this means that the problem as stated by the given set of formulas is mathematically unsolvable see Limitations of think cell round on page 103 As long as the formulas enclosed by TCROUND functions contain merely and SUM and all TCROUND state ments share the same precision second parameter a solution is guaranteed to exist and will be found by think cell round However in the following cases there is no guarantee that a consistently
109. hink cell The installation can be started directly from the online source When you download the setup file you may choose the following Open in order to install the software directly from the internet Save to Disk and start the installation by double clicking the downloaded setup file The installation wizard asks for the installation path then copies the required files and updates the registry If the installation wizard detects that you do not have sufficient privileges for a regular installation a single user instal lation will be performed This means that think cell can only be used with your current Windows login name think cell uses the same language as in the menus and dialogs of your installation of Microsoft Office pro vided that it is supported by think cell see Language on page 110 for more details If it is not yet supported English is used Entering the license key The public version of think cell requires a valid license key which expires after a fixed period of time When you start PowerPoint with a think cell trial version for the first time or when your license key has expired you need to enter a valid license key think cell Please enter a valid license key to activate your think cell product Ok ARALAR AAA Cancel not valid _ Automatically report any think cell error and check if there is already an update For it Please visit http www think cell com or contact sa
110. il The data links will be reestablished as soon as the Excel and PowerPoint files are open at the same time on the computer of the receiver To store the in formation about the reestablished data links the files should be saved You can make copies of linked Excel files and use the copies as alternative data sources for the data links g The original and copied Excel files can be indepen dently edited The link between a PowerPoint presen tation and the desired Excel file will be established when opening one of either the original or the copied Excel files together with the PowerPoint file Note When copies of the same linked range in Excel are present in open workbooks e g after copying a worksheet both copies are equally valid source ranges siblings and it is undefined with which range the link will be established when opening the PowerPoint file A warning is displayed next to affected linked ranges in Excel in this case and you can use the litte blue buttons displayed below the think cell frame in Excel to switch between all siblings You should then make all but one copy of the linked range unavailable e g by closing the respective workbook Alternatively you can make all the linked ranges unique by deleting all but one of the think cell frames in Excel and linking each range to the desired chart respectively This way each new frame is assigned a unique identifier Editing linked files If you edit the Power
111. in the XML snippets must be double quoted when specitying the properties on the setup command line Alternatively adding the following options to the setup command line will place the think cell group in the built in Home tab after the Font group and label the group RIBBONPPTABINSERT idMso TabHome RIBBONPPGROUPINSERT insertAfterMso GroupFont label think cell The idQ attribute can be used to specify qualified iden tifiers for both the think cell group and tab Any names paces required for the qualified identifiers can be spec ified using the RIBBONPPXMLNS property For example adding the following two options to the setup command line will place the think cell group in a user defined tab TabUser qualified using the names pace http example com ribbon and positioned be fore the Insert tab g RIBBONPPXMLNS xmlns ribbon http example com ribbon RIBBONPPTABINSERT idQ ribbon TabUser label My User Tab insertBeforeMso TabInsert Qualitied identitiers can be usetul when several add ins or templates wish to customize the PowerPoint rib bon If several add ins for example specify a tab using the same qualified identifier then a single user defined tab will be created and each of the add ins can posi tion groups within this common user defined tab Spec itying a qualified identifier for the think cell group lets other add ins or templates position groups relative to the group Simi
112. ing elements Inserting an element into your presentation is very sim ilar to inserting a PowerPoint shape To create a new element on a slide go to the think cell toolbar and click the Elements button Then select the required element You may notice small arrow markers around some of the elements Moving the mouse over these markers lets you select rotated and flipped versions of these elements If you unintendedly have selected some element you can always do the following Press the Esq key to cancel the insert operation Re click the Elements button to select a different ele ment g BH Op HOME INSERT DESIGN m Online Pictures TRANSITIONS Presentation pptx PowerPoint ANIMATIONS SLIDE SHOW REVIEW VIEW SLIDE O SE ld LO Shapes FQ lxi Connector a X Q 4 V 8 9 A Le 9 a Screenshot SmartArt More A Elements Appsfor Links Comment Text Symbols Media Photo Album ali Chart Office 7 7 7 n Tables Images Illustrations think cell Apps Commen ts Table Pictures Phase 1 Phase 2 Company A 900F90 X ENGLISH UNITED STATES zc NOTES MA COMMENTS n nce you have chosen an element a rectangle will ap pear with the mouse pointer indicating where the ele ment will be inserted on the slide You have two options when placing the element on the slide W Click the lett mouse button once to place the element with the detault
113. ing plus in the number format see Number format on page 35 to show a sign for both positive and negative numbers or you can select a negative number and en ter a leading or trailing minus to only show a sign for negative numbers Note lf all segments are connected properly and the chart is still not grounded on the baseline the way you want it to select the segment that should be grounded and force it to the baseline with the WH or E buttons Percent of datasheet 100 as label content Labels for segment difference arrows see Segment dif ference arrow on page 49 in waterfall charts addition ally support the display of values as percentages of the 100 value in the datasheet 96 of datasheet 100 Selecting 96 as the label content for a segment difference arrow label in a waterfall chart displays the difference between the start and end of the arrow taking the start ing point of the arrow to be 10096 In contrast select ing the 96 of datasheet 100 label content displays the same difference but takes the 10096 value of the col umn pointed from by the start of the arrow to be 10096 The above charts illustrate the two settings for the label content In the left diagram the difference of 2 is com pared to the starting value of 2 resulting in the display of 10096 When the 100 value in the datasheet is left empty it is taken to be the sum of the column Therefore in the right diagram the difference of 2 is c
114. installed can open and edit the files without noticing any difference The think cell elements appear as reg ular PowerPoint shapes such as textboxes and Microsoft Graph objects Reimporting think cell elements from PowerPoint Consider the following scenario 1 A presentation has been created using PowerPoint with think cell installed and contains think cell ele ments 2 The same presentation has been edited in Power Point without think cell and some of the shapes that are part of a think cell element have been altered 3 Now you want to use think cell again to further mod ity the elements In this scenario when you attempt to select a think cell element that has been altered without think cell the soft ware will recognize the element as inconsistent and dis play the following message box 38 Q This element was changed without think cell Manually carry over Continue editing without JE changes to think cell think cell functionality In order to proceed you will need to decide whether to continue using the PowerPoint edited version with out think cell functionality or to reimport the element to think cell js You should carefully consider the following conse quences before making your decision Manually carry over changes to think cell reimports the element to think cell and restores the intelligent think cell element functionality but discards all changes made without think cell If you wish to
115. iple selected Multi selection on page 18 items with the mouse It exactly one item is selected you can also drag its handle s to adjust the date or anchor it to another item see Anchoring items on the next page You may double click an item to open the calendar di alog for easy date selection The current date of the se lected item is pre selected For bars process arrows brackets and shades select a date range as described above Modifying the date range on page 66 For mile stones simply click on the desired date the calendar dialog will close immediately and the selected date will be applied Milestone positioning Bars and process arrows are positioned to begin at 0 00h on the start date and to finish at 24 00h on the end date The default position of milestones however depends on the currently viewed date range and the vis ible scales f the day scale or the vertical day separator lines are visible then milestones are positioned at 12 00h on the appropriate day Ifthe day scale and the vertical day separator lines are not visible then milestones are positioned at 0 00h on the appropriate day The default positioning of milestones is usually correct but can be overridden if required by the use of anchors Anchoring items on the next page Anchoring a mile stone to the end of a bar for example will ensure that g the milestone is always aligned with the end of the bar regardless of the current
116. is slide do not appear on agenda slides at the beginning of the presentation and the backup slides are not moved along when moving the last chapter of the main part of the presentation Note It you place the agenda divider on the first agenda slide in the backup the divider would be moved along if you move this chapter later and would also be duplicated if you duplicate the agenda slide Agenda 84 Inserting a table of contents To add a slide showing all top level chapters without any highlighting choose Table of Contents from the Elements menu If you have not yet defined any chapters the slide will be empty and will be populated when you add chapters An example is shown below Agenda First topic Second topic Third topic It the presentation already contains chapter slides the contents slide will be inserted before the first chapter slide If there are no chapter slides yet an empty con tents slide will be inserted after the current slide Simply use PowerPoint s slide sorter view to move it to the de sired position Styling the agenda When a chapter heading is selected the floating toolbar offers controls for changing the font size and style see Font on page 35 the fill see Color and fill on page 19 and the style of the outline see Line style on page 21 When an outline is used you can also change its color The styling of a chapter heading is used for all chapters of the same type For example
117. ject dd MMM yyyy 01 Jan 2014 R M d yy 1 1 14 timeline By convention all tem la MM dd yyyy 01 01 20 d MMM yyyy 1 Jan 2014 bels of a chart share the same date TT formatting so when you change the ddd wwww Wed Week 01 formatting for one label all others will change accord ingly When you select a label that contains a date field or select a date field within a label the date format control appears in the floating toolbar It works similar to the number format control see Number format on page 35 The dropdown menu facilitates one click selection of the most commonly used date formats Its contents depend on the feature that is selected e g each scale offers a different set of predefined date formats The edit box reflects the current setting and allows enter ing of arbitrary date formatting The format codes used by Excel and Graph are supported and some more codes were added for the particular purposes of the project timeline see table below Also up to four of your most recently used custom formattings are avail able in the dropdown box Date format codes are case insensitive You can insert a line break with the backslash character You can mix the format codes with arbitrary text and delimiters If your custom text contains charac ters that can be interpreted as format codes i e dDw WmMqQ y Y Y you must enclose the text within single quotes It will then be displayed
118. ks dialog Data Links dialog on page 93 In the data links dialog you can simply select all charts and press to remove all links in a single action Excel data links 97 How to compile the data When creating charts directly from Excel you probably already have your data in Excel In some cases however you may not wish to create a chart using all the data you have in your Excel sheet Alternatively the data may be in a fixed format that can not be easily altered Here are a few suggestions that may help you in such situations Add a new sheet to the Excel file and compile the data for your charts on this interface sheet If you create this sheet using Excel references then the data in the sheet and the linked charts in PowerPoint will be up dated whenever the original referred to data changes Using a dedicated sheet as the source for your charts also facilitates preparing the data specifically for the intended purpose For example you can use think cell round to consistently round the data before pre senting them in a char see Excel data rounding on page 101 You can simply hide entire rows or columns of data from being reflected in the chart by using Excel s Hide command Keep in mind that the hidden data will ap pear in the chart as soon as you use Excel s Unhide command and update the chart Similarly you can use Excel s Group and Outline tunc tion to hide data that you do not want to be shown in the char
119. l for a group of individual users For instance if you deploy think cell on a terminal server you need to make sure that only the licensed users have access to think cell When used in the following way group poli cies offer a convenient method to do so 1 Set up one group policy object which disables think cell completely and link it to your domain Use the Product Access Control setting of the administrative template think cell with the appropriate value 2 Add another group policy object which activates the software for the licensed users This should also be linked to your domain and be applied after the dis abling one Because group policy objects are applied in reverse order the enabling object should be further up in the list in Group Policy Management Console g 3 In the section Security Filtering of the Group Policy Management Console restrict access to the enabling group policy object explicitly to the licensed users of think cell Another convenient use for group policies is the cen tralized management and distribution of the think cell license key to the think cell users in your organization The license key is one of the settings of the administrative template think cell Ribbon in Office 2007 and later The think cell toolbar in Office 2007 and later is implemented as a ribbon group The default posi tion for the think cell group in PowerPoint is in the Insert tab TabInsert after the Insert Illustrations grou
120. l 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 g 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 over written with some other number To inform you that the label is no longer automatically updated an exclama tion 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 Apples Pears Chocolate 2013 2014 2015 To reset a label and re insert text fields use the label content control Label content on the next page or sim ply 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 for mula i e instead of Very long text
121. larly the think cell group can use qual ified identifiers to position itself relative to the groups of other add ins or templates For example the follow ing options specify a qualified identifier tor the think cell group and positions it relative to a user defined group RIBBONPPXMLNS xmlns ribbon http example com ribbon xmlns special http example com special RIBBONPPGROUPINSERT idQ ribbon GroupThinkCel1 insertAfterQ special GroupSpecial It is important to note that the order in which add ins or templates are loaded may influence the customization of the PowerPoint ribbon If in the example above the add in that creates the special GroupSpecial group is loaded after the think cell add in then positioning rel ative to the special GroupSpecial will have no effect The order of loading cannot always be controlled and it is recommended that pairs of user defined groups Deployment guide 115 requiring relative positioning should both position themselves relative to the other This should ensure that whichever group is loaded last will position itselt correctly relative to the other In the above example the XML code for the special GroupSpecial group should contain an insertBeforeQ attribute that references the think cell group s qualified identifier The think cell group in Excel can be similarly customized using the RIBBONXLTABINSERT RIBBONXLGROUPINSERT and RIBBONXLXMLNS properties Updates think
122. les think cell com For any questions on licensing pricing and ordering Please contact us to receive such a license key for the first time or as a prolongation of your existing deploy ment In any case you can always click the Cancel but ton and continue using PowerPoint without think cell To enter the license key later click the BB Activate think cell button in the think cell toolbar or ribbon group Automatic update think cell regularly checks online to see if a new release is available and if so attempts to download the updated installation file The automatic download is subject to the following conditions The check for a new release is performed once when PowerPoint is started with think cell installed and en abled The automatic download runs quietly in the back ground and only occupies unused bandwidth If the internet connection is interrupted or there is other net work traffic the download is paused until the network is again available While PowerPoint is in on screen presentation mode any automatic update activities are suppressed Installation and update 13 A dialog box appears after the download is completed indicating that a new release of think cell is available tor installation You have the option to either immediately Install the update or click Postpone to postpone the in stallation until the next start of PowerPoint A think cell update is available Postpone Descri
123. lly created report contains the following information date and time your customization id a three or four digit number 530 for the public version that is the same for all users within a corporate unit can also be found in the About dialog the program build a five digit number can also be found in the About dialog an error code from the operating system or from PowerPoint or Excel the location in our source code file name and line number where the error occurred a Microsoft Minidump which is basically a stack trace along with environment information such as operat ing system version and loaded modules Microsoft uses the same Minidump when they send error re ports if desired the machine name or its serial number al lowing your IT personnel to identify the concerning machine or user We may get valuable additional in formation if we can talk to the user who experienced the problem Deployment guide 117 or alternatively an anonymous Globally Unique Identifier GUID which is used to correlate multiple error reports The GUID is created when using think cell for the first time and stored together with the user s settings lt is a random string with no connection to the machine user or document current at the time of creation Using the GUID it is only possible to determine whether two error reports came from the same or from different users The error report is sent via HTT
124. lly labeled by means of an additional bracket below the shade Use the think cell context menu to add a label to one or more selected items If exactly one item is selected you can press F2 to add a label to this item or edit an existing label By default an item label contains the item s date or date span This information is maintained in a text field see Text fields on page 34 and is updated whenever the item is moved You can add text to the label or replace the default content with custom text If you deleted the text field you can always re insert it into the label Select the label and choose the desired field from the la bel content control in the context sensitive toolbar refer to Label content on page 36 In particular think cell allows for large multi line labels even in a relatively dense chart All activities are auto matically arranged to make the text fit Moreover most labels can be dragged to place themselves below or be sides their respective item Evaluation Approval of pilots Ongoing evaluation Monthly steering committee 10 13 13 Certification o inary irr b age complete a 11 5 13 9 10 8 13 9 10 13 12 3 13 Project timeline Gantt chart 76 Date format control You can freely set the desired for IvTbate matting for date values that appear amp Myy 1 1 14 l dd MM yyyy 01 01 2014 throughout the labels of a pro
125. lor scheme is applied i e the Excel fill color is applied on top of the color scheme Note Using Excel s cell formatting to set a segment s fill color does not work if you use conditional format ting rules in Excel and these rules contain functions or references to other cells g Segment sorting The segment sorting con trol applies a specific or der to the segments in a chart The default Seg ments in sheet order orders segments in the same order they appear in the datasheet If you choose Segments in reverse sheet order the last series in the datasheet will be displayed at the top of the chart and the first series in the datasheet at the bottom of the chart egments in descending order egments in ascending order think cell can also sort the segments in a category based on their value Segments in descending order will sort all categories so that the largest segment in each category is on the baseline and sort the other segments in de scending order Segments in ascending order will display the segment with the smallest numerical value on the baseline As a consequence of sorting segments of the same data series with the same color will appear at different positions in different categories Category sorting The category sorting CON Categories in sheet order trol applies a specific order to the categories ina chart ategories in ascending Y extent order The default Categories in sheet order orders categories in
126. lt glyph gt g t A character or symbol used in a glyph itself used in a checkbox The contents of this element can be a verbatim character a a Unicode symbol or a numeric character reference to a Unicode code point The numeric reference can be given using decimal numbers amp 10007 or hexadecimal num bers amp x2717 pic A picture that is used as one of the choices of a checkbox The file name of an EMF file with the pic ture is given as the attribute Target of the child ele ment Relationship The attribute hotkeys describes a list of hotkey characters that select the picture Example pic hotkeys dD5 gt Relationship Target down emf gt lt pic gt Style file format 137 E Programming think cell Some functions of think cell can be accessed pro grammatically The interface is integrated into the Office Automation model so it can be accessed from any language with which you can program Of fice such as Visual Basic for Applications or C The entry point into think cell is the think cell add in object It can be accessed via the Application COMAddIns collection Calls into think cell are always late bound See Microsoft s knowledge base for an explanation http support microsoft com kb 245115 Thus the type of the think cell add in object is simply Object and there is no type library or reference to add Just acquire the object and you are ready to make calls Dim tcaddin As Obje
127. lt fillSchemeRefDefaultPie name Pie scheme gt fillSchemeRefDefaultBubble The default color scheme for bubble charts Example lt fillSchemeRefDefaultBubble name Bubble scheme gt InfillmarkerSchemeRefDefault The default color scheme for line charts Example lt lnfillmarkerSchemeRefDefault name Line scheme gt InfillmarkerSchemeRefDefaultCombination The default color scheme for combination charts Example lt lnfillmarkerSchemeRefDefaultCombination name Combination scheme gt Customizing lines InfillDefault The default line type used throughout think cell Us ing a 1nRef element to reference one of the lines in the 1nLst element the dash type and weight is de fined One of the solid colors in the il1Lst element is reterenced using solidfillRef to set the color Example Style file format 134 lt 1nfillDefault gt lt lnRef name Solid 0 75 pt gt lt solidfillRef name txi gt lt 1nfillDefault gt It either the 1nRef or the solidfillRef element is missing from one of the line style definitions below the respective value from 1nfillDefault is used InfillGridline The grid line style Segment outlines The outlines of segments are defined on the fill scheme level i e every scheme from the color scheme control can also set a line style for segment outlines The following elements are therefore child elements of a i11Scheme element InfillSegment The default outline style f
128. lude one of your own colors by adding a fillRef element inside the i11Scheme element at the appropriate place If you wish to include the color defined above add the following line lt fillRef name Light Green gt Note that you can only use colors that have been de fined in the i11Lst section see steps 3 5 above In particular if you removed any colors in step 3 you must remove those colors from the color schemes too 8 Optionally create a new color scheme using the fillScheme element Your scheme needs a name e g Green Scheme and a list of color references as fillRef elements If you had defined the colors Dark Green and Medium Green in addition to Light Green above your color scheme might look like this lt fillScheme name Green Scheme lt fillRef name Dark Green gt lt fillRef name Medium Green gt lt fillRef name Light Green gt lt fillScheme gt Check the contents of the fil1SchemeRefDefault el ement The name attribute specifies the color scheme that is used by default when inserting new charts If Js you wish to set your own color scheme as the new default modify the code like this lt fillSchemeRefDefault name Green scheme gt 10 Save the modified style file load it see Loading style files on page 123 and test it 11 Deploy the new style in your organization as de scribed in Loading style files on page 123 In partic ular it is not necessary t
129. ly viewed data range or visible scales Anchoring items Using the handles of bars process arrows milestones brackets and shades you can attach these items to other items When you click a handle with the mouse the available anchors highlight Drag the handle within the current row to set the selected item s date manually or drag the handle onto an anchor of some other item to attach it to that item s 10 13 13 Certification of binary image complete de Graaf Dillon 13 11 5 13 12 3 13 C A Xmas Launch 1 13 14 Items remain anchored while they are being edited For instance when you anchor a milestone to the end of a bar this connection enforces that the milestone is always at the same date as the end of that bar In particular whenever you move the bar afterwards the location of the milestone will be updated accordingly P 10 13 13 Certification of binary image complete de Graaf Dillon 13 1 5 33 12 3 13 For another example inserting a shade implicitly creates an additional bracket which is anchored to the shade When you move the shade the attached bracket moves Project timeline Gantt chart 75 along Still you can detach the bracket move it to a different location or delete it Note ltems can be anchored across different rows When you drag an item s handle the date changes but the item remains in its row To move an item to a dit
130. matically assigned different styles The scales context menu offers the following buttons X Delete Shortcut Delete Delete the selected scale You can show the scale again using the Scales menu from the toolbar When you deleted a scale it will not show again automatically even when the chart size or date range is changed Open Calendar Shortcut double click Open the calendar dialog refer to Moditying the date range on page 66 Tj Add Vertical Separator Lines Explicitly add or remove vertical separator lines for the selected scale You can also remove separator lines by selecting them and pressing the key The software automatically adds and removes these lines unless you are making an explicit choice B Add Scale Label Add descriptive text to the selected scale The label contains language dependent prede fined text which can be replaced as needed Project timeline Gantt chart 70 Rows Activities A project timeline is made up of rows each representing a certain activity that is named in the label to the left The rows in turn contain timeline items such as bars milestones and brackets You can explicitly select an entire row to change its look add or remove labels drag it to another location or use Shift NHAN and the cursor keys 1 and 1 to move it Remove Responsible Label Column Note There is a special row below the chart reserved for the most important milestones You cannot add b
131. me on the 2nd 17th 18th of the same month The license key dialog is used to notify the user If the license key has not yet expired the message The li cense key of this think cell product will expire soon You should enter a new license key is shown together with the expiration date The user has the following choices Enter a new license key and click OK Click Cancel to dismiss the dialog Click Uninstall to uninstall think cell If the expiration date has already passed the message The license key of this think cell product has expired Please enter a new license key is shown but clicking OK is only possible after a valid license key has been entered If the dialog is dismissed using Cancel think cell remains deactivated To prevent the license expiration dialog from being shown please make sure to order and deploy a new license key more than 14 days before the expiration date new license key is always valid immediately and not only after the expiration date of the old license key Therefore you should deploy the new license key as soon as it is available g Online quality assurance At think cell we are committed to stability and robust ness as key factors for the professional use of our soft ware When an error condition arises while you are us ing think cell the software automatically generates a re port that helps us to understand the problem and fix it in the next release An automatica
132. monly used for standard column charts The wiggle break as illustrated below is con venient to save space in charts with wide or adjacent g columns lf enough space is available you can tog gle between the two shapes with Set Wiggle Straight Shape in the break s context menu Note In line and area charts only the wiggle style is supported 15 i E 3 2 2 2013 2014 2015 Date axis If the datasheet contains strictly increasing year num bers the number format of the axis labels can be changed to one of the date formats e g yy for two digit years yyyy tor four digit years and ad ditional formats containing days and months see Number format on page 35 and Date format codes on page 6 When the labels are formatted as dates or when Excel s cell format is set to Date for all category cells you are using a date axis When adjusting the scale of a date axis years months and weeks can be used for tickmark spacing You can mix two and four digit year numbers on a date axis For example you might display the first and last category with four digit years and all categories in be tween with two digit years Char decorations 47 To choose the number of digits you click the label you want to change and adjust the format think cell will au tomatically adjust other labels to ensure a consistent dis play For example if you only select the first label and use the two digit date format yy all labels switch to two
133. n and releasing will move the axis g You will notice when selecting and dragging the value y axis of a line chart that two locations on either side of the chart are highlighted Dragging to either of the locations will position the y axis on the appropriate side of the chart 2013 2014 2015 The location selected however also sets the crossing behavior for the chart Two distinct styles of crossing be havior are supported for line charts Crosses At Categories The y axis crosses the x axis at the center of a category In this case the data points of the first category are placed directly on the y axis Crosses Between Categories The y axis crosses the x axis between two categories Consequently the data points are offset from the border of the char Regardless of the crossing behavior of the axis the x position of data points always corresponds to the center of the category Selecting either of the innermost highlighted locations will set the behavior to Crosses At Categories while se lecting either of the outermost highlighted locations will set the behavior to Crosses Between Categories The E and E buttons in the value axis context menu can also be used to alter the crossing behavior Chart decorations 45 Value axis context menu Value axes have their own context menu It shows the following buttons Add Tick Marks Add or remove tickmarks 3j Add Tick Labels Add or remove tickmark labels
134. n one action click the first label then hit 7 click the last one see Multi selection on page 18 Value line In menu Chart Menu item d This feature displays a line parallel to the x axis to visu alize a certain value You can create multiple value lines per chart and you can choose to have the line s label placed to the left or to the right of the chart Where appropriate the value line is initialized with and snaps to the arithmetic mean stacked chart clustered chart or the weighted mean Mekko chart of the col umn totals If the line is snapped to such a value this value is calculated and automatically updated when data changes You can drag the line as desired If you need to increase the precision of the dragging operation use PowerPoint controls to zoom in on the slide You can also use the cursor keys to nudge the line to a specific value When using the cursor keys the line moves in increments corresponding to the label s number format g As always you can add custom text to the label or re place the predefined label with your own content You can learn more about labels and text fields in the chap ter Text labels on page 32 You can also change the label s font see Font on page 35 and number format see Number format on page 35 39 20 17 90 I i 401225 6 68 4 35 2 70 2 64 fey i 3 100 indicator In menu Chart Menu item q This fea
135. nique identification number that is used to maintain the link The technical requirement for reestab lishing a link is that both the Excel file containing the data range and the PowerPoint file containing the chart are simultaneously open on the same computer irrespective of the file names Excel data links 94 Data Links dialog If you have a large number of charts in your presenta tion finding and updating all linked charts manually is not practical For a better overview and a more directed approach to update your charts go to the More menu in the think cell toolbar in PowerPoint and open the Data Links dialog More gt JE Data Links Ds The data links dialog shows all linked charts of the cur rent presentation and their update states Linked To Modified C Data 2013 04 16_agriculture xdsx 09 12 2013 1 43 PM 09 12 2013 1 43 PM 09 12 2013 1 42 PM 09 12 2013 1 42 PM 09 12 2013 1 41 PM 09 12 2013 1 40 PM 09 12 2013 1 38 PM 09 12 2013 1 38 PM gt 5 o file not saved C Data 2013 04 16_public xlsx file not saved C Data 2013 04 18_financial xlsx C Data 2013 04 16_public xlsx C Data 2013 04 16_agriculture xlsx C Data 2013 04 16_agriculture xlsx lt 1 11 a i v For each linked chart the following information is avail able in the data links dialog Slide number and a thumbnail that shows the position of the chart on the slide Name of the Excel file that cont
136. ns when a linked chart is deleted When you delete a linked chart the link in PowerPoint is removed together with the chart If there is no other chart in an open presentation linking to the same Excel data range the frame in Excel turns from green to red indicating that the link cannot be established The linked data range in Excel is not affected in any other way by the deletion of a linked chart After all it is possible that a copy of the linked chart has been made which when opened should reestablish its link How can get rid of the red frames in my Excel worksheets Different coloured frames in the Excel worksheets indi cate linked data ranges A green frame indicates that a link has been established between the framed data range and a chart in an open PowerPoint presentation In contrast a red frame indicates that no linked char is currently open red frame does not necessarily mean that there are no charts at all linking to that data range It g just means that in the currently open presentations there are no such chars If you are sure that the framed data range is no longer required as a data source for any chars you can re move the frame with the X Delete button from the con text menu Together with the frame the link information is removed from the Excel workbook Any charts that are linked to the concerned Excel data range will not be able to establish their links in the future Instead they will use
137. nually adding or re moving scales or separators Altogether there are five scales available in the project timeline chart Years quarters months weeks and days In addition to showing or hiding scales think cell sup ports several options to change the look of the calendar All of these settings are available in the menu Scales lo cated in the floating toolbar of the Gantt chart or one of the currently visible scales The Scales menu offers the following options Using Scales show or hide each of the five avail able scales years quarters months weeks days Depending on the chart s current size and date range some scales may not be available because there is not enough room to show their units Once you decide to show a scale it will not hide again automatically even when the chart s size or date range is changed Using Separators show or hide vertical separator lines for each of the available scales years quarters months weeks days Enable or disable Automatic Scales Separators When enabled think cell shows appropriate scales and separators depending on the date range chart Project timeline Gantt chart 69 size and font size Once you explicitly show or hide a scale or a scale s vertical separator lines this option is disabled When you enable it again think cell reverts to the scales and separator lines shown automatically Enable or disable Workweek Only When enabled
138. o send the XML file to your colleagues but you should of course keep it for your own reference Customizing think cell 126 D Style file format think cell style files are XML files conforming to the schema http schemas think cell com 24132 tcstyle xsd style The styie element is the root element of a style file The mandatory attribute name sets the name that is shown in the More menu as the currently active style The attributes xmlns xmlns xsi and xsi schemaLocation should not be changed from the example when creating a new style file When changing an existing style file please up date the build number in the attributes xmins and xsi schemaLocation to the one shown in the follow ing example Example style name Example style name xmlns http schemas think cell com 24132 style xmlns xsi http www w3 org 2001 XMLSchema instance xsi schemaLocation http schemas think cell com 24132 style http schemas think cell com 24132 style xsd gt lt style gt noStyle It a style tile only contains this element loading it will remove the current style information trom the master slide Example lt noStyle xmlns http schemas think cell com 24132 style xmlns xsi http www w3 org 2001 XMLSchema instance xsi schemaLocation http schemas think cell com 24132 style http schemas think cell com 24132 style xsd gt Defining colors line styles and markers Colors schemeClr A fill based on
139. of new timeline items Refer to Adding items on page 72 for more information The row s context menu offers the following buttons You can apply all of these buttons to one or multiple selected rows X Delete Shortcut Delete Delete the selected row E Insert Row Shortcut Al nset Insert a new row after the selected one If the selected row is the one below the chart s bottom line the new row is inserted before Iz Add Activity Label Column Shortcut F2 Add or remove the activity label column A headline for the column is added which you can overwrite or remove it necessary With F2 you can edit the selected row s activity label Project timeline Gantt chart 71 Add Responsible Label Column Add or remove the responsibility label column A headline for the col umn is added which you can overwrite or remove if necessary za Add Remark Label Column Add or remove the remark label column A headline for the column is added which you can overwrite or remove if necessary lee Add Row Shade Add or remove shading You can change the shading s color and also add or remove the shading using the fill control in the think cell tool bar Shading works also well for multiple successive rows 5 Add Row Separator Add or remove a separator line above the selected row Row labels Each row supports up to three labels resulting in up to three text columns next to the actual timeline The de fault headlines for the thr
140. ompared to the column sum of 3 resulting in the display of 4 6796 Another application is illustrated by the following chart For the central column the waterfall total of 5 was set as the 10096 value in the datasheet Using the 96 of datasheet 100 setting it is possible to show that the Upper two segments correspond to 4096 of this total Waterfall chart 58 10 Mekko chart A Mekko chart sometimes also called marimekko chart is a two dimensional stacked chart In addition to the varying segment heights of a regular stacked chart a Mekko chart also has varying column widths Column widths are scaled such that the total width matches the desired chart width To preserve the visual relationship between widths of different columns there are no gaps between columns in a Mekko chart In fact the baseline of a Mekko chart is a fully fledged value axis You can select it with the mouse and you can use its context menu to add tickmarks tickmark la bels and an axis title see Value axis on page 43 If you have enabled tickmarks for the baseline you can use the floating toolbar of the axis to switch between absolute and percentage values A Mekko chart can also be decorated with some of the features described in Scales and axes on page 43 and Arrows and values on page 49 The labels of the Mekko chart support the label content property which lets you choose whether you want to display absolute values percentages or bot
141. on page 25 and Styling the chart on page 26 to learn how to con figure and style the chart As well as creating a new chart you can link a selected data range in your Excel workbook to an existing chart in a PowerPoint presentation Simply click the amp 3 To Ex isting Chart button from the Charts menu in Excel s think cell toolbar and click on the chart in PowerPoint that you wish to link to Note Text fields in PowerPoint can contain up to 255 characters Any additional text from the Excel data source will be truncated See Text fields on page 35 Transposing linked data Having linked a data range to a chart you can alter how the data is interpreted using the St Transpose Link button in the think cell context menu of the data range Transposing a data range swaps the chart s row and col umn data interpretation letting you for example create column charts from rows rather than columns of data 1 Select the green boundary around the data range js 2 Right click on the boundary to invoke the context menu 3 Select the button Transpose Link Transpose Link Note Transposing a linked data range does not swap the data in the rows and columns Updating a linked chart The most important function of a chart that is linked to an Excel workbook is the option to update the chart ac cording to changes in the underlying data In our exam ple we want to add a third data series Double click the chart
142. or this color scheme InfillSegmentMekko The outline style for Mekko charts using the parent element s color scheme It omitted the line style from 1nfillSegment is used Example Here noLine is used for segment outlines However as this is often not appropriate tor Mekko charts these use a thin solid line with the standard foreground color fillScheme name PowerPoint Theme gt lt lnfillSegment gt lt noLine gt lt 1nfillSegment gt lt infillSegmentMekko gt lt lnRef name Solid 0 25 pt gt lt solidfillRef name tx1 gt lt 1nfillSegmentMekko gt g lt fillRef name accent1 gt lt fillScheme gt Lines in charts The following elements are child elements of the el ement chart InfillAxis The default chart axis line style InfillAxisCategory The category axis line style Can be used to set a thicker baseline weight It omitted InfillAxis is used InfillArrow The default line style used for difference arrows InfillArrowCAGR The line style used for CAGR ar rows InfillArrowCategoryDifference The line style used for category difference arrows InfillArrowSegmentDifference The line style used for segment difference arrows InfillExtensionLine The line style used for extension lines of segment difference arrows InfillConnector The line style used for connector lines InfillValueLine The line style used for value lines InfillTrendLine The line style used for t
143. ormulas and uncheck the box Enable background error checking in the section Error Checking have a lot of Excel files to visualize with think cell Can run think cell in batch mode It is possible to program think cell think cell offers a function to create presentations from templates see Pro gramming think cell on page 137 Excel data links 101 19 Excel data rounding When data is compiled for a report or PowerPoint pre sentation rounding summations in Excel is a frequent problem It is often desirable but difficult to achieve that rounded totals exactly match the total of the rounded addends For example consider the following table 4 3 15 3 21 4 41 0 10 5 7 6 3 7 21 8 17 9 18 3 19 5 22 3 11 5 17 4 20 9 49 8 43 8 98 6 65 5 When the values are rounded to integers using Excel s Format Cell function the following table results Totals which appear to be miscalculated are in bold Total 4 15 21 41 11 8 4 22 18 18 55 12 17 50 44 59 168 Similarly when Excel s standard rounding functions are used totals of the rounded values are calculated cor rectly but rounding errors accumulate and results of ten deviate substantially from the actual totals of the original values The following table shows the result of ROUND x 0 for the example above Totals that deviate from the original value by 1 or more are in bold Total 4 15 21 40 11 8 4 23 18 18 56 12 1f i JU Using think cell round yo
144. osition of the text cur sor If you move the mouse over highlighted errors you will get a tooltip with a detailed explanation of the error The same information is also available in the Error List window regardless of where your mouse pointer is To show it go to View gt Error List Several sample style files are delivered together with think cell and you can find them in the subfolder styles in the think cell installation folder First find out the loca tion of the installation folder It is shown when you click About in the More menu think cell amp 6 build 23038 32 bit Activated products chart layout BA 2002 2013 think cell Software GmbH All rights reserved Made in Germany This product is protected by U S patents no 7 478 328 7 716 578 7 757 179 and 8 458 587 and pending U S patent applications serial no 12 698 365 and 13 360 015 The current customization ID is 530 Install directory C Program Files think cell Open this folder and go to the subfolder styles e g C Program Files think cell styles Open the file example style default xml It should look like this DQ comple style detour Microsoft Visual St trl Pe D x ELE EDIT IEW PROJECT DEBUG TEAM XML JOOLS TEST WINDOW HELP e B agiw gt A lt xml version 1 0 encoding UTF 8 standalone yes gt 4 style name Style name here xelns http schemas think ce com 22065 a lt fillist gt nofill name No Fill
145. p GroupInsertlIllustrations the default po sition in Excel is after the Insert Excel Charts group GroupInsertChartsExcel in the Insert tab Detailed information about customizing the Office rib bon is available from https www think cell com ribbon The following properties may be specified during instal lation to customize the think cell group within Power Point RIBBONPPTABINSERT Specify XML attributes for the tab element containing the think cell group RIBBONPPGROUPINSERT Specify XML attributes for the think cell group element RIBBONPPXMLNS Specify additional XML namespace at tributes for the customUI element Note All of these parameters apply to the setup msi as well as the setup exe Deployment guide 114 If no id idMso or idQ attribute is specified using the RIBBONPPTABINSERT property then the think cell group will be placed in the Insert tab Similarly if no id or idQ attribute is specified using the RIBBONPPGROUPINSERT property then a unique local id for the think cell group will be automatically generated Additionally if no la bel is specified using the RIBBONPPGROUPINSERT property then the label think ce11 will be used Adding the following option to the setup command line for example will place the think cell group in a new user defined tab positioned after the built in Home tab RIBBONPPTABINSERT id TabNew label My New Tab insertAfterMso TabHome Note Any quote characters
146. pic El r y 3 The size of the agenda element is always determined dynamically depending on the length and number of chapter headings Therefore you should lock two edges Agenda 83 of the agenda element at most so that in can grow and shrink by placing the other edges dynamically To change the position of a locked edge drag the lock icon to another position To unlock an edge and let think cell place the agenda automatically again simply drag the lock icon away from the ruler Multi level hierarchy of chapters The chapter hierarchy is determined by text levels PowerPoint provides several ways to change these You can use PowerPoint s demote and promote buttons or hold down shit 1 Al and use the arrow keys and D Lower level chapters will only be shown on chapter slides of the same level and on the slide of the parent chapter If a chapter with hidden sub chapters is selected a marker Y is shown below the beginning of the heading text Clicking this double arrow takes you to the first chapter slide that shows the hidden sub chapters Agenda slides will be hidden during the slide show if there are no slides between a chapter and its first sub chapter i e the main chapter does not have content of its own This avoids having to fast forward chapter slides until you reach the actual content during slide shows lt is achieved by automatically setting PowerPoint s Hide Slide attribute For example when a chapter
147. polate 41 invalid license key see license key keyboard shortcuts see shortcut keys label 25 32 adding text 34 automatic placement 33 content 36 context menu buttons 32 font 35 inside 33 manual placement 33 number format 35 paste multi selection 36 Index 146 rotate 34 segment 33 selection 17 types of labels 32 label content control 36 language 110 language dependency 76 legend 53 license key 11 line chart 39 line color 21 line scheme control 21 line style control 21 logarithmic scale 47 magnitude 36 marimekko see Mekko chart marker scheme control 22 marker shape control 21 Mekko chart 58 ridge 59 with 96 axis 58 with units 59 Microsoft OLE 97 milestone Gantt chart 72 msiexec 108 Multi selection 18 36 ZNUM Excel error value 105 number format control 35 Object Linking and Embedding see Microsoft OLE online quality assurance 13 116 outlines 21 panning 19 partition 65 pentagon 79 percent of datasheet 100 56 pie chart 61 PowerPoint files 119 g precision control see number format control primes in numbers 36 programming think cell see API project timeline 66 property controls 35 category sorting 21 color 19 color scheme 20 font 35 label content 36 line scheme 21 line style 21 marker scheme 22
148. portdesk yourcompany com Deployment guide 118 E Deployment guide lt xml version 1 0 encoding UTF 8 standalone yes gt root CUpdateInfo id 1 gt m vecupdscen length 2 gt lt list of 2 different update scenarios gt lt First scenario the group of pilot users gt lt This scenario is evaluated first and if it ts executed the second scenario is skipped gt lt elem gt lt Update file of this scenario The pilot group receives think cell build 17950 gt lt m_bstrFile gt http example com setup_17950 exe lt m_bstrFile gt lt List of 2 conditions that must _all_ be met to install the file gt lt m_vecupdcond length 2 gt lt elem gt lt WQL query that an earlier build of think cell is installed The query searches the local WQL database not the network Thus it will either return one product record tf an older product is installed or none otherwise gt lt m_bstrQuery gt select from Win32_Product where Name think cell and Versiong1t 1 17 950 0 lt m_bstrQuery gt The number of returned records is now numerically compared 2 stands for less than 1 for less or equal 0 for equal 1 for greater or equal 2 for greater than gt lt m_eupdcondop val 0 gt Compare to numerical value 1 gt lt m_nCount val 1 gt lt elem gt lt elem gt WQL query that the computer system is named ANNA TOM or FRANK the group of pilot users
149. present 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 x 105 Text labels 37 Number format control Output 1 234 000 3 842 230 1 234 0 3 842 2 1 00 3 84 a 4 Magnitude Values from data sources often have magni tudes that are not appropriate for data presen tation 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 ta ble is filled with seven digit values e g 3 600 000 00 but you would preter to show values in units of millions Simply select x10 from the floating toolbar and the labels will show the appropriately scaled values Label content Most labels have a label content control Use the control to choose text tields with which to fill the label For example the seg Abs co ment labels in the column chart can show 6 absolute values and or percentages For ss 9ps details about filling in the datasheet refer to Absolute and relative values on page 29 o 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 Pasting text into multiple labels With think cell creating data driven charts is quick and easy but you still have to type the text If you already js have it available in some table or t
150. preserve any of the changes then they must be manually re applied to the think cell element Continue editing without think cell functionality contin ues to use the PowerPoint edited version and ensures that all changes are preserved The intelligent think cell element functionality however is lost and stan dard PowerPoint tools must be used to further edit these shapes and objects If you decide to use Manually carry over changes to think cell then the following toolbar is displayed letting you compare slides containing the alternative versions of the think cell element I Slide 31 E think cell version Einish cancel Help The toolbar lets you quickly and easily view the slides containing the PowerPoint and think cell versions of the element You may want to compare the think cell element with the PowerPoint version and compare and copy for ex ample data values to reflect any changes that you wish to preserve in the think cell version Having made any necessary changes click the Finish button to remove the PowerPoint version from the pre sentation and end the reimport process Exchanging files with PowerPoint 121 C Customizing think cell This chapter describes how to customize think cell i e how to change default colors and other default proper ties The following properties can be changed using style files The list of available colors and patterns see Color and fill on page 19 Bl tc R
151. ption Security note All tiles that are executed and installed by the automatic update are digitally signed by think cell The integrity of the update is verified against a self signed certificate that is included in the version of think cell currently installed This is more secure than the usual procedure of verifying the update against a certificate issued by a certificate authority In particular two types of attack are avoided First certificate authorities may be subject to impostor attacks e g a third party ob taining a fraudulent certificate from a trusted certificate authority by pretending to be think cell Second Micro soft s Automatic Root Certificates Update can silently in stall new trusted root certificates on demand By these means Microsoft may introduce new root certificates which are not subject to public scrutiny but which are used by Windows to establish trust Trouble shooting For latest information on known issues and workarounds please refer to our website at https www think cell com kb g If you cannot find a solution in the knowledge base or this manual feel free to contact our support team Open the More menu in the think cell tool bar and click on Request Support Choose from the opening window whether you would like to attach certain slides to an e mail to think cell s support team This is often useful to point up a problem After confirming with OK your e mail application will open
152. pty except for its headline Move the mouse over the label column to discover label placeholders which you can select just as any other features in think cell Use the placeholder s context menu to create either a text label or a check box or a Harvey ball To quickly create a text label you can simply select a placeholder and start typing Simi larly you can recreate the headline labels if you deleted them The row label s context menu shows the following but tons X Delete Shortcut Delete Delete the selected label Switch to Checkbox Use a checkbox instead of a text label see Checkbox and Harvey ball on page 79 If Project timeline Gantt chart 72 the selected label already contains text the text will be discarded O Switch to Harvey ball Use a Harvey ball instead ot a text label see Checkbox and Harvey ball on page 79 If the selected label already contains text the text will be discarded text Switch to Text Label Shortcut F2 or start typing Use text for this label Select and overwrite the placeholder text that is inserted when you click this button Add Bracket Add or remove the selected label s bracket Brackets are added automatically to labels that span more than one row see Labels spanning multiple rows on the current page This option only applies to responsibility and remark labels Since activity labels always refer to precisely one row these labels do not need brackets To remove a la
153. range is transposed or not Call tcaddin UpdateChart pres Noi rng False Save the updated presentation pres SaveAs c example_updated pptx pres Close ppapp Quit End Sub E Programming think cell 140 using Excel Microsoft Office Interop Excel using PowerPoint Microsoft Office Interop PowerPoint using Office Microsoft Office Core Open the Solution Explorer gt right click the project file gt Add Reference button and add he following references NET tab gt Microsoft Office Interop Excel 12 0 0 0 NET tab gt Microsoft Office Interop PowerPoint 12 0 0 0 COM tab gt Microsoft Office 14 0 Object Library namespace ConsoleApplication_UpdateChart 1 class Program 1 static void Main Excel Application xlapp new Excel Application xlapp Visible true Excel Workbook workbook xlapp Workbooks Add 1 Excel Worksheet worksheet Excel Worksheet workbook Sheets 1 worksheet Cells 3 1 Series 1 worksheet Cells 3 2 1 worksheet Cells 3 3 2 worksheet Cells 3 4 3 PowerPoint Application ppapp new PowerPoint Application PowerPoint Presentation presentation ppapp Presentations pen C test pptx Office MsoTriState msoFalse Office MsoTriState msoTrue object aobjArg new object Y object presentation ChartNoi worksheet get_Range A1 D3 false Office COMAddIn comaddin xlapp COMAddIns Item thinkcell addin object objAddIn comaddin Objec
154. regulations and therefore free for general use Contents n Product overview 0 ccc ee eee eee asas Installation and Update 1 een een eee een hrs IAN TSG TIO Lee eo ns wr dee d ROS hs eons Kendo wine eee oid rd ape eq Hed quads gode de osa First WISQUONON iuda dg ER tdid eiei ida eie Sa iP RN EEE OA vas addis REX REARS vases fia ie E wa TT TTE TT ee ed ETT IT TOT TETTE PO ee CIT DET ETT Troubleshooting 6 6 6 oeea ten doe Rente ae donde e owl bn Hed sro Gba den deber AS senate LE DONC ERES s sod hh oe ne ee UE ROV RC EUER Su Oe ee OR Ban Temporarily arab TA oe ceo don ce oe ad Ao CRI Re dH o 9d curd qa RR dd o AA Peeler cried Clemens Me iade toda ed ere eos e anb dac doa nice dde acne A A O QUIT Oa ee Pe TOR Rotating and flipping elements x iaces nar eic es erdt er aee Ce Robo da dore dea O Lacus aatia d E dor Pa a oh o E oe es Oa eae a ee Selecting elements and features iu skoda tes vereda ed ib bees ehe Ea RUE A da a cuco SER uoi sx ran badebe sete ian ees cud REA Ede XE anos ad E dde Introduction 14 14 15 17 17 17 19 P Contents 4 Charting 4 Introduction to charting seek eni RETE RE RREGaR EG YER GOES GR EXG ax ee ban id a LPS RE Rn 24 MN a societe dera f Rr eda PLA drip dae eh qd OA a hr etn io Beton a dnd Rura 24 Adina ena removing ADOS ioi doe doi org d he OR QU a o dere oc i S dne BOR eee GR CR RU Re Ea EA 25 sc o AS 25 BS Ba es oo ee res eee eb ean yes aol V Hus re eee eek wa eee cu Ho
155. rend lines Style file format 135 InfillPartition The line style used tor partitions InfillErrorBar The line style used for error bars Lines in the legend The following element is a child element of the ele ment legend Infill The legend outline Example legend lt lnfill gt lt lnRef name Solid 0 75 pt gt lt solidfillRef name Dark Gray gt lt 1nfi11 gt lt legend gt Lines in connection with labels The following elements are child elements of the el ement label InfillleaderLine The line style used for the line be tween a segment label and the segment when the la bel is not placed inside the segment If solidfillRef is not specified instead of using the color from 1nfillDefault think cell uses the color matching the automatically set label font color InfillBubble The line style used for the outline of dif ference arrow labels g Customizing Harvey ball and checkbox harveyball A combined style for the Harvey ball consist ing of the child elements fillRefCompleted and fillRefBackground to describe the color of the completion state and the background color of the Harvey ball respectively Example lt harveyball gt lt fillRefCompleted name Black gt lt fillRefBackground name White gt lt harveyball gt fillRefCompleted See fillRef fillRefBackground See fillRef checkbox A combined style for the Checkbox consisting of the child element iii
156. rs Open the Insert Symbol dialog from the More menu in the think cell toolbar More dE Data Links m Insert Symbol N You will find all the symbols you need on a single page grouped by usage context Now with a click of the mouse you select the desired character or symbol and the character is inserted at the cursor location Note If no shape or text label is selected the think cell special character dialog has no effect If you have one shape or text label selected it will be switched to text editing mode Save and send selected slides Sometimes it is useful to save parts of a set of slides With think cell you no longer need to duplicate the file and then delete unwanted slides Simply select the de sired slides from the outline pane on the left or from the slide sorter view click on More from the think cell tool bar and choose Save Selected Slides After the new file is created it is immediately opened for editing If you want to send the selected slides by e mail you can also choose Send Selected Slides and an e mail tem plate with attachment will be composed in your default e mail application The files created by using Send Save Selected Slides contain a time stamp conforming to ISO 8601 in the file name to make them globally unambiguous The file Presentationi slides 2 3 20110121T1556 01 ppt would contain Slides 2 through 3 from Presentationi ppt and was sent or saved on January 21 2011 at 15 5
157. s and click the 3 Fit Scale to Data button If you are not sure which charts share the same scales the easiest way is to revert the same scale for all chars then to select the requested charts and to activate same scale Note It you apply the same scale operation to charts that have value axis breaks the breaks are automatically removed see Value axis break on page 44 As long as breaks are present it is impossible to make the selected charts visually comparable Logarithmic Scale You can switch to a logarithmic scale by using the Set Logarithmic Scale button from the value axis con text menu To revert to a linear scale choose E Set Linear Scale Chart decorations 48 Note Due to a limitation in Microsott Graph an axis with a logarithmic scale can only have tickmarks at pow ers of 10 e g at 0 1 1 10 The axis must also begin and end at a power of 10 Logarithmic scaling is not supported when it is mathe matically not appropriate Negative values are placed on the baseline and an exclamation mark is shown next to the label explaining that the value cannot be represented on a logarithmic scale Also an axis always uses a linear scale if multiple series that are added up to a total are associated with the axis Secondary Axis Charts containing lines may have an additional sec ondary y axis You can add a secondary y axis and as sociate a line with this axis by highlighting a line and selecting the j
158. s defined in the Office Open XML standard The attribute val specifies the color name and must be one of the names from AliceBlue to YellowGreen enumerated in msdn microsoft com en us library documentformat openxml drawing presetcolorvalues aspx or in subsection 20 1 10 47 of the Office Open XML standard Example lt prstClr val white gt Fills solidFill A fill based on a single color The color can be specified using either one of the child ele ments schemeClr srgbClr Or prstClr he attribute name contains the name shown in the color list Example lt solidFill name White gt lt srgbClr val FFFFFF gt lt solidFill gt pattFill A patterned fill based on a pattern and two colors The colors can be specified using the child elements fgC1r and bgC1r describing the foreground and background color of the pattern respectively The pattern itself can be specified declaring the at tribute prst and referencing a pattern described in Office Open XML The attribute name contains the name shown in the color list Example qe lt pattFill name Outlined diamond prst openDmnd gt lt fgClr gt lt prstClr val black gt lt fgClr gt lt bgClr gt lt prstClr val white gt lt bgClr gt lt pattFill gt fgClr Describes the foreground color of a pattern fill The color can be specified using either one of the child elements schemeClr srgbClr Or prstClr Example lt fgClr gt lt prst
159. s in existing charts you need to do so manually Deploying think cell styles Load Style File loads a style file into the master slide of the current presentation When the presentation is dis tributed as a PowerPoint template the think cell style is implicitly distributed as well It should not be necessary to give a think cell style file to individual users Switch ing between styles is accomplished by switching between PowerPoint templates Style file tutorial In think cell s installation directory usually C Program Files think cell in the sub directory styles you can find the style file example style default xml This style mirrors the colors and color schemes that are available imme diately after installation when no style is loaded Therefore 1 Make a copy of example style default xml and load it into an XML editor see Creating a think cell style on the previous page for choosing a suitable ed itor g 2 Walk through the file from top to bottom making the changes described in the following steps 3 Remove any unneeded colors from the list inside the fillLst element You will find solidFill pattFill and separator elements corresponding to the items in the color list displayed in think cell see Color and fill on page 19 To remove e g a solidFi11 ele ment remove everything between and including the opening tag solidFill and the closing tag lt solidFill gt 4 Optionally create a ne
160. se Excel Fill in Wc the color scheme control see Color MS Smoke 20 scheme on the next page To reset amp smoke sox Hi Smoke 60 the fill color of a segment you col m s Bl Smoke 90 ored manually choose Like Excel Cell wie Light Gray to use Excel s cell formatting Med Gray Bl Dark Gray B Black SS Light downward diagonal 27 Light upward diagonal N Wide downward diagonal 74 Wide upward diagonal Dark horizontal Il Dark vertical 25 Outlined diamond Diagonal brick Custom g If you need other colors than offered by the color control select the Custom option from the dropdown box You will then be presented with a color picker where you can choose any color you like Red 187 Green 224 Blue 227 Cancel Note It you want to apply a color other than black or white make sure that the slider for the brightness on the very right of the dialog is not set to minimum or maximum When you move the slider up or down you can watch how the color changes in the colored field on the bottom of the dialog think cell adds the most recently used custom colors to the color control for quick access You will find a divider line in the list of most recently used colors The colors above the divider are saved within the presentation so you can rest assured that your colleagues have them available when editing the presentation The colors be low the divider are available on your computer only be cause yo
161. sentation is not open and then the pre sentation is opened without the Excel workbook being open at the same time the linked charts will not detect the changes in their data sources As soon as the Excel workbook containing the linked data range is open the link will be established and the changes will be detected IF the chart is set to Auto update it will update now Oth erwise the chart will be highlighted in the Data Links dia log and it will be flagged when selected You can then decide whether you want to incorporate the changed data into the chart or not For more information read section Updating a linked chart on page 92 Why is my linked chart indicating a pending update although the data in Excel did not change Whenever a link is established between an open Power Point presentation and an open Excel workbook the data from the internal datasheet is compared to the linked data range If they are not the same the chart is flagged to indicate that an update is due If Auto update is enabled it is updated immediately Excel data links 100 A pending update may also be detected when the data in the Excel workbook is unchanged but the data in the internal datasheet has been modified For a linked chart the linked Excel data range takes priority over the inter nal data sheet Therefore an update will always over write any changes in the internal datasheet To protect you against data loss whenever you make changes
162. st the size of the feature and use the color control to change its primary or outline color see Color and fill on page 19 For checkboxes you can g also change the style of the outline see Line style on page 21 When you select a checkbox an additional control be comes available in the toolbar which you can use to change the checkmark symbol You can also quickly change the symbol by double clicking the checkbox or by pressing the associated key on your keyboard e g for check or 3 for cross When you select a Harvey ball an addi tional control becomes available in the tool bar which you can use to change the Harvey ball s completion state You can also quickly increase the Harvey ball s state by double clicking it or pressing on your keyboard and decrease the Harvey ball s state by pressing on your keyboard Additionally you can directly set the number of com pleted Harvey ball fractions by entering it with the key board If the number of fractions is larger than 9 use the keys 1 to 8 to fill one eighth of all fractions or two eighths three eighths and so forth eeu 5 Next to the control you will find an other control with numbers These numbers indicate the number of fractions of the Harvey ball You can manually add your own values by entering them in the box Basic elements 8 16 Agenda Using the agenda element you can manage the agenda of your presentation create a table
163. stinguish between simple col umn charts and stacked column charts If you want to create a simple column char enter only one series row of data in the datasheet For a quick tour of the column chart refer to the example in the chapter Introduction to charting on page 24 Bar charts in think cell are simply rotated column charts and can be used exactly as column charts In addition you can create butterfly charts by placing two bar charts back to back To do so apply the functions rotation see Rotating and flipping elements on page 17 and same scale see Same scale on page 46 Then remove the category labels for one of the charts 35 25 43 For the steps to create a stacked clustered chart see Clustered chart on this page Clustered chart Icon in Elements menu ml 6 2013 2014 2015 The clustered char is a variant of the stacked column chart with the segments arranged side by side g A clustered chart can be combined with a line chart by selecting a segment of a series and choosing Py Set to Line Type from the context menu If you want to arrange stacks of segments side by side you can create a stacked clustered chart 46 Summer Category Gap To create a stacked clustered chart follow these steps 1 Insert a stacked chart 2 Click onto the baseline between the columns drag the gap arrow to the left and set the gap width to O 3 Click onto the baseline where you want
164. t 26 18 8 2013 2014 2016 Frequently asked questions What are the advantages over Microsoft OLE You may be familiar with OLE Object Linking and Em bedding in Microsoft Office The idea is similar to think cell s linking allowing the creation of chars in Power Point that can later be updated with data changes from Excel However think cell s linking technique has sev eral advantages over OLE The charts are always the same whether they are linked or not Even linked charts are native MS Graph charts not Excel charts pasted into PowerPoint Charts can be linked to Excel at any time not only when they are created Linked charts remain editable even when the linked data source is not available Links in think cell are independent of the file name or path Simply open both files and any existing links between the files are reestablished Excel data links 98 What happens when copying a linked chart You can copy a linked chart just like any other chart by duplicating a slide duplicating the chart Ci dragging the chart or copy pasting the chart to another slide or to another presentation In fact even making a copy of the presentation file is a way to copy a contained linked chart In any case the original and the copy are indistinguish able Both link to the same Excel data range and if they are open simultaneously will both receive an update when Excel data changes What happe
165. t Customizing charts fillSchemeRefDefault A reference to a fill scheme that is used as the default color scheme for all chart types If one or several of the elements fillSchemeRefDefaultStacked fillSchemeRefDefaultWaterfall fillSchemeRefDefaultClustered fillSchemeRefDefaultMekko fillSchemeRefDefaultArea fillSchemeRefDefaultPie fillSchemeRefDefaultBubble are used they override the default scheme set here for the corresponding specific chart type If all of these elements are used the fillSchemeRefDefault may be omitted Example lt fillSchemeRefDefault name Company scheme gt Style file format 133 fillSchemeRefDefaultStacked The default color scheme for stacked charts Example lt fillSchemeRefDefaultStacked name Stacked scheme gt fillSchemeRefDefaultWaterfall The default color scheme for waterfall charts Example fillSchemeRefDefaultWaterfall name Waterfall scheme gt fillSchemeRefDefaultClustered The default color scheme for clustered charts Example fillSchemeRefDefaultClustered name Clustered scheme gt fillSchemeRefDefaultMekko The default color scheme for mekko charts Example lt fillSchemeRefDefaultMekko name Mekko scheme gt fillSchemeRefDefaultArea The default color scheme for area charts Example lt fillSchemeRefDefaultArea name Area scheme gt g fillSchemeRefDefaultPie The default color scheme for pie charts Example
166. t objAddIn GetType InvokeMember UpdateChart System Reflection BindingFlags InvokeMethod null objAddIn aobjArg presentation SaveAs C test updated pptx presentation Close ppapp Quit workbook Close false xlapp Quit Figure E 1 UpdateChart example in C g PresentationFromTemplate Signature tcaddin PresentationFromTemplate wb As Excel Workbook strTemplate As String ppapp As PowerPoint Application As PowerPoint Presentation Description This function applies any data links in wb to the tem plate with filename strTemplate The result is a new presentation within the PowerPoint instance ppapp strTemplate can either be a full path or a relative path which is then taken to be relative to the loca tion of the Excel workbook file wb All charts in strTemplate that are linked to the Excel workbook wb are updated regardless whether they are set to auto update or not Then their data links are broken to prevent further changes to these charts Charts in strTemplate which are linked to Excel workbooks other than wb are left unchanged and still linked so it is possible to update links from multiple Excel workbooks by saving the result of this function as a new template and then calling this function again with the next workbook If you want to control the colors of chart segments with the Excel link you can set the color scheme to Use Excel Fill see Color scheme on page 20 Lik
167. t labels 34 It two labels are too close together offset one of them towards the center of the pie Manual label placement In general think cell automatically places all labels at appropriate positions If a label can be placed at mul tiple positions you can manually change think cell s placement decision 1 Select the label If a drag icon appears at the lower right corner of the selection then this indicates that there are alternative locations for the label 2 Drag the selection frame or the drag icon with the mouse While you are dragging available locations highlight and the blue selection frame jumps to these locations 3 Drop the label at the desired location 2013 sta 2015 Labels that do not show the drag icon when selected do not offer alternative locations When manually placing a series label alternative loca tions for the label will include any existing legend Leg end on page 53 for the chart Series A series B 2013 2014 2015 Once you have manually placed a label at a specific po sition 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 1 En able Automatic Placement button from the label s context menu y Drag here for 4 Automatic a 7 2013 obla
168. t will support you by automatically checking for errors and making sug gestions on how to solve them We recommend Micro soft Visual Studio for this purpose It seems to be a heavy package for such a simple task but as it turns out the task is not so simple after all and Visual Studio offers the best XML editing experience we have seen to date If you already have Visual Studio installed any version will do If you do not yet have Visual Studio installed simply choose the lightest available package which is Visual Studio Express for Web http www microsoft com visualstudio downloads There go to the section Community amp Express and locate the most recent release that ends with for Web e g Express 2013 with Update 4 for Web or a newer ver sion With Visual Studio installed you can open the XML style file and Visual Studio can retrieve the associated syntax definition XML Schema from our webserver automat ically and in the background you do not have to care or even know about it To enable this behavior In the menu go to Tools Options On the left go to the Text Editor category Choose the Miscellaneous XML Options page Enable Automatically download DTDs and schemas It will then highlight errors in your document and with Ctrl Spacebar you can trigger auto completion Visual Studio will offer a choice of tags attributes or values Customizing think cell 123 applicable to the current context p
169. tcut key or Alt Alt Insert Y 0 ma Middle mouse button click and drag AI Shift 1 Page up Description Toggle text edit mode in text labels Delete the selected element Remove the selected feature e g label Move focus across shapes on the slide Move focus across features e g labels of an element Gantt chart only Insert new activity Checkbox only set state Harvey ball only set state In Excel datasheet line break In Excel datasheet spell checking In zoom view Grab the slide and pan it around Align text inside text boxes up or down Index 10096 chart 39 10096 indicator 52 10096 cost curve 58 activity Gantt chart 69 agenda 81 API overview 137 PresentationFromTemplate 140 UpdateChart 137 application programming interface see API area 100 chart 41 area chart 4 arithmetic mean see value line arrow CAGR 50 difference 49 automatic update 12 average line see value line axis see value axis see logarithmic scale see secondary axis Background Intelligent Transfer Service see BITS bar Gantt chart 72 bar chart see column chart 100 see 100 chart clustered see clustered chart baseline break 48 BITS 114 bracket Gantt chart 72 break baseline 48 category axis 48 value axis 44 bridge chart see waterfall chart bubble char 62 64 butterfly chart 38 CAGR 50
170. tected The chart is not highlighted or flagged but you still have the option to manually revert the automatic update Change detection works only while both files Excel and PowerPoint are open at the same time Note If the linked Excel file for a chart is not avail able and the internal datasheet is opened and edited Excel data links 95 then automatic updating for the linked chart will be dis abled This ensures that any changes made using the in ternal datasheet are not automatically overwritten when the linked Excel file becomes available Update Revert and changing the Auto setting all work on multi selections as well Use Shit t click to select a range of links and Cri click to toggle the selection of individual charts Maintaining data links After the creation of a link between Excel data and a chart in PowerPoint both Excel and PowerPoint files con tinue to be self contained independent files You can pass on or edit the files independently You can rename the files The data links will be reestablished as soon as the Excel and PowerPoint files are open at the same time To store the infor mation about the reestablished data links the files should be saved You can copy and paste linked charts within the same presentation or even to another presentation The copy of the chart will then be linked to the same data source as the original You can send the Excel and PowerPoint files by e ma
171. ter ent row drag the item itself not its handles Changing the chart s appearance You can change the color of bars process arrows mile stones and shades using the color control in the floating toolbar Color and fill on page 19 The background color of the chart can be changed by selecting the whole chart and choosing the desired color from the floating toolbar By way of the context menu you can further configure the appearance of timeline items The context menu for timeline items comprises the following buttons depend ing on the type of the selected item X Delete Shortcut Delete Delete the selected item 7 Open Calendar Shortcut double click Open the calendar dialog for the selected item refer to Moving items on the previous page Set Solid Dashed Toggle the appearance of the selected bar or process arrow between solid and dashed Add Date Label Shortcut F2 Add or remove a label for the selected item By pressing F2 you can edit the label s item or create it if it does not yet exist By de fault the label contains the item s date which is up dated when the item moves see also ltem labels on the following page q Set Diamond Triangle Shape Toggle the shape of the selected milestone between triangle and diamond i Add Milestone Line Add a milestone line to the se lected milestone Item labels Bars process arrows milestones and brackets can have labels while shades are usua
172. the sum over all points of the quadratic difference be tween the Y coordinate and the trendline value at the X coordinate is minimized In a bubble char the bubble size is not used when calculating the trendline position There are two ways to add a trendline to the chart Right click a marker or a bubble of the desired group and select x Add Trendline from the context menu Select a partition line see Partition on the following page In the toolbar you can choose a group of val ues and the line is changed to a trendline for this group Y Axis 4 0 A Cucumbers 3 5 3 0 Pears Tomatos 4 2 5 9 2 0 Apples a Oranges Carrots 1 5 1 0 0 5 0 0 X Axis 0 0 05 10 15 20 25 3 0 You can change the background color on one side of the line and move the line in the same way as for a par tition line see Partition on the current page However once you have moved the line it will no longer be cal culated from the values in the datasheet Partition You can add a partition line to scatter or bubble charts to point up a partition of a set To add a partition line select s Add Trendline Partition from the chart s context menu You can move the line by clicking on it and dragging it to the desired position It is also possible to select the partition line and then drag the handles at the begin ning or end of the partition line While dragging the end points will snap to nice values The spacing
173. their internal datasheets The Excel data itself is not affected How can see which charts in a presentation are linked and where their linked data sources are If you are unsure about the data sources of the charts in a presentation go to the More menu and open the Data Links dialog This dialog displays a list of all linked charts in the current presentation Click on an entry to display the corresponding chart The file name of the Excel file where the linked data range was last found is also available The Auto check box indicates if the chart has been set to update auto matically For a detailed description refer to section Data Links di alog on page 93 What happens to a linked chart when its data source is unavailable When the Excel workbook that contains a chart s linked data range is not open and cannot be found in the same file location where it used to be the chart cannot es tablish its link Instead it will use its internal datasheet Excel data links 99 which always contains a copy of the linked data and allow you to change the chart The internal datasheet of a linked chart is similar to the one of a regular chart Even if there are multiple charts linked to the same Excel range their internal datasheets are independent If you want to reestablish the link to the Excel data range simply open the Excel workbook and the presentation with the linked chart at the same time The chart in PowerPoint an
174. ther charts detault to absolute values Transposing the datasheet The layout of a think cell datasheet depends on the chart type In bar charts for example columns contain the data for a single series while in column charts rows contain the data for a single series Here is a typical datasheet for a column chart Seres Series Series J m th amp fh The size of a think cell datasheet is limited to a max imum of 256 columns and 65536 rows If the data for your chart requires more than 256 columns you can use the 4 Transpose Sheet button to transpose the datasheet swapping the row and column data together with any category series interpretation Here is the trans posed version of the previous column chart datasheet D E 100 series Series Series Series 5 1 12 8 24 35 4 Data entry 32 Transposing the datasheet lets you create charts where the datasheet would normally require more than 256 columns and can often be used to simplify data entry when working with a large amount of data Note The limitation of the number of rows and colums is due to the same limitation of Excel datasheets in gen eral in Excel 2003 For compatibility reasons the limi tation also applies when using Office 2007 or later Reverse order in datasheet In think cell the visual order of data in the datasheet always corresponds to the order of the data in the chart This is also true for flipped charts see Rotating and
175. to label the chart with percentages or vice versa think cell performs the necessary conversion see Label content on page 36 A simple datasheet with only absolute values looks like this Series STE SE 33 Serles 2 4 2 Series l 35 4 21 el 1 2 3 4 5 E T 4 qe For simple charts based on absolute values only the 100 row on top of the chart data can be left empty If you choose to label the chart with percentages the per centages are calculated from the absolute values as suming the sum of each column to be 10096 You can enter explicit values in the 10096 row to override this assumption The following datasheet calculates percent ages based on 10096 being equal to a value of 50 Series Series Series 1 2 3 4 5 B 4 Alternatively you can fill in the datasheet with percent ages Again you can choose to label the chart with absolute or relative values In order to have think cell calculate absolute values from the percentages you en tered you should fill in the absolute values that repre sent 10096 in the 10096 row The following datasheet Uses percentages to specify the same data values Data entry 31 Series 10 6 Series 40 Series 25 09 70 8 43 6 1 2 3 4 5 E T 4 The default behavior of the datasheet depends on the chart type 100 charts and area or Mekko charts with axis as well as pie charts detault to percentages while all o
176. ture shows a 10096 mark It is on by default You can choose to have the label placed to the left or to the right of the chart 23 45 30 Series connectors Chart segment Menu item ra You can add series connector lines to an entire chart or to a single segment If you click the connector item of a In menus Chart decorations 53 segment s menu a connector line is created at the top right corner of that segment If you want a connector as part of a watertall calculation you must use the specitic watertall connector see Watertall chart on page 54 Al ternatively universal connectors see Universal connec tors on this page can be used when the desired connec tions cannot be achieved using standard connectors 18 17 Universal connectors al 1 i Icon in Elements menu a Universal connectors are different from the other deco rations described in this chapter because they do not belong to a specific element or feature Therefore they are not available in the think cell context menu Instead you can insert universal connectors from the think cell toolbar Double click the toolbar button to in sert multiple connectors To leave insertion mode click the button again or press the Esc key Each chart element can offer connectable points The universal connector can connect any two connectable points that may or may not belong to the same element Use the universal connector i
177. type of the current slide is selected so you need to scroll to the top and select the non indented slide master instead 4 Adjust the fonts of the body text placeholder to match your corporate design To adjust the default color settings simply change your presentation s color scheme Basic concepts 23 1 In the ribbon go to Design 2 In the group Themes click on Colors 3 From the drop down list choose Create New Theme Colors 4 Adiust the colors to match your corporate design In general it is advisable to store these defaults in a PowerPoint template file potx and to derive all new presentations from this template file Please refer to the PowerPoint help for information on how to do this Charting 4 Introduction to charting In this chapter a step by step tutorial will show you how A more elaborate presentation of the basic concepts of to create a chart from a scribble like this think cell and details on the various chart types can be found in Basic concepts on page 14 and in the following f j 560 1 chapters Inserting a new chart With think cell installed you will find the following group in the Insert tab of PowerPoint s ribbon J x Connector More Elements Pentagon Rounded Chevron Rectangle a Harvey Ball Checkbox Chapter Table of Spit Agenda Contents Stacked 100 Clustered Build up Build down Mekko Mekko Waterfall Waterfall 96 Axis Unit Axis Area Are
178. u can achieve consistently rounded totals with minimal cheating While most val ues are rounded to the nearest integer a few values are rounded in the opposite direction thus maintain ing correct calculations without accumulating rounding error Since there are many possibilities to achieve cor rectly rounded totals by changing values the software picks a solution that requires the minimum number of values changed and the minimum deviation from the qe precise values For example rounding down 10 5 to 10 is preferable over rounding down 3 7 to 3 The following table shows an optimal solution for the above example with cheated values in bold Total 4 15 22 41 10 8 4 22 18 18 55 12 17 2 50 44 58 To achieve this output in your own calculation simply select the concerned range of Excel cells Then click the TS toolbar button and if necessary adjust the rounding precision using the toolbar s dropdown box Using think cell round think cell round seamlessly integrates into Microsoft Excel providing a set of functions that are similar to Excel s standard rounding functions You can easily apply these functions to your own data using the think cell round toolbar buttons In Excel 2007 and later the toolbars have been replaced by ribbons The think cell round ribbon can be found in the Formulas tab Rounding Method I lt x XL 1 0000 32 More think cell round Rounding parameters Like th
179. u were using them in a different presentation Both sections can hold up to 8 colors When you use a 9th custom color the first one is removed from the list You should use the color property when highlighting specific segments or one series in a chart If you need to Basic concepts 21 colorize an entire chart use the color scheme property instead Color scheme The color scheme control ap B PowerPoint Scheme plies consistent coloring to all segments of a chart so the first series uses the first color in the color scheme the second se ries the second color and so on The coloring is automatically up dated when a series is added or removed See section Chang ing default colors and fonts on Usexel Fill on Tog page 22 for more information All Fill Color All White PowerPoint Scheme Smoke Blue Scheme Smoke Blue Scheme rev Patterns H PowerPoint Scheme rev When you check Use Excel Fill think cell applies the color from Excel s cell formatting to the chart in PowerPoint This is particularly convenient if you want to control the chart colors through your Excel data source in the case of a linked chart For instance the Conditional Formatting can help you to color positive values green and negative values red If you have enabled Use Excel fill and the cell correspond ing to a data segment does not have a fill color set as part of Excel s cell formatting then the appropriate color from the current co
180. um ber format on page 35 The arrow itself supports the color property Color and fill on page 19 57 15 46 50 32 33 2013 2014 2015 2016 By default only one CAGR is inserted that stretches from the selected category to the last category in the chart You can use the handles that show up when the CAGR arrow is selected to specify its start and end categories g You can also determine the desired start and end cat egories for the CAGR immediately Select a segment in the start category and a segment in the end category Then right click on one of them and click Add Com pound Growth Arrow lf you select segments in more than two categories you will get a CAGR for each pair of successive selected categories To select multiple seg ments at a time hold down key while selecting see Multi selection on page 18 In case of a line or area chart select the corresponding data points instead of segments mE 63 00 46 50 32133 2013 2014 2015 2016 Series CAGR The CAGR arrow is always calculated based on the col umn totals However you might also like to visualize the compound annual growth rate of one of the series This can be shown in series labels Sim ply select the label and choose the CAGR option from the right most menu on the floating toolbar Now the CAGR is calculated series wise Chart decorations 52 Series 8 Series 19 Series 65 2013 2014 2015 To select all series labels i
181. up ing You can add arbitrary prefixes and suffixes with or without spacing 1 2M Js f you want all numbers to be signed select a positive number and enter a leading or trailing plus 1 234 Type USD 1 234 to place the algebraic sign in front of the currency type EUR 1 234 to place it in front of the value With a negative number selected remove the mi nus sign and enclose everything including prefix and suffix in brackets e g 1 2M to display bracketed negative values If only a prefix or suffix is enclosed then the brackets are taken as literal characters e g 1 234 metric tons Type 1 234 with a leading en dash to replace all minuses with en dashes think cell can also use a number format that has been set in Excel To use this first choose the desired num ber 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 mil lions see Magnitude on this page Then enter the ap propriate 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 re
182. viation from the original values is not supported Thus for certain combinations of input values no consistently rounded solution can be found In this case the function TCROUND evaluates to the Excel error value NUM The following example illus trates an unsolvable problem A B C 1 ZTCROUND 1 3 0 TCROUND 1 4 0 TCROUND 6 A1 B1 0 The precise calculation for cell C1 is 6x1 3 1 4 9 2 Rounding cells Al and B1 would result in 6x 1 2 8 or 6x2 1 13 The actual result 9 2 cannot be rounded to 8 or 13 and the output from think cell round looks like this A B C 1 NUM 1 9 Note The Excel function AVERAGE is interpreted by think cell round as a combination of summation and constant multiplication Also a summation where the Excel data rounding 105 same addend appears more than once is mathemat ically equivalent to a constant multiplication and the existence of a solution is not guaranteed General multiplication and other functions As long as the TCROUND functions are used for all rele vant cells and intermediate results are connected merely by SUM and AVERAGE the addends as well as in termediate totals are integrated into a single rounding problem In these cases think cell round will find a so lution that provides consistency throughout all cells in volved if such a solution exists Since TCROUND is a normal Excel function it can be combined with arbitrary functions and operators But when you use fun
183. w section tor your own col ors To do this insert a separator tag by writing lt separator gt at the appropriate location in the color list Also feel free to use line breaks indentation and empty lines to structure the XML code in the style file for your own convenience Spaces and linebreaks have no effect on the resulting style 5 Add your own colors using the solidFill element Your color needs a name and values for the red green and blue channels You should have these val ues from the specification document for your com pany s corporate identity If the color s name should be Light Green the decimal value for the red chan nel 170 for green 255 and for blue 42 then it should look like this lt solidFill name Light Green gt sdrgbClr r 170 g 255 b 42 gt lt solidFill gt 6 Remove any unneeded color schemes trom the list inside the fillSchemeLst element You will find fillScheme elements corresponding to the items in the color scheme list displayed in think cell see Color scheme on page 20 To remove a fillScheme element remove everything between and including Customizing think cell 125 the opening tag fillScheme gt and the closing tag lt fillScheme gt 7 Optionally modify an existing color scheme You can remove one or multiple colors from the scheme by removing the respective fillRef elements or reorder the existing colors by reordering fillRef elements or inc
184. weekends are not shown in the chart Enable or disable Weekend Shades This option is only available if Workweek Only is disabled Week Starts lets you set the day that the think cell calendar will use as the star of week Weekend Here you can choose the days that match the weekend in your country Fit Scale to Data The charts date range is adjusted such that all bars milestones and brackets become visible Each scale supports various ways to display date intor mation e g the months scale may show month names like September or numbers like 09 You probably want to choose the appropriate format depending on the available space To do so select the scale with the mouse and use the floating toolbar that appears to select the desired format Since the R MMM J dropdown menu is actually a date for a me mat control see Date format control on MMMMM O0 page 5 you can also type in arbitrary date format strings Note As with other labels you can add arbitrary text to the scale labels such as footnote markers or short comments g Scale labels and separator lines Each scale supports an optional label and optional sep arator lines To use these features open the context menu for the desired scale with a right click Activity Implementation and system test Setup of pilots m Pilot install Note Primary and secondary separator lines are auto
185. width and height Hold down the lett mouse button and drag the mouse to create a custom sized element Some elements have a fixed width for insertion in this case you can only alter the height You can always change the size of the element later hen you are inserting or resizing an element you will notice that it snaps to certain locations Basic concepts 17 Company A Company A The snapping behavior serves the following purposes With snapping objects can be quickly and easily aligned The highlighting of a border of some other object on the slide indicates that the element you are moving is currently aligned with that object When resized some elements snap to an automat ically determined and predetined preterred size In the case of a column chart tor example its preterred width depends on the number of columns It you have manually changed the size of an element you can easily change it back to the detault width It will snap when you come close enough to the default while ad justing the width with the mouse As in PowerPoint you can hold down the Ali key to move the mouse freely without snapping js Rotating and flipping elements The small arrow markers around the pentagon chevron and the stacked clustered 10096 line area waterfall and Mekko chart symbols in the Elements menu let you insert flipped and if applicable rotated versions of these elements Most elements can also
186. width is preserved by holding down the Cir key while dragging the column widths will be increased or decreased to accommodate the altered gaps Note In some cases a break in the baseline see Cat egory axis break on the current page may be a space saving alternative to a category gap Category axis break In menu Category axis column gap Menu item A category axis break indicates a break in the continuity of the category axis scale To insert the break right click on the category axis between two columns and select the respective menu item 38 m 2013 2014 2018 g Arrows and values Difference arrows In menu Chart segment point Menu items E ij ye LI Difference arrows can be used in charts to visualize the difference between pairs of columns segments or points The difference is automatically calculated and updated whenever the underlying data changes The text label for the difference chapter Text labels on page 32 supports font number format and label content prop erties Font on page 35 Number format on page 35 Label content on page 36 Two distinct styles of difference arrows are supported by think cell segment or point difference arrows and cat egory difference arrows Segment difference arrows are designed to show differences between pairs of segments or points in a chart category difference arrows are de signed to show differences between column totals Segment differenc
187. with an e mail template Online quality assurance At think cell we are committed to stability and robust ness as key factors for the professional use of our soft ware When an error condition arises while you are us ing think cell the software automatically generates a re port that helps us to understand the problem and fix it in the next release The error report only contains infor mation about the internal state of our software No user data is included in the error report The software sends the error report encrypted You might notice a short delay while an error report is being sent but in most cases you can continue using think cell as usual For more information on think cell s automated error reporting refer to section Online quality assurance on page 116 Temporarily disabling think cell To quickly work around compatibility problems or other issues arising from the use of think cell you have the op tion to temporarily disable think cell without uninstalling the software Installation and update 14 ep More y JS Data Links t e Insert Symbol ai Save Selected Slides fa Send Selected Slides if Load Style File User Guide Knowledge Base Request Support About ig X e License Key gj Deactivate think cell N In the More menu in the think cell toolbar in PowerPoint there is an option called Deactivate think cell When you select this option think cell will b
188. y also use the setup exe as fol lows setup exe ALLUSERS 1 The other parameters work the same as for the setup msi Automatic privilege elevation by Windows User Access Control UAC setup exe qb Omit the ALLUSERS parameter You will get a per machine installation if the user account can elevate to administration permissions otherwise the installer falls back to per user The other parameters are optional With Windows Vista and 7 qn may be used to completely suppress the installer s user interface qb displays a progress bar and qb removes its Cancel button With Windows 8 and later versions only qb is recommended as qn may silently abort the installation or unexpectedly install per user Deployment guide 110 even though the account may elevate permissions This is due to Microsoft s changes to UAC in Windows 8 and depends on the account s specific UAC settings For the default destination directory of per machine installation see above For per user installation the default is ALOCALAPPDATA Nthink cell It is recommended not to set a different path with the TARGETDIR parameter but if you do make sure it has the appropriate permissions and ownership for the respective context Force per user setup exe qn ALLUSERS ALLUSERS forces a per user installation even if the user account may elevate permissions by UAC Execute the installer for each user account
189. you would type Very long amp text into the datasheet cell Note Alj lt can be used to add line breaks to text in the datasheet while F7 can be used to spell check datasheet text Text labels 36 Text label property controls Font 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 Number format The number format control applies to text 1534 gt 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 com mon formats Also up to four of your most recently used custom formats are available in the dropdown box Ab solute 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 char acter for the grouping of thousands and the decimal point For example Type 1 000 00 to display numbers with a comma for the decimal point with two decimal places and thou sands separated by points Type 1000 to display integer numbers with no gro
190. zation you can use this textbox to show the case code on each slide The content of the textbox is updated whenever the file is saved under a different name To add a textbox that shows the case code follow these steps Presentation tools 88 1 Switch to the master slide view menu View Master gt Slide Master 2 Insert a new textbox and place it on the master slide You may need to insert dummy text to keep it from be ing removed immediately again The dummy text will be replaced by the case code when the file is saved 3 In PowerPoint 2007 and later a Right click the textbox and open the Size and Po sition dialog b Go to the Alt Text tab and find the input area for Alternative text or in PowerPoint 2010 2013 and 2016 for the Description In earlier PowerPoint versions a Open the Format Text Box dialog double click the textbox or select Format Text Box from the con text menu b Go to the Web tab and find the input area for Alternative text 4 In the input area type in the following casecode to have the filename automatically dis played in the textbox CASECODE to have the capitalized filename automat ically displayed in the textbox casepath to have the full file path automatically dis played in the textbox CASEPATH to have the capitalized full file path auto matically displayed in the textbox As soon as you save the file the case code shows up on the slides

Download Pdf Manuals

Related Search

Related Contents

Axis P3904-R  Manuale di Installazione Manuale di Installazione IT    Manual de Usuario  取扱説明書 - ソニー製品情報  Manuel Stealth GPS-3_fr  Medusa 5.1 USB Headset  Canon PowerShot SX280 HS  V7 SA0501B-8E4 surge protector  User Manual  

Copyright © All rights reserved. Failed to retrieve file