Weligaa xaashi shaqo oo xog ah ku haysay Excel oo si degdeg ah u doonaysay inaad aragto isbeddelka xogta? Waxaa laga yaabaa inaad haysatid qaar ka mid ah buundooyinka imtixaanka ee ardaydaada ama dakhliga ka soo gala shirkaddaada 5tii sano ee la soo dhaafay iyo halkii aad ka abuuri lahayd jaantus gudaha Excel^{(creating a chart in Excel)} , taas oo waqti qaadata oo ku dhammaata in la cuno warqad shaqo oo dhan, qaar ka mid ah jaantusyada yaryar ee hal unug. ka roonow.

Excel 2010, 2013 iyo 2016 waxay leeyihiin muuqaal wanaagsan oo loo yaqaan sparklines kaas oo asal ahaan kuu oggolaanaya inaad abuurto jaantusyo yar-yar gudaha hal unug oo Excel ah. Waxaad ku dari kartaa khadadka iftiimaya unug kasta oo ku hay meel ku xigta xogtaada. Sidan, waxaad si degdeg ah u sawiri kartaa xogta safka xigta. Waa hab kale oo wanaagsan oo lagu falanqeeyo xogta Excel .

Inta aynaan bilaabin, aynu eegno tusaale degdeg ah oo ah waxa aan ula jeedo. Xogta hoose, waxaan dakhli ka helay toban dukaan lixdii rubuc ee ugu dambeysay. Isticmaalka khadadka sparklines, waxaan si dhakhso ah u arki karaa dukaamada kordhinaya dakhliga iyo dukaamada si xun u shaqeynaya.

Sida iska cad, waa inaad ka taxadirtaa markaad eegayso xogta adoo isticmaalaya sparklines sababtoo ah waxay noqon kartaa marin habaabin iyadoo ku xiran hadba lambarada aad falanqaynayso. Tusaale ahaan, haddii aad eegto Bakhaarka 1^{(Store 1)} , waxaad arkaysaa in dakhligu ka kacay $56K ilaa $98 iyo khadka isbeddelku si toos ah u socdo.

Si kastaba ha noqotee, haddii aad eegto Bakhaarka 8^{(Store 8)} , khadka isbeddelku aad buu u eg yahay, laakiin dakhligu wuxuu ka yimid kaliya $ 38K ilaa $ 44K. Markaa khadadka dhuuxa ma ogola inaad u aragto xogta si buuxda. Garaafyada la sameeyay waxay ku xiran yihiin xogta safkaas, taas oo aad muhiim u ah in la fahmo.

Ujeedada isbarbardhigga, waxaan horay u sii socday oo abuuray jaantuska caadiga ah ee Excel oo leh xog isku mid ah oo halkan waxaad si cad u arki kartaa sida dukaan kastaa u shaqeeyo marka loo eego kuwa kale.

Jaantuskan, Store 8 aad buu u siman yahay marka loo eego Store 1, kaas oo wali ah xariiq kor u kacaya. Markaa waxaad arki kartaa sida xogta isku midka ah loogu tarjumi karo siyaabo kala duwan iyadoo ku xiran hadba sida aad doorato inaad u muujiso. Jaantusyada caadiga ah waxay kaa caawinayaan inaad aragto isbeddellada u dhexeeya safaf badan ama xog iyo khadadka iftiimaya waxay kuu oggolaanayaan inaad aragto isbeddellada hal saf oo xog ah.

Waa in aan ogaadaa in sidoo kale ay jirto hab lagu hagaajin karo fursadaha si xadhkaha yaryar loo barbar dhigo midba midka kale sidoo kale. Hoos ayaan ku xusi doonaa sida tan loo sameeyo.

Samee khad Sparkline ah

Haddaba, sidee ayaan u soconnaa samaynta dhinbiil? Gudaha Excel , runtii way fududahay in la sameeyo. Marka hore^(First) , dhagsii unugga ku xiga dhibcaha xogtaada, dabadeed dhagsii Gelida^(Insert) ka dibna dooro inta u dhaxaysa Line , Column , iyo Win/Loss ee hoos yimaada Sparklines .

Ka dooro^(Pick) mid ka mid ah saddexda doorasho iyadoo ku xiran sida aad rabto in xogta loo soo bandhigo. Had iyo jeer waad bedeli kartaa qaabka hadhow, markaa ha werwerin haddii aadan hubin midka sida ugu fiican ugu shaqayn doona xogtaada. Nooca Win/Loss ayaa kaliya macno samayn doonta xogta leh qiimayaal togan iyo kuwa taban. Daaqada waa in ay soo baxdaa oo ku weydiinaysa inaad doorato tirada xogta.

