1、think-cellQSoftware GmbHthe smarter way to presentationsthink-cel l 5.1User GuideImprintt hink-cel l Soft ware GmbH Inval i denst raBe 34 1 01 1 5 Berl i nGermanyUS Office support t hink-cel 845 Third Avenue,6t h Fl oor ht t p:/www.t hink-cel New York,NY 1 0022Unit ed St at es of Americafel.:+49 30
2、666473 1 0Fax:+49 30 666473 1 9Tbl.:+1 800 891 8091(t ol l-free)Fax:+1 21 2 504 3039April 1,2009Thi s work i s subject t o copyright.Al l ri ght s are reserved,whet her t he whol e or part of t he mat erial i s concerned,specifical l y t he ri ght s of t ransl at ion,reprint ing,reuse of il l ust ra
3、t ions,recit at ion,broadcast ing,reproduct ion on microfil m or i n ot her ways,and st orage on dat a banks.Dupl icat ion of t hi s publ icat ion or part s t hereof i s permit t ed onl y under t he provisions of German Copyright Law of Sept ember 9,1 965,i n i t s current version,and permissi on fo
4、r use must al ways be obt ained from t hink-cel l Soft ware GmbH.Viol at ions are l iabl e for prosecut ion act under German Copyright Law.2002-2009 t hink-cel l Soft ware GmbHt hink-cel l i s a regist ered t rademark.The use of general descript ive names,regist ered names,t rademarks,et c.i n t hi
5、s publ icat ion does not i mpl y,even i n t he absence of a specific st at ement,t hat such names are exempt from t he rel evant prot ect ive l aws and regul at ions and t herefore free for general use.ContentsImprint.31.Product overview.82.Installation and update.9Syst em requirement s.9Fi rst inst
6、 al l at ion.9Aut omat ic updat e.1 1Troubl e shoot ing.1 1Onl ine qual it y assurance.1 2Temporaril y disabl ing t hink-cel l.1 23.Introduction to think-cell.13Insert i ng a new chart.1 3Adding and removing l abel s.1 5Ent ering chart dat a.1 6St yl i ng t he chart.1 64.Basic concepts.19Tool bar an
7、d Chart s menu.1 9Contents 4Rot at i ng and fl ipping chart s.20Resi zi ng smart-el ement s.20Sel ect ing chart s and feat ures.21Format t ing and st yl e.235.Data entry.26Int ernal dat a sheet.26Absol ut e and rel at ive val ues.26Transposi ng t he dat a sheet.27Reverse order i n dat a sheet.286.Te
8、xt labels.29Types of l abel s.29Aut omat ic l abel pl acement.30Manual l abel pl acement.30Text fiel ds.31Text l abel propert y cont rol s.32Past i ng t ext int o mul t ipl e l abel s.337.Column,line and area charts.35Col umn and st acked col umn chart.35Cl ust ered chart.35100%chart.36Li ne chart.3
9、6Area chart.38Combinat ion chart.38Scal es and axes.39Contents 5Arrows and val ues.44Legend.488.Waterfall chart.499.Marimekko chart.52Marimekko chart wi t h%-axis.52Marimekko chart wi t h unit s.53Ridge.5310.Pie chart.5411.Scatter and bubble charts.55Label s.55Scat t er chart.56Bubbl e chart.57Trend
10、l i ne and part什ion.5712.Project timeline(Gantt chart).59Cal endar scal e.59Rows(Act iv什ies).62Timel ine 什ems.65Dat e format cont rol.68Language dependency.69Dat e format codes.6913.Excel data links.70Creat ing a chart from Excel.70Contents 6Transposi ng l inked dat a.71Updat ing a l inked chart.71D
11、at a Li nks dial og.72Maint aining dat a l inks.73How t o compil e t he dat a.75Frequent l y asked quest ions.7614.More tools.80Special charact ers.80Save and send sel ect ed sl ides.80Changing t he l anguage.80Changing font s.81Aut omat ic case code.81t hink-cel l round.82Appendix.87A.Deployment gu
12、ide.88Workst at ion prerequis什es.88Init ial inst al l at ion.88Updat es.93St art ing PowerPoi nt wit h t hink-cel l enabl ed or disabl ed.94Onl ine qual it y assurance.94B.Exchanging files with PowerPoint.97Loading fi l es from t hink-cel l i n PowerPoint.97Reimport ing smart-el ement s from PowerPo
13、int.97Contents 7C.Programming think-cell.99PresentationFromlemplate.99D.Keyboard shortcuts.101Index.1021.Product overviewWel come t o t hink-cel l 5.1 1 Thi s soft ware i s an add-in for Microsoft PowerPoi nt t hat i s specifical l y designed t o make t he creat ion of busi ness chart s as fast as s
14、cribbl ing on paper.Chart s creat ed w什h t hink-cel l int el l igent l y arrange t hemsel ves t o l ook just right.Al l t he chart decorat ions-connect ors,arrows,and al ike-are just a mouse cl ick away and are aut omat ical l y pl aced preci sel y where t hey bel ong.The l ook of al l drawings i s
15、opt imized t o fulfil l t he requirement s of a cl ean and professional sl ide desi gn.2.Instal l ation and updateThi s chapt er guides you t hrough t he inst al l at ion of your personal copy of t hink-cel l.If you are about t o prepare t he depl oyment of t hink-cel l i n a l arger organizat ion,y
16、ou shoul d ski p t hi s chapt er and read t he Depl oyment guide7 on page 88.System requirementsl b i nst al l and run t hink-cel l,t he fol l owing soft ware must be inst al l ed:-Microsoft Windows 2000,XP or Vi st a-Microsoft Office 2000,XR 2003 or 2007 w什h at l east PowerPoi nt and Excel inst al
17、l edThe inst al l at ion of t hink-cel l requires about 20 MB of di sk space.First installationInstalling think-cellPl ease cl ose al l i nst ances of Microsoft PowerPoi nt and Microsoft Excel before inst al l ing t hink-cel l.The inst al l at ion can be st art ed direct l y from t he onl ine source
18、.When you downl oad t he set up fil e you may-choose Open i n order t o i nst al l t he soft ware direct l y from t he i nt ernet.-or choose Save t o Di sk and st art t he inst al l at ion by doubl e-cl icking t he downl oaded set up fil e.The inst al l at ion wizard asks for t he inst al l at ion p
19、at h,t hen copies t he required fil es and updat es t he regi st ry.The defaul t inst al l at ion pat h i s:C:Program Fil esth ink-cel lIf t he inst al l at ion wizard det ect s t hat you do not have sufficient privil eges for a regul ar inst al l at ion,a singl e-user inst al l at ion wil l be perf
20、ormed.Thi s means t hat t hink-cel l can onl y be used wi t h your current Windows l ogin name.The defaul t inst al l at ion pat h fora singl e-user inst al l at ion i s:C:Documents and Settingsuser Local SettingsAppl ication Datath ink-cel lor,for Windows Vi st a:C:UsersuserAppDataLocal th ink-cel
21、lInstal l ation and update 10Missing system componentsWhen you st art PowerPoi nt for t he first t ime aft er inst al l ing t hink-cel l,t he soft ware checks for t he avail abil什y of al l required syst em component s.On most comput ers,t he required component s are al ready inst al l ed.If t hink-c
22、el l det ect s t hat a required syst em component i s mi ssing,a dial og box opens wit h eit her a l ink t o Microsoft s downl oad web page for t he respect ive component or an expl anat ion how t o i nst al l t he mi ssi ng component using Microsoft Office Set up.bu need t o rest art PowerPoi nt fo
23、r t he inst al l at ion t o t ake effect.Component s required by t hink-cel l are:-Visual Basic for Applications component.In Microsoft Office Set up,choose Add or Remove Features and sel ect i t under Office Shared Features.-Microsoft Graph.In Microsoft Office Set up,choose Add or Remove Features,t
24、hen under。仟ice Tools,select Graph.-Microsoft XML Parser(MSXML)3.0.Thi s i s incl uded i n WindowsXP or l at er and i n Int ernet Expl orer 6.0 or l at er.-Microsoft Background Intelligent Transfer Service(BITS)Client Component.Thi s i s incl uded i n Windows 2000 Servi ce Pack 3 or l at er.Macro sec
25、urity warningsThe t hink-cel l add-in requires t he fil e tcaddin.dll t o be l oaded by PowerPoi nt and Excel.Depending on t he se-curit y set t i ngs of your comput er,you may be prompt ed w什h t he fol l owing securit y warning when st art ing one of t hese product s aft er inst al l ing t hink-cel
26、 l.Security Wa rningIC:VSSV3EVOutputTCLayoutdll contains macros by think-cel Software GmbH区IDetafc.Macros may contain viruses.It is always safe to disable macros,but if the macros are legitimate,you might lose some functionality.歹 到ways trust macros from this source.Disable Macrosfa ble Macros 凡More
27、 InfoYou can examine t he fil es cert ificat e by cl icking on Det ai l s.Make sure t he cert ificat e bel ongs t o think-cell Software GmbH,Berlin,Germany.We recommend t hat you check t he box Al ways t rust macros from t hi s source and t hen cl ick Enabl e Macros.-If you do not check Al ways t ru
28、st macros from t hi s source,t he securi t y dial og wil l cont inue t o show up whenever you st art PowerPoi nt or Excel.-If t he securit y on your comput er i s set t o Hi gh,you must check t he box before you can cl ick Enabl e Macros.-If you choose Di sabl e Macros,you wil l not be abl e t o use
29、 t hink-cel l,l b enabl e macros,cl ose PowerPoi nt or Excel and open 什 again;you wil l t hen again be prompt ed wi t h t he securit y dial og.Entering the license keyThe publ ic version of t hink-cel l requires a val id l i cense key,which expires aft er a fi xed period of t ime.When you st art Pow
30、erPoi nt wi t h a t hink-cel l t rial version for t he fi rst t ime,or when your l icense key has expired,you need t o ent er a val id l icense key.Instal l ation and update 11think-cell license key 1think-cellPtease enter a valid license key to activate your thinkdl product.XXXXX-XXXXX-XXXXX-XXXXX-
31、XXXXX(not valid)|Caned|F:I help to improve the software by dlowng automatic error reports.Cal+49-30-666473-10(US:+1-800-891-8091),email to or visit http:/www.think Sl i de Desi gn.2.In t he t ask pane,cl ick on t he header of t he t ask pane and swit ch t o Sl i de Desi gn-Col or Schemes.3.On t he b
32、ot t om of t he t ask pane,cl ick onEdi t Col or Schemes.4.Adjust t he col ors t o mat ch your corporat e desi gn.In PowerPoi nt 20071.In t he ribbon,go t o Desi gn.2.In t he group Themes,cl ick on Col ors.3.From t he drop-down l i st choose Creat e New ThemeCol ors.4.Adjust t he col ors t o mat ch
33、your corporat e desi gn.7b adjust t he defaul t font se什i ngs,si mpl y change your present at ions sl i de mast er:In PowerPoi nt 20031.In t he t ool bar;go t o Vi ew 一 Mast er t hen Sl i de Mast er.2.Adjust t he font s of t he mast er t ext st yl es t o mat ch your corporat e design.In PowerPoi nt
34、20071.In t he ribbon,go t o Vi ew.2.In t he group Present at i on Vi ews,cl ick on Sl i de Mast er.3.Adjust t he font s of t he mast er subt it l e st yl e t o mat ch your corporat e design.In general,i t i s advisabl e t o st ore t hese defaul t s i n a PowerPoi nt t empl at e fil e(*.pot)and t o d
35、erive al l new present at ions from t hi s t empl at e fil e.Pl ease refer t o t he PowerPoi nt hel p for informat ion how t o do t hi s.5.Data entryInternal data sheetEvery chart creat ed wi t h t hink-cel l has an associ at ed dat a sheet,except for t he Gant t Chart,t hat offers a cal ender i nst
36、 ead.The dat a sheet i s opened by doubl ecl icking t he chart or by cl icking t he but t on t hat appears when t he chart i s sel ect ed.The dat a sheet al so opens immediat el y when a new chart i s i nsert ed.t hink-cel l uses a cust omi zed Microsoft Excel sheet for dat a input,which you can use
37、 i n t he same way as regul ar Excel.You can use al l t he same short cut keys,you can ent er formul as i nst ead of numbers,and so fort h.But of course you can al so use an Excel fil e as a dat a source(see Excel dat a l inks on page 70).l b i nsert or del et e a row(or col umn)you can use t he res
38、pect ive but t ons i n t he t ool bar of t he dat a sheet.The st andard but t ons for undo and redo and cut,copy and past e are avail abl e as wel l.Absolute and relative valuesThe t hink-cel l dat a sheet al t ernat ivel y support s ent ry of absol ut e or rel at ive val ues.The dist inct ion bet w
39、een t he t wo t ypes of dat a i s made by t he Excel cel l forma什i ng.You can al ways t oggl e t he int erpret at ion of a col umns dat a wit h t he%but t on.Keep i n mind t hat for t he displ ay i n t he chart,it does not mat t er if you ent er percent ages or absol ut e val ues.If you ent er absol
40、 ut e val ues but want t o l abel t he chart w什h percent ages(or vi ce versa),t hink-cel l performs t he necessary conversion(see yLabel cont ent on page 33).A simpl e dat a sheet wi t h onl y absol ut e val ues l ooks l i ke t hi s:For simpl e chart s based on absol ut e val ues onl y,t he 1 00%row
41、 on t op of t he chart dat a can be l eft empt y.If you choose t o l abel t he chart wi t h percent ages,t he percent ages are cal cul at ed from t he absol ut e val ues,Data entry 27assumi ng t he sum of each col umn t o be 1 00%.You can ent er expl icit val ues i n t he 1 00%row t o override t hi
42、s assumpt ion.The fol l owing dat a sheet cal cul at es percent ages based on 100%being equal t o a val ue of 50:Al t ernat ivel y,you can fil l i n t he dat a sheet w什h percentages.Again,you can choose t o l abel t he chart wi t h absol ut e or rel at ive val ues.In order t o have t hink-cel l cal
43、cul at e absol ut e val ues from t he percent ages you ent ered,you shoul d fil l i n t he absol ut e val ues t hat represent 100%i n t he 100%row.The fol l owing dat a sheet uses percent ages t o speci fy t he same dat a val ues:w什h%-axi s as wel l as pie chart s defaul t t o percent ages,al l ot h
44、er chart s defaul t t o absol ut e val ues.Transposing the data sheetThe l ayout of a t hink-cel l dat a sheet depends on t he chart t ype.In bar chart s,for exampl e,col umns cont ain t he dat a for a singl e seri es,whil e i n col umn chart s,rows cont ain t he dat a fora singl e seri es.Here i s
45、a t ypical dat a sheet for a col umn chart:In Excel 2000-2003,t he si ze of a t hink-cel l dat a sheet,and Excel dat a sheet s i n general,i s l imit ed t o a maximum of 256 col umns and 65536 rows support ed.If t he dat a for your chart requires more t han 256 col umns,you can use t he Transpose Sh
46、eet but t on t o t ranspose t he dat a sheet,swapping t he row and col umn dat a t oget her wit h any cat egory/series int erpret at ion.Here i s t he t ransposed versi on of t he previous col umn chart dat a sheet:The defaul t behavior of t he dat a sheet depends on t he chart t ype:100%-chart s an
47、d area or marimekko chart sData entry 28Transposi ng t he dat a sheet l et s you creat e chart s where t he dat a sheet woul d normal l y require more t han 256 col umns,and can oft en be used t o simpl ify dat a ent ry when working wit h a l arge amount of dat a.Reverse order in data sheetIn t hink
48、-cel l,t he vi sual order of dat a i n t he dat a sheet al ways corresponds t o t he order of t he dat a i n t he chart.Thi s i s al so t rue for fl ipped chart s(see Rot at ing and fl ipping chart s7 on page 20).If you want t o fl ip t he dat a i n t he dat a sheet,you can use t he 专 Fl i p Rows(or
49、 力 Fl i p Col umns)but t on i n t he dat a sheet s t ool bar.Note:Thi s feat ure i s part icul arl y convenient t o convert dat a from former MS Graph chart s,because i n MS Graph dat a i s ent ered i n headfirst order.Note:If you have Microsoft s Chinese Conversion feat ure inst al l ed,you wil l f
50、ind t he opt ions Si mpl i fi ed Chi nese and Tradi t i onal Chi nese i n t he dat a sheet s More menu.6.Text l abel st hink-cel l t akes care of correct and readabl e l abel ing.Avoid using PowerPoi nt t ext boxes t o l abel your chart s as t hey wil l be ignored by t hink-cel lzs aut omat ic l abe