Okuqukethwe
Ukwakhiwa kwenkinga
Ngingathanda ukuthi amakholomu aku-histogram (noma izingcezu eshadini likaphayi, njll.) abe nombala osetshenziswe ngokuzenzakalelayo ukugcwalisa amaseli ahambisanayo nedatha yomthombo:
Ukulindela ukukhala okumangazayo nokuthukuthela kwamaqabane ngamanye, kufanele kuqashelwe ukuthi, yiqiniso, umbala wokugcwalisa emdwebeni ungashintshwa ngesandla (chofoza kwesokudla kukholamu - Ifomethi yephoyinti/uchungechunge (Fometha iphoyinti ledatha/uchungechunge) njll. - akekho ophikisanayo. Kodwa ekusebenzeni, kunezimo eziningi lapho kulula futhi kulula ukwenza lokhu ngokuqondile kumaseli anedatha, bese ishadi kufanele lipendwe kabusha ngokuzenzakalelayo. Zama, isibonelo, ukusetha ukugcwaliswa ngendawo kwamakholomu kuleli shadi:
Ngicabanga ukuthi uyawuthola umqondo, akunjalo?
Isixazululo
Akukho lutho ngaphandle kwe-macro engenza lokhu. Ngakho-ke, sivula I-Visual Basic editor kusuka kuthebhu Unjiniyela (Unjiniyela — Isihleli Esiyisisekelo Esibonakalayo) noma cindezela isinqamuleli sekhibhodi I-Alt + F11, faka imojuli entsha engenalutho ngemenyu Faka – Imojula bese ukopisha umbhalo we-macro enjalo, ezokwenza wonke umsebenzi:
I-Sub SetChartColorsFromDataCells() Uma I-TypeName(Ukukhetha) <> "Indawo Yeshadi" Bese kuba ngu-MsgBox "Сначала выделите диаграмму!" Phuma Isiphetho Esingaphansi Uma Kusethiwe c = I-ActiveChart Ku-j = 1 Ku-c.SeriesCollection.Count f = c.SeriesCollection(j).Ifomula m = Hlukanisa(f, ",") Setha r = Ububanzi(m(2)) Ku-i = 1 Ukuze r.Amaseli.Bala c.SeriesCollection(j).Amaphuzu(i).Fometha.Gcwalisa.ForeColor.RGB = _ r.Amaseli(i).Ingaphakathi.Umbala Olandelayo i Okulandelayo j End Sub
Manje usungakwazi ukuvala i-Visual Basic bese ubuyela ku-Excel. Ukusebenzisa i-macro edaliwe kulula kakhulu. Khetha ishadi (indawo yeshadi, hhayi indawo yesakhiwo, igridi noma amakholomu!):
bese usebenzisa i-macro yethu ngenkinobho amamakhro ithebhu Unjiniyela (Unjiniyela - Amamakhro) noma ngesinqamuleli sekhibhodi I-Alt + F8. Ewindini elifanayo, uma kwenzeka lisetshenziswa njalo, unganikeza isinqamuleli sekhibhodi ku-macro usebenzisa inkinobho Amapharamitha (Izinketho).
PS
Okuwukuphela kwempukane kumafutha ukungenzeki kokusebenzisa umsebenzi ofanayo ezimweni lapho umbala unikezwe amaseli wedatha yomthombo kusetshenziswa imithetho yokufometha enemibandela. Ngeshwa, i-Visual Basic ayinalo ithuluzi elakhelwe ngaphakathi lokufunda le mibala. Kukhona, yiqiniso, "izinduku" ezithile, kodwa azisebenzi kuwo wonke amacala futhi hhayi kuzo zonke izinguqulo.
- Ayini ama-macros, angawasebenzisa kanjani, lapho ungafaka khona ikhodi ye-macro ku-Visual Basic
- Ukufometha Okunemibandela ku-Excel 2007-2013
- Yini Okusha Kumashadi ku-Excel 2013