Tse ka Hare
Wizard e Ncha ea Chate
Mokhoa oa ho etsa lichate bakeng sa mefuta e fapaneng ea lisele e se e nolofalitsoe haholo ka lebaka la lebokose le lecha la puisano le nang le ponelo-pele ea chate e phethiloeng (likhetho tse peli ka nako e le 'ngoe - ka mela le ka mela):
Lichate tse kopantsoeng moo mefuta e 'meli kapa e meraro e kopantsoeng (histogram-plot-le libaka, joalo-joalo) joale li behiloe sebakeng se arohaneng 'me li lokisoa hantle hang-hang fensetereng ea Wizard:
Hape hona joale fensetereng ea ho kenya chate ho na le tab Lichate tse khothalelitsoeng (Lichate tse khothalelitsoeng), moo Excel e tla fana ka tlhahiso ea mefuta e loketseng ea lichate ho latela mofuta oa data ea hau ea pele:
E fana ka maikutlo, ke tlameha ho bua, ka bokhoni bo boholo. Maemong a thata, o bile a fana ka maikutlo a ho sebelisa axis ea bobeli ka tekanyo ea eona (li-ruble-peresente), joalo-joalo.
Ho iketsetsa lichate
Ho lokisa kapele litlhophiso tsohle tsa chate efe kapa efe, joale u ka sebelisa likonopo tse tharo tsa bohlokoa tse hlahang ka letsohong le letona la chate e khethiloeng:
- Lintlha tsa chate (Lintlha tsa Chate) - e o lumella ho eketsa le ho etsa ntho e ngoe le e ngoe ea chate kapele (mabitso, lilepe, grid, mangolo a data, jj.)
- Mekhoa ea lichate (Mefuta ea Chate) - e lumella mosebelisi ho khetha kapele moralo le pente ea mebala ea setšoantšo ho tsoa pokellong
- Lisefe tsa Chate (Lisefe tsa Chate) - e u lumella ho sefa data bakeng sa chate ka fofa, u siea feela letoto le likarolo tse hlokahalang ho eona
Ntho e ngoe le e ngoe e hlahisoa ka mokhoa o bonolo ka mokhoa oa limmapa tsa maemo a fapaneng tsa maemo a fapaneng, e ts'ehetsa ponelo-pele ea ho fofa mme e sebetsa kapele le ha bonolo:
Haeba, leha ho le joalo, sebopeho sena se secha se sa rateheng, joale u ka ea ka tsela ea khale - lits'ebetso tsohle tsa mantlha tsa ho hlophisa ponahalo ea chate le tsona li ka etsoa ka li-tab. Constructor (Moralo) и Mookameli (Mofuta). 'Me mona ke li-tab moralo (Mohaho), moo likhetho tse ngata tsa lichate li neng li hlophisoa ho Excel 2007/2010, ha li sa le eo.
Karolo ea mesebetsi ho e-na le mabokose a puisano
Ho lokisa hantle sebopeho sa elemente ka 'ngoe ea chate hona joale ho se ho etsoa ka mokhoa o bonolo haholo ho sebelisoa phanele e khethehileng ka lehlakoreng le letona la fensetere ea Excel 2013 - sebaka sa mosebetsi se nkang sebaka sa mabokose a puisano a fomete. Ho hlahisa phanele ena, tobetsa ka ho le letona ho karolo efe kapa efe ea chate ebe u khetha taelo Mookameli (Mofuta) kapa tobetsa konopo ea keyboard CTRL + 1 kapa tobetsa habeli ka letsohong le letšehali:
Lileibole tsa data tsa Callout
Ha o kenya lileibole tsa data ho likarolo tse khethiloeng tsa letoto la lichate, joale hoa khonahala ho li hlophisa ka li-callouts tse hlahisoeng hantle ho lintlha:
Pele, li-callouts tse joalo li ne li lokela ho huloa ka letsoho (ke hore, li kenngoe feela e le lintho tse fapaneng tsa litšoantšo) 'me, ha e le hantle, ho ne ho se na potso ea ho tlama ha data.
Lileibole tsa lintlha tse tsoang liseleng
Ha ke kholoe mahlo a ka! Qetellong, toro ea basebelisi ba bangata e phethahetse, 'me bahlahisi ba sebelisitse seo ba neng ba lebeletsoe ho sona ka lilemo tse ka bang 10 - joale u ka nka li-label tsa data bakeng sa likarolo tsa letoto la lichate ka ho toba ho tloha lakane ka ho khetha khetho ho karolo ea mosebetsi Litekanyetso tse tsoang liseleng (Maemo a Tsoang Liseleng) le ho hlakisa mefuta e mengata ea lisele tse nang le matšoao:
Li-labels tsa bubble le li-scatter charts, mangolo afe kapa afe a sa tloaelehang ha e sa le bothata! Seo se neng se ka khoneha ka letsoho feela (leka ho kenya lileibole ho lintlha tse mashome a mahlano ka letsoho!)
Chate Animation
Karolo ena e ncha ea charting ho Excel 2013, leha e se eona e kholo, e ntse e tla eketsa mojo litlalehong tsa hau. Joale, ha u fetola lintlha tsa mohloli (ka letsoho kapa ka ho bala liforomo hape), setšoantšo se tla "phalla" hantle ho ea sebakeng se secha, se bonts'a liphetoho tse etsahetseng ka pono:
E nyane, empa e ntle.
- Ke eng e ncha ho Excel 2013 PivotTables