- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-4-19 17:52 ½s¿è
¦^´_ 31# c_c_lai
¹ï¤£°_ :§Aªºª©¥»¸û¥ý¶i §Ú¤£©ö°»¿ù
¥u¦³§A¾É¤Þ·s¼W¹Ïªí ¸û²©öªº¤èªk, ¤§«á§A¦A¨Ì§Aªº»Ý¨Dקï- Sub Ex()
- Dim Rng As Range, xi As Integer
- With ActiveSheet
- .ChartObjects.Delete '¹Ïªí¥þ³¡§R°£
- For xi = 0 To 4
- ' Set Rng = .[a1].Offset(, xi * 10) ' ¶¡¹j10Äæ
- Set Rng = .[a1].Offset(xi * 15) ' ¶¡¹j15¦C
- With .ChartObjects.Add(Rng.Left, Rng.Top, Rng.Resize(, 10).Width, Rng.Resize(10).Height).Chart
- ' .ChartObjects.Add(Left, Top, Width, Height) '¹Ïªí·s¼W( ¥kÃä¦ì¸m, ¤W¤è¦ì¸m ,¼e«×, °ª«× )
- .SetSourceData Source:=Sheets("²Îp¹Ïªí").UsedRange.Columns(xi + 1), PlotBy:=xlColumns
- .HasTitle = True
- .ChartTitle.text = "¹Ïªí " & xi + 1
- End With
- Next
- End With
- End Sub
½Æ»s¥N½X |
|