高盛内部Office插件ThinkCell使用手册.pdf

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.：[phone]Fax：[phone]Tbl.：[phone](t ol l-free)Fax：[phone]April 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 rat 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 for 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 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 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 and 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.Text 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.36Area 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.57Trendl 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.71Dat 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 guide.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 PowerPoint.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 scribbl 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 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,you 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 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 sourceWhen 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 pat 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 performed.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 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-cel 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 for 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,then 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 security 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 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 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 rust 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 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 PowerPoi 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-XXXXX(not valid)|Caned|F：I help to improve the software by dlowng automatic error reports.Cal+49-30-666473-10(US:[phone]),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 bot 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 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 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 derive 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 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 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 respect 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 ween 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 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 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 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 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 her 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 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 Sheet 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 and 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 hinkcel 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 力 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 find 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