Tababarka Shaxda Muuqaalka 2003 2003 Excel

01 ee 10

Guudmarka Muuqaalka Tusaalaha Wareegista ee 2003 2003

Tababarka Shaxda Muuqaalka 2003 2003 Excel. © Ted Faransiis

Tababarkani wuxuu daboolayaa tallaabooyinka loo sameeynayo garaafka xariijinta ee Excel 2003 adoo isticmaalaya Sharciga Wareegga Sharciga (Excel Chart Wizard).

Dhammaystiridda tallaabooyinka mawduucyada hoos ku qoran waxay soo saaraan garaafyo line oo la mid ah sawirka kor ku xusan.

02 of 10

Gelinta Xogta Qalabka Band

Gelinta Xogta Qalabka Band. © Ted Faransiis

Iyada oo aan loo eegin nooca shaxda ama garaafka aad abuureyso, talaabada koowaad ee sameynta shaxan muraayadeed waa marwalba inay tahay inay galaan xogta waraaqaha shaqada .

Markaad soo galayso xogta, sharciyadan maskaxda ku hay:

  1. Ha ka tagin safafka ama xayawaanka bilawga ah markaad soo gasho xogtaada.
  2. Geli xogtaada tiirarka.

Talaabooyinka Tababarka

  1. Geli xogta sida muuqata sawirka kor ku xusan unugyada A1 ilaa C6.

03 of 10

Xulashada Xogta Qalabka Band

Xulashada Xogta Qalabka Band. © Ted Faransiis

Isticmaalka jiirka

  1. Jiid jooji badhanka mouse si aad u muujiso unugyada ay ku jirto xogta lagu darayo garaafka.

Isticmaalka kumbuyuutarka

  1. Guji dhinaca bidix ee xogta garaafka .
  2. Fur keydka SHIFT ee kumbuyuutarka.
  3. Isticmaal furayaasha fallaadhka ee kumbuyuutarka si aad u dooratid xogta lagu daro garaafka.

Xusuuso: Hubso inaad xulato saxan kasta iyo cinwaano kuxiran oo aad rabto in lagu daro garaafka.

Talaabooyinka Tababarka

  1. Tilmaamida unugyada unugyada laga bilaabo A2 ilaa C6, oo ay ka mid yihiin magaacda tiirarka iyo cinwaanada isku xigxiga iyadoo la adeegsanayo mid ka mid ah hababka kor ku xusan.

04 of 10

Bilaabidda Wizard Chart

Chart Wizard Icon oo ku yaal Qalabka Qalabka Standard. © Ted Faransiis

Waxaad leedahay laba ikhtiyaar oo aad ku bilaabi kartaan Jaantuska Jaantuska.

  1. Guji ' Chart Wizard icon' oo ku yaal qalabkan caadiga ah (eeg muuqaalka kor ku xusan)
  2. Guji geli [Chart]

Talaabooyinka Tababarka

  1. Ku bilaw Sifada Wareegtada Jadwalka adiga oo isticmaalaya habka aad doorbidayso.

05 ee 10

Tusaha Wareegga Sharciga ee Tallaabada 1aad

Tusaha Wareegtada Wareegtada Qodobka 1aad: © Ted Faransiis

Dooro Jaantuska Heerka Sare

  1. Qaado nooc ka mid ah jaantuska ka soo gala dhinaca bidixda.
  2. Xulo astaanta jaantuska ee ka tirsan guddiga saxda ah.

Talaabooyinka Tababarka

  1. Xulo nooca sawirka ee xariiqda bidixda.
  2. Xulo Khadka leh astaanta jaantuska hoose ee midigta midig
  3. Click Next.

06 of 10

Tusaha Wareegtada Jadwalka ee Tallaabada 2aad

Tusaha Wareegtada Wareegga ee Tallaabada 2aad. © Ted Faransiis

Horudhaw Jadwalkaaga

Talaabooyinka Tababarka

  1. Click Next.

07/10

Tusaha Wareegtada Jadwalka ee Tallaabada 3aad

Tusaha Wareegtada Wareegga ee Tallaabada 3aad. © Ted French

Chart Options

Inkasta oo ay jiraan fursado badan oo hoos imaanaya lixda tab ee loogu talagalay qaabeynta muuqaalka shaxankaada, tallaabadaas, waxaanu kaliya ku dari doonaa koobiyada.

Dhammaan qaybaha shaxanka Excel waxaa la bedeli karaa kaddib marka aad dhammaystirto Wareegtada Wareegtada, sidaa daraadeed ma ahan lagama maarmaan in la sameeyo dhammaan kala doorashooyinkaaga qaabaynta hadda.

Talaabooyinka Tababarka

  1. Riix batoonka Titles oo ku yaal dhinaca sare ee sanduuqa wada-hadalka ee Chart Wizard.
  2. Sanduuqda cinwaanka jadwalka, ku qor cinwaanka: Cunto dhexdhexaad ah ee Acapulco iyo Amsterdam .
  3. Qeybta (X) ee sanduuqa qaybta (X), nooca: Bisha .
  4. Sanduuqa dhexda (Y) ee sanduuqa (Y), nooca: Dufanka (mm) (Ogow: mm = millimitir).
  5. Marka daaqada ee daaqada horay u muuqata mid sax ah, riix Next.

Fiiro gaar ah: Markaad ku qorto cinwaanada, waa in lagu daraa daaqada hore ee dhinaca midigta

