Contents
Ua ʻike mua ʻia nā Sparklines ma Excel 2010 a ke ulu nei i ka kaulana mai ia manawa mai. ʻOiai ua like loa nā sparklines me nā kiʻi liʻiliʻi liʻiliʻi, ʻaʻole like lākou a ʻokoʻa iki nā kumu. Ma kēia kumu aʻo, e hoʻolauna mākou iā ʻoe i nā sparklines a hōʻike iā ʻoe pehea e hoʻohana ai iā lākou i kahi puke hana Excel.
Aia kekahi mau manawa e pono ai ʻoe e nānā a ʻimi i kahi hilinaʻi i kahi waihona Excel me ka ʻole o ka hana ʻana i kahi pakuhi piha. ʻO nā Sparklines nā kiʻi liʻiliʻi i kūpono i loko o kahi kelepona hoʻokahi. Ma muli o ko lākou compactness, hiki iā ʻoe ke hoʻokomo i kekahi mau sparklines i ka manawa hoʻokahi i loko o kahi puke hana.
I kekahi mau kumu, kapa ʻia nā sparklines laina ʻike.
ʻO ke ʻano o nā sparklines
ʻEkolu ʻano o nā sparklines ma Excel: Sparkline Graph, Sparkline Histogram, a me Sparkline Win/Loss. Hana like ka Sparkline Plot a me Sparkline Histogram e like me nā ʻāpana maʻamau a me nā histograms. Ua like ka win/loss sparkline me ka histogram maʻamau, akā ʻaʻole ia e hōʻike i ka nui o ka waiwai, akā inā he maikaʻi a maikaʻi ʻole paha. Hiki i nā ʻano sparkline ʻekolu ke hōʻike i nā māka ma nā wahi koʻikoʻi, e like me nā kiʻekiʻe a me nā haʻahaʻa, e maʻalahi loa ka heluhelu ʻana.
He aha nā sparkline e hoʻohana ai?
He nui nā pono o nā Sparklines ma Excel ma mua o nā pakuhi maʻamau. E noʻonoʻo ʻoe he papa ʻaina me nā lālani 1000. E hoʻolālā ka pakuhi maʻamau i nā moʻo ʻikepili 1000, ʻo ia hoʻi hoʻokahi lālani no kēlā me kēia laina. Manaʻo wau ʻaʻole paʻakikī ke kuhi he paʻakikī ke loaʻa i kekahi mea ma ia kiʻi. ʻOi aku ka maikaʻi o ka hana ʻana i kahi sparkline ʻokoʻa no kēlā me kēia lālani ma kahi papa Excel, aia ma ka ʻaoʻao o ka ʻikepili kumu, hiki iā ʻoe ke ʻike maka i ka pilina a me ke ʻano o kēlā me kēia lālani.
Ma ke kiʻi ma lalo nei, hiki iā ʻoe ke ʻike i kahi pakuhi paʻakikī a paʻakikī ke ʻike i kekahi mea. ʻO Sparklines, ma ka ʻaoʻao ʻē aʻe, e ʻae iā ʻoe e nānā pono i nā kūʻai aku o kēlā me kēia mea kūʻai aku.
Eia kekahi, pono nā sparklines inā makemake ʻoe i kahi ʻike maʻalahi o ka ʻikepili a ʻaʻohe pono e hoʻohana i nā pakuhi nui me nā waiwai a me nā mea hana. Inā makemake ʻoe, hiki iā ʻoe ke hoʻohana i nā kiʻi maʻamau a me nā sparklines no ka ʻikepili like.
Ka hana ʻana i nā Sparklines ma Excel
Ma ke ʻano maʻamau, kūkulu ʻia hoʻokahi sparkline no kēlā me kēia moʻo data, akā inā makemake ʻoe, hiki iā ʻoe ke hana i kekahi helu o nā sparklines a kau iā lākou i kahi e pono ai. ʻO ke ala maʻalahi loa e hana ai i ka sparkline mua aia ma ka lālani kiʻekiʻe loa o ka ʻikepili, a laila e hoʻohana i ka marker fill auto e kope iā ia i nā lālani a pau i koe. Ma ka laʻana aʻe, e hana mākou i kahi pakuhi sparkline e ʻike i ka hoʻoikaika kūʻai ʻana no kēlā me kēia mea kūʻai aku ma kahi manawa kikoʻī.
- E koho i nā pūnaewele e lilo i mea hoʻokomo no ka sparkline mua. E koho mākou i ka laulā B2:G2.
- Kaomi i ka pā hookomo a koho i ke ʻano o ka sparkline i makemake ʻia. Eia kekahi laʻana, kahi pakuhi sparkline.
- E hōʻike ʻia kahi pahu kamaʻilio Ke hana ʻana i nā Sparklines. Me ka ʻiole, koho i ke kelepona e kau ai i ka sparkline, a laila kaomi OK. I kā mākou hihia, e koho mākou i ka cell H2, e ʻike ʻia ka loulou i ke kelepona ma ke kahua Laulā wahi.
- E ʻike ʻia ka sparkline ma ke kelepona i koho ʻia.
- Kaomi a paʻa i ka pihi ʻiole hema a kauo i ka lima hoʻopiha piha e kope i ka sparkline i nā cell pili.
- E ʻike ʻia nā Sparklines ma nā lālani a pau o ka pākaukau. Hōʻike kēia kiʻi i ke ʻano o ka ʻike ʻana o nā sparklines i nā ʻano kūʻai aku no kēlā me kēia mea kūʻai aku ma kahi o ʻeono mahina.
Hoʻololi i ke ʻano o nā sparklines
He mea maʻalahi ka hoʻoponopono ʻana i ke ʻano o kahi sparkline. Hāʻawi ʻo Excel i kahi ʻano mea hana no kēia kumu. Hiki iā ʻoe ke hoʻonohonoho i ka hōʻike o nā māka, hoʻonohonoho i ke kala, hoʻololi i ke ʻano a me ke ʻano o ka sparkline, a ʻoi aku ka nui.
Hōʻike hōʻailona
Hiki iā ʻoe ke nānā aku i kekahi mau wahi o ka pakuhi sparkline me ka hoʻohana ʻana i nā māka a i ʻole nā kiko, a laila e hoʻonui ai i kona ʻike. Eia kekahi laʻana, ma kahi sparkline me nā waiwai nui a me nā mea liʻiliʻi, he mea paʻakikī ke hoʻomaopopo i ka mea iʻoi aku ka nui aʻo ka mea liʻiliʻi loa. Me nā koho i hiki kiko kiʻekiʻe и kiko liʻiliʻi e maʻalahi loa.
- E koho i nā sparkline āu e makemake ai e hoʻololi. Inā hoʻohui ʻia lākou i loko o nā cell pili, a laila lawa ke koho i kekahi o lākou e koho i ka hui holoʻokoʻa i ka manawa hoʻokahi.
- Ma ka ʻaoʻao kiʻekiʻe Kukahula ma ka hui kauoha hoike hiki ke koho kiko kiʻekiʻe и kiko liʻiliʻi.
- E hōʻano hou ʻia ke ʻano o nā sparklines.
Hoʻololi kaila
- E koho i nā sparkline āu e makemake ai e hoʻololi.
- Ma ka ʻaoʻao kiʻekiʻe Kukahula e kaomi i ka pua hāʻule i lalo e ʻike i nā kaila hou aʻe.
- E koho i ke ʻano makemake.
- E hōʻano hou ʻia ke ʻano o nā sparklines.
Hoʻololi ʻano
- E koho i nā sparkline āu e makemake ai e hoʻololi.
- Ma ka ʻaoʻao kiʻekiʻe Kukahula koho i ke ʻano o ka sparkline āu e makemake ai. ʻo kahi laʻana, pakuhi ʻaukā.
- E hōʻano hou ʻia ke ʻano o nā sparklines.
Hoʻolālā ʻia kēlā me kēia ʻano sparkline no nā kumu kikoʻī. No ka laʻana, ʻoi aku ka maikaʻi o kahi sparkline lanakila / nalowale no ka ʻikepili kahi i loaʻa nā waiwai maikaʻi a maikaʻi ʻole paha (no ka laʻana, ka loaʻa kālā).
Ke hoʻololi nei i ka laulā hōʻike
Ma ka maʻamau, ua hoʻonui ʻia kēlā me kēia sparkline ma Excel e hoʻohālikelike i ka nui a me ka liʻiliʻi loa o kāna ʻikepili kumu. Aia ka waiwai nui ma luna o ke kelepona, a ʻo ka mea liʻiliʻi ma lalo. ʻO ka mea pōʻino, ʻaʻole hōʻike kēia i ka nui o ka waiwai ke hoʻohālikelike ʻia me nā sparklines ʻē aʻe. Hiki iā Excel ke hoʻololi i ke ʻano o nā sparklines i hiki ke hoʻohālikelike ʻia kekahi i kekahi.
Pehea e hoʻololi ai i ka laulā hōʻike
- E koho i nā sparkline āu e makemake ai e hoʻololi.
- Ma ka ʻaoʻao kiʻekiʻe Kukahula koho hui iho (axis). E hōʻike ʻia kahi papa kuhikuhi.
- I nā ʻāpana no ka nui a me ka liʻiliʻi loa ma ka axis vertical, hiki ke koho Hoʻopaʻa ʻia no nā sparkline a pau.
- E hōʻano hou ʻia nā Sparklines. I kēia manawa hiki iā lākou ke hoʻohana e hoʻohālikelike i nā kūʻai ma waena o nā mea kūʻai aku.