Ƙirƙirar Chart a Excel ta amfani da Ƙunƙwasa

Idan ka buƙaci ginshiƙi a cikin sauri ko kana so ka bincika wasu abubuwan da ke cikin bayanan ka, za ka iya ƙirƙirar ginshiƙi a Excel tare da maɓallin keystroke ɗaya.

Ɗaya daga cikin sifofin fasali na Excel shi ne cewa shirin yana da nau'in nau'i nau'i nau'in tsarin da za a iya kunna ta ta amfani da makullin gajeren hanya na keyboard.

Wannan jadawalin na ba da damar masu amfani don ƙara rubutun da aka saba amfani da shi zuwa aikin aiki na yanzu ko kuma don ƙara chart zuwa takardar aiki na dabam a cikin littafin aiki na yanzu.

Matakai guda biyu don yin wannan shine:

1. Zaži bayanan da kake so ka yi amfani da shi a cikin zane
2. Latsa maballin F11 akan keyboard

Ana tsara sutura ta amfani da duk saitunan tsoho na yanzu kuma an kara su zuwa takardar aiki dabam a cikin littafin aiki na yanzu.

Idan ba'a sauya saitunan asali ba, ba a canza shafin da aka tsara ta latsa F11 ba.

01 na 04

Ƙara Shafin Zaɓuɓɓuka zuwa Ɗaukaka Ayyuka na yanzu tare da Alt F1

Har ila yau da ƙara kwafin rubutu na tsoho zuwa takardar aiki dabam, ana iya ƙara wannan ginshiƙi a aikin aiki na yanzu - aikin aiki inda aka samo bayanan chart - ta amfani da maɓallin gajeren gajeren maɓalli.

1. Zaži bayanan da kake so ka yi amfani da shi a cikin tashar;
2. Latsa ka riƙe ƙasa Alt a kan keyboard;
3. Latsa kuma saki maɓalli F1 akan keyboard;
4. An ƙara jadawalin daftarin zuwa aikin aiki na yanzu.

02 na 04

Canza nau'in Shafin Taɓa na Excel

Idan latsa F11 ko Alt F1 ya samar da ginshiƙi wanda bai dace da ƙaunarka ba, kana buƙatar canza yanayin ma'auni.

Dole ne a zaba sabon nau'in ma'auni na asali daga babban fayil na samfurori na Excel wanda ke riƙe kawai shaci da ka ƙirƙiri.

Hanyar da ta fi sauƙi don canza tsoffin ma'auni a cikin Excel shine:

1. Danna madaidaici a kan tashar da aka rigaya don buɗe mahaɗin maɓallin dannawa-dama ;
2. Zabi Canza Chart Rubutun daga mahallin mahallin don buɗe Siffar Chafin Rubutun maganganu ;
3. Danna kan Samfura a bangaren hagu na akwatin maganganu;
4. Danna dama a kan misalin misalin a hannun dama Ƙa'idodin Templates ;
5. Zabi "Saitin azaman tsoho" a cikin mahallin mahallin.

03 na 04

Samar da kuma Ajiye Samfurar Shafin

Idan ba a riga ka ƙirƙiri samfurin da za a iya amfani dashi azaman tsoho irin layi, hanya mafi sauki ta yin wannan shi ne:

1. Gyara ginshiƙi wanda ke kasancewa don haɗawa da dukan zaɓuɓɓukan tsarawa - kamar launi na baya, X da Y saitunan sikelin, da kuma nau'in font - don sabuwar samfuri;
2. Danna danna kan ginshiƙi;
3. Zabi "Ajiye azaman Template ..." daga menu na mahallin kamar yadda aka nuna a cikin hoton da ke sama, don buɗe akwatin maganganun Shafi na Taswirar Ajiye ;
4. Sunan samfurin;
5. Danna maɓallin Ajiye don ajiye samfurin kuma rufe akwatin maganganu.

Lura: An ajiye fayiloli a matsayin fayil na .crtx zuwa wuri mai zuwa:

C: \ Takardu da Sunan mai amfani \ AppData \ Gudun Microsoft \ Samfura \ Shafuka

04 04

Share Shafin Taswira

Hanyar mafi sauki don share tsarin al'ada na custom in Excel shine:

1. Danna-dama a kan taswirar da aka rigaya don buɗe maballin menu na dama-danna;
2. Zabi "Canza Siffar Rubutun" daga mahallin mahallin don buɗe mahafan rubutun Changes Type akwatin zane;
3. Danna kan Samfura a bangaren hagu na akwatin maganganu;
4. Danna kan Manajan Samfura a cikin ɓangaren hagu na hagu na akwatin maganganu don buɗe babban fayil na shafukan;
5. Danna-dama a kan samfurin da za a share kuma zaɓa Share a cikin mahallin mahallin - Maganar maganin fayil ɗin za ta buɗe tambayarka don tabbatar da sharewar fayil;
6. Danna Ee a cikin maganganun don share samfurin kuma rufe akwatin maganganu.