Contents
Samar da matsala
Ina son ginshiƙan kan histogram (ko yanka akan ginshiƙi, da sauransu) su sami launi ta atomatik da aka yi amfani da su don cika sel masu dacewa tare da bayanan tushen:
Ana tsammanin kukan mamaki da fushi na kowane abokin tarayya, ya kamata a lura cewa, ba shakka, ana iya canza launi na cika a cikin zane da hannu (danna-dama a kan shafi - Tsarin maki/jerin (Tsarin wurin bayanai/jeri) da dai sauransu - babu wanda yayi jayayya. Amma a aikace, akwai yanayi da yawa lokacin da ya fi sauƙi kuma mafi dacewa don yin wannan kai tsaye a cikin sel tare da bayanai, sa'an nan kuma ya kamata a sake fentin ginshiƙi ta atomatik. Gwada, misali, don saita cika ta yanki don ginshiƙan cikin wannan ginshiƙi:
Ina tsammanin kun sami ra'ayin, daidai?
Magani
Babu wani abu sai macro da zai iya yin wannan. Saboda haka, mun bude Visual Basic edita daga tab developer (Mai Haɓakawa - Editan Kayayyakin gani) ko danna gajeriyar hanyar madannai Alt+F11, Saka sabon tsarin komai a cikin menu Saka - Module kuma kwafi rubutun irin wannan macro a can, wanda zai yi duk aikin:
Sub SetChartColorsFromDataCells() If TypeName(Zaɓi) <> "ChartArea" Sai MsgBox "Сначала выделите диаграмму!" Fita Ƙarshen Ƙarshen Ƙarshen c = ActiveChart Don j = 1 Zuwa c.SeriesCollection.Count f = c.SeriesCollection(j).Formula m = Raba (f, ",") Saita r = Range(m(2)) Domin i = 1 To r.Cells.Count c.SeriesCollection(j).Points(i).Format.Fill.ForeColor.RGB = _ r.Cells(i).Interior.Launi Gaba i Gaba j Karshen Sub.
Yanzu zaku iya rufe Visual Basic kuma ku koma Excel. Yin amfani da macro da aka ƙirƙira abu ne mai sauqi qwarai. Zaɓi ginshiƙi (yankin ginshiƙi, ba yanki mai ƙira ba, grid ko ginshiƙai!):
da kuma gudanar da mu macro da button Macros tab developer (Developer - Macros) ko tare da gajeriyar hanyar keyboard Alt+F8. A cikin wannan taga, idan ana yawan amfani da shi, zaku iya sanya gajeriyar hanyar madannai zuwa macro ta amfani da maɓallin Siga (Zaɓuɓɓuka).
PS
Guda kawai a cikin maganin shafawa shine rashin yiwuwar yin amfani da irin wannan aikin don lokuta inda aka sanya launi zuwa sel na bayanan tushen ta amfani da ka'idojin tsara yanayin. Abin takaici, Visual Basic ba shi da kayan aiki da aka gina don karanta waɗannan launuka. Akwai, ba shakka, wasu "ƙugiya", amma ba sa aiki ga duk lokuta kuma ba a cikin kowane nau'i ba.
- Menene macros, yadda ake amfani da su, inda za a saka macro code a cikin Visual Basic
- Tsarin Yanayi a cikin Excel 2007-2013
- Menene sabo a cikin Charts a cikin Excel 2013