08/10

Tusaha Wareega Jadwalka ee Tallaabada 4aad

Tusaha Wareegtada Wareegga ee Tallaabada 4aad. © Ted French

Goobta Goobta

Waxaa jira laba xulasho oo kaliya oo ah meesha aad rabto inaad dhigto garaafkaaga:

  1. Sida xaashi cusub (waxaad ku qortaa jaantuska warqad shaqo oo ka duwan buugga shaqada)
  2. Sida sheyga ku yaal xaashi 1 (jaantuska ku yaal xaashi isku mid ah sida macluumaadkaaga buugga shaqada)

Talaabooyinka Tababarka

  1. Riix badhanka raadiyaha si aad u dhigo garaafka sheyga ku yaal xaashi 1.
  2. Guji Finish.

Waxaa la sameeyaa garaaf asal ah oo aasaasi ah oo lagu dhajiyay warqaddaada shaqada. Bogagga soo socda ayaa ku daboolaya qaabaynta qaabka garaafka si loo waafajiyo garaafka garaafka ee lagu muujiyay Tallaabada 1aad ee casharkan.

09 ka mid ah 10

Faafinta Khadka Xisaabta

Faafinta Khadka Xisaabta. © Ted Faransiis

Ku rid cinwaanka garaafka laba xariiq

  1. Hal mar guji farriinta faraha ee meel kasta oo ku taal magaca garaafka si aad u muujiso.
  2. Mar labaad adigoo riixaya calaamadda midigta midigta hore ee erayada Acapulco si aad u ogaato barta galinta.
  3. Ku dhufo furaha ENTER ee kumbuyuutarka si aad ugu qeybiso garaafka shaashadda laba qaybood.

Beddel midabka asalka ah ee garaafka

  1. Isla markiiba midig uji jadwalka muraayada meel kasta oo ka mid ah asalka caddaanka ah ee garaafka si aad u furto liiska hooseeya.
  2. Ku dhaji calaamadda mashiinka ah ee xulashada ugu horeysa ee ku jirta menu: Fadlan Jaantuska Aagga si aad u furto sanduuqa Wadiiqada Chart Area.
  3. Riix tabarka Hababka si aad u doorato.
  4. Qeybta Goobta , guji kareemka midabada si aad u doorato.
  5. Tababarkaan, dooro midabka huruudka ah ee hoose ee sanduuqa wada-hadalka.
  6. Guji OK.

Beddel midabka asalka / ka saar xuduudda halyeeyada

  1. Xaqiiji-hal mar adigoo tilmaamaya jiirada meel kasta oo ka mid ah asalka jaantuska garaafka si aad u furto liiska hooseeya.
  2. Ku dhufo tilmaamaha mouse ee xulashada koowaad ee menu: Format Legend si aad u furto sanduuqa Xirmada Foomka Foomka.
  3. Riix tabarka Hababka si aad u doorato.
  4. Qaybta Xuduudaha ee dhinaca bidix ee sanduuqa wada-hadalka, ku dhaji Xulashada ikhtiyaarka ah si aad uga saarto xadka.
  5. Qeybta Goobta , guji kareemka midabada si aad u doorato.
  6. Tababarkaan, dooro midabka huruudka ah ee hoose ee sanduuqa wada-hadalka.
  7. Guji OK.

10 of 10

Faafinta Khariidadda Khadka (Weli Socda)

Tababarka Shaxda Muuqaalka 2003 2003 Excel. © Ted Faransiis

Beddel midabka / ka saar xadka degaanka

  1. Xaqiiji-hal mar adigoo tilmaamaya jiirka muraayada meel kasta oo ka mid ah garaafka garaafka waa garaafka si aad u furto liiska hoos u dhaca.
  2. Ku dhaji calaamadda mashiinka ah ee xulashada ugu horeysa ee ku jirta menu: Aaga Muuqaalka Booska si aad u furto sanduuqa Muuqaalka Boodhka.
  3. Riix tabarka Hababka si aad u doorato.
  4. Qaybta Xuduudaha ee dhinaca bidix ee sanduuqa wada-hadalka, ku dhaji Xulashada ikhtiyaarka ah si aad uga saarto xadka.
  5. Qeybta Goobta ku taal dhinaca midig, riix kareemka midabada leh si aad u doorato.
  6. Tababarkaan, dooro midabka huruudka ah ee hoose ee sanduuqa wada-hadalka.
  7. Guji OK.

Ka saar cutubka Y

  1. Xaqiiji-hal mar adigoo isticmaalaya tilmaamaha mashiinka Y axis (xariiqda tooska ah ee ku xiga qiyaasta roobabka) ee garaafka si aad u furto liiska hoos u dhigga.
  2. Ku dhaji calaamadda mashiinka ee xulashada koowaad ee menu: Foomka Axis si loo furo sanduuqa Axka Foomka.
  3. Riix tabarka Hababka si aad u doorato.
  4. Qeybta Lines ee dhinaca bidix ee sanduuqa wada-hadalka, waxaad ku dhejisaa Xulashada ikhtiyaariga ah si aad uga saartid khadadka xagalka.
  5. Guji OK.

Waqtigan xaadirka ah, garaafkaaga waa inuu u dhigmaa khariidada garaafka ee lagu muujiyay Tallaabada 1aad ee casharkan.