Guji^(Click) badhanka yar ee midigta ka dibna dooro hal saf oo xog ah. Marka aad doorato kala duwanaanta, horay u soco oo mar labaad dhagsii badhanka.

Hadda dhagsii OK oo khadkaaga iftiimaya ama jaantuska yari waa inuu ka dhex muuqdaa hal unug. Si aad u mariso laynka dhammaan safafka kale, kaliya qabso cidhifka midig ee hoose oo u jiid sida adiga oo kale unug leh qaacido ku dhex jira.

Habaynta Sparklines

Hadda oo aan haysanno khadadkayaga, aynu habaynno iyaga! Marka hore, waxaad had iyo jeer kordhin kartaa xajmiga unugyada si garaafyadu u weynaadaan. Sida caadiga ah, aad bay u yaryar yihiin wayna adkaan kartaa in si sax ah loo arko. Hadda hore u soco oo dhagsii unug kasta oo leh khad ifin leh ka dibna dhagsii tab naqshadda ee hoos timaada ^(Design)Sparkline Tools .

Laga bilaabo bidixda, waxaad wax ka beddeli kartaa xogta haddii aad jeceshahay inaad ku darto tiirar badan ama ka yar. Hoosta Nooca^(Type) , waxaad bedeli kartaa nooca jaantus yar oo aad rabto. Mar labaad^(Again) , Win/Loss waxaa loola jeedaa xogta leh tirooyinka taban iyo kuwa togan. Hoosta Muujinta^(Show) , waxaad ku dari kartaa calaamado garaafyada sida Barta Sare^{(High Point)} , Dhibcaha Hoose^{(Low Point)} , Dhibcaha Xun^{(Negative Points)} , Barta ^(Point)Kowaad^(First) & Ugu Dambeeyay^(Last) iyo Calaamadeeyayaasha^(Markers) (calamadaha dhibic kasta oo xog ah).

Qaabka hoostiisa^(Style) , waxaad bedeli kartaa habaynta garaafka. Asal ahaan, tani waxay beddeshaa midabada xariiqda ama tiirarka waxayna kuu ogolaaneysaa inaad doorato midabada calaamadaha. Dhanka midigta, waxaad hagaajin kartaa midabada laydhka iyo calaamadaha si gaar ah.

Habka kaliya ee kale ee muhiimka ah ee sparklines waa fursadaha Axis . Haddii aad gujiso badhankaas, waxaad arki doontaa doorarka qaarkood oo loo yaqaanno Vertical Axis Ugu Yar ee Qiimaha Options^{( Vertical Axis Minimum Value Options)} iyo Axis Axis Maximum Value Options.^{( Vertical Axis Maximum Value Options.)}

Haddii aad rabto inaad ka dhigto khadadka iftiinka ee dhammaan safafka kale halkii aad ka samayn lahayd safkeeda oo keliya, dooro Isku mid ah All Sparklines^{( Same for All Sparklines)} ee labada ciwaan. Hadda markaad eegto xogta, waxaad arki doontaa inaad barbardhigi karto jaantusyada marka loo eego qiyamka saxda ah. Waxaan sidoo kale ogaaday in daawashada jaantusyada qaabka tiirka ay sahlayso in la arko xogta marka la barbar dhigo dhammaan khadadka.

Sida aad hadda arki karto, tiirarka ku yaal Bakhaarka 1^{(Store 1)} aad ayey uga sarreeyaan tiirarka Dukaanka 8^{(Store 8)} , kaas oo lahaa wax yar oo kor u kaca ah, laakiin leh qiime dakhli oo aad u yar. Tiirarka buluugga khafiifka ah waa hooseeyaan iyo dhibco sare sababtoo ah waxaan hubiyay fursadahaas.

Taasi waxay ku saabsan tahay waxa jira oo dhan in la ogaado oo ku saabsan sparklines. Haddii aad rabto inaad u samayso xaashida xaashida Excel^(Excel) ee qurxoon ee madaxaaga, tani waa habka loo sameeyo. Haddii aad wax su'aalo ah qabtid, xor u noqo inaad faallo ka bixiso. Ku raaxayso!

How to use Sparklines in Excel

Ever had a workѕhеet of data in Excel and quickly wanted to see the trend in the data? Maybe you have some test scores for your students or revenuе from your сompany over the last 5 years аnd instead of creating a chart in Excel, which takes time and ends up eating up an entire worksheet, some small mini-charts in a single cell would be better.

