Mtundu wa tchati kuchokera m'maselo okhala ndi deta yake

Kupanga vuto

Ndikufuna mizati ya histogram (kapena magawo pa tchati cha chitumbuwa, ndi zina zotero) kuti ikhale ndi mtundu womwe unagwiritsidwa ntchito kudzaza ma cell ofanana ndi zomwe zachokera:

Poyembekezera kulira modabwitsa komanso kokwiyira kwa abwenzi, ziyenera kuzindikirika kuti, zowonadi, mtundu wa zodzaza pazithunzi zitha kusinthidwanso pamanja (dinani kumanja pamzati - Ma point/series format (Fomati data point/series) etc. - palibe amene amatsutsa. Koma pochita, pali zinthu zambiri zomwe zimakhala zosavuta komanso zosavuta kuchita izi mwachindunji m'maselo omwe ali ndi deta, ndiyeno tchaticho chiyenera kupakidwanso. Yesani, mwachitsanzo, kuyika kudzaza ndi chigawo chazambiri za tchatichi:

Ndikuganiza kuti mwamva lingalirolo, sichoncho?

Anakonza

Palibe koma macro angachite izi. Chifukwa chake, timatsegula Visual Basic editor kuchokera ku tabu Woyambitsa (Wopanga - Visual Basic Editor) kapena dinani njira yachidule ya kiyibodi Alt + F11, ikani gawo latsopano lopanda kanthu kudzera pa menyu Ikani - Module ndikukopera zolemba za macro pamenepo, zomwe zingachite ntchito yonse:

Sub SetChartColorsFromDataCells() Ngati TypeName(Selection) <> "ChartArea" Kenako MsgBox "Сначала выделите диаграмму!" Tulukani Sub End Ngati Yakhazikitsidwa c = ActiveChart Kwa j = 1 Ku c.SeriesCollection.Count f = c.SeriesCollection(j). Fomula m = Gawani (f, ",") Ikani r = Range(m(2)) Kwa i = 1 Kuti r.Maselo.Kuwerengera c.SeriesCollection(j).Points(i).Format.Fill.ForeColor.RGB = _ r.Maselo(i).Mkati.Color Next i Next j End Sub

Tsopano mutha kutseka Visual Basic ndikubwerera ku Excel. Kugwiritsa ntchito macro opangidwa ndikosavuta. Sankhani tchati (malo a tchati, osati malo, gululi kapena mizati!):

ndikuyendetsa macro athu ndi batani Macros tsamba Woyambitsa (Wopanga - Macros) kapena ndi njira yachidule ya kiyibodi Alt + F8. Pazenera lomwelo, mukagwiritsidwa ntchito pafupipafupi, mutha kuyika njira yachidule ya kiyibodi ku macro pogwiritsa ntchito batani magawo (Zosankha).

PS

Ntchentche yokhayo mumafuta ndizosatheka kugwiritsa ntchito ntchito yofananira pamilandu yomwe mtunduwo umaperekedwa ku maselo a gwero la data pogwiritsa ntchito malamulo okhazikika. Tsoka ilo, Visual Basic ilibe chida chomangira chowerengera mitundu iyi. Pali, ndithudi, "ndodo" zina, koma sizigwira ntchito pazochitika zonse osati m'mitundu yonse.

  • Kodi macros ndi chiyani, momwe angagwiritsire ntchito, momwe mungayikitsire macro code mu Visual Basic
  • Mapangidwe Okhazikika mu Excel 2007-2013
  • Zomwe Zatsopano mu Ma chart mu Excel 2013

Siyani Mumakonda