Excel 2010, 2013 and 2016 have a cool feature called sparklines that basically let you create mini-charts inside a single Excel cell. You can add sparklines to any cell and keep it right next to your data. In this way, you can quickly visualize data on a row by row basis. It’s just another great way to analyze data in Excel.

Before we get started, let’s take a look at a quick example of what I mean. In the data below, I have revenue from ten stores over the last six quarters. Using sparklines, I can quickly see which stores are increasing revenue and which stores are performing badly.

Obviously, you have to be careful when looking at data using sparklines because it can be misleading depending on what numbers you are analyzing. For example, if you look at Store 1, you see that revenue went from $56K to about $98 and the trend line is going straight up.

However, if you look at Store 8, the trend line is very similar, but the revenue only went from $38K to $44K. So sparklines don’t let you see the data in absolute terms. The graphs that are created are just relative to the data in that row, which is very important to understand.

For comparison purposes, I went ahead and created a normal Excel chart with the same data and here you can clearly see how each store performs in relation to the others.

In this chart, Store 8 is pretty much a flat line as compared to Store 1, which is still a trending up line. So you can see how the same data can be interpreted in different ways depending on how you choose to display it. Regular charts help you see trends between many rows or data and sparklines let you see trends within one row of data.

I should note that there is also a way to adjust the options so that the sparklines can be compared to each other also. I’ll mention how to do this down below.

Create a Sparkline

So, how do we go about creating a sparkline? In Excel, it’s really easy to do. First, click in the cell next to your data points, then click on Insert and then choose between Line, Column, and Win/Loss under Sparklines.

Pick from any of the three options depending on how you want the data displayed. You can always change the style later on, so don’t worry if you’re not sure which one will work best for your data. The Win/Loss type will only really make sense for data that has positive and negative values. A window should pop up asking you to choose the data range.

Click on the little button at the right and then select one row of data. Once you have selected the range, go ahead and click on the button again.

Now click OK and your sparkline or tiny chart should appear in that one cell. To apply the sparkline to all the other rows, just grab the bottom right edge and drag it down just like you would a cell with a formula in it.

Customizing Sparklines

Now that we have our sparklines, let’s customize them! Firstly, you can always increase the size of the cells so that the graphs are bigger. By default, they are pretty tiny and can be hard to see properly. Now go ahead and click in any cell with a sparkline and then click on the Design tab under Sparkline Tools.

Starting from the left, you can edit the data if you like to include more columns or less. Under Type, you can change the type of mini chart you want. Again, the Win/Loss is meant for data with positive and negative numbers. Under Show, you can add markers to the graphs like High Point, Low Point, Negative Points, First & Last Point and Markers (marker for every data point).

Under Style, you can change the styling for the graph. Basically, this just changes the colors of the line or columns and lets you choose the colors for the markers. To the right of that, you can adjust the colors for the sparkline and the markers individually.

The only other important aspect of sparklines is the Axis options. If you click on that button, you’ll see some options called Vertical Axis Minimum Value Options and Vertical Axis Maximum Value Options.

If you want to make the sparklines relative to all the other rows instead of just its own row, choose Same for All Sparklines under both headings. Now when you look at the data, you’ll see that you can compare the charts in terms of absolute values. I also found that viewing the charts in column form makes it easier to see the data when comparing all sparklines.

As you can see now, the columns in Store 1 are much higher than the columns for Store 8, which had a slight upward trend, but with a much smaller revenue value. The light blue columns are low and high points because I checked those options.

That’s about all there is to know about sparklines. If you want to make a fancy looking Excel spreadsheet for your boss, this is the way to do it. If you have any questions, feel free to post a comment. Enjoy!

Related posts

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan

• Isticmaal daaqada daawashada Excel si aad ula socoto unugyada muhiimka ah ee buug-shaqeedka

• Sida loo qariyo xaashiyaha, unugyada, tiirarka, iyo qaaciidooyinka gudaha Excel

• Sida Looga Daro Baararka Cilada ee Excel

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• Sida loo kala saaro Magacyada Hore iyo Dambe ee Excel

• Sida Loo Abuuro Liiska Qaybinta Muuqaalka

• Sida loo Helo Qiimaha Iswaafajinta gudaha Excel

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• Sida loo barbar dhigo labada faylal ee Excel oo loo muujiyo faraqa u dhexeeya

• Sida loola socdo isbedelada Excel

• Adeegso Excel si aad u ogaato dulsaarka waxtarka leh ee ka imanaya heerka dulsaarka magaca ah

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel

• Geli xaashida shaqada ee Excel Word Doc

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel