(¤w¸Ñ¨M)Ãö©ó°ÊºA¹Ïªí©w¸q©R¦W½d³ò«á ·s¼W¸ê®Æ¤£·|¦Û°Ê§ó·s
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2012-4-6
|
(¤w¸Ñ¨M)Ãö©ó°ÊºA¹Ïªí©w¸q©R¦W½d³ò«á ·s¼W¸ê®Æ¤£·|¦Û°Ê§ó·s
¥»©«³Ì«á¥Ñ moonsmyrna ©ó 2011-12-20 17:56 ½s¿è
¦U¦ì«e½ú§A¦n~
§Ú·Q¦bªí®æ·s¼WÄæ¦ì(¤£¬O·s¼W¦C)®É¡A¹Ïªí¸òµÛÅÜ°Ê
¨Ò¦p¥Ø«e¦³A,B,CÄæ¦ì §Ú·Q·s¼WD,E
¦ý°ÝÃD¬O§Ú³]©w¦n¹Ïªíªº¸ê®Æ½d³ò=graphexpr«á¡A¸ê®ÆÅã¥Ü¥¿½T
¦ý·s¼WD,EÄæ¦ì®É¡A«o¨S¤ÏÀ³¡An¤â°Ê¦A³]¤@¦¸¸ê®Æ½d³ò=graphexpr¤~·|§ó·s
§Ú¥Ø«e¦³©w¸q©R¦W½d³ò¦p¤U
graphexpr=OFFSET('¦X¨Ö (2)'!$B$3:$B$10,0,0,8,COUNTA('¦X¨Ö (2)'!$B$3:$L$3))
§Ú©Ò°µªºÀɮצpªþ¥ó
Netbecnch.zip (11.08 KB)
¬O¤£¬O§Ú¦³þ¸Ì¥Î¿ù¤F©O>"<¦A³Â·Ð¦U¦ì«ü±Ð
©Î¬O¦³¨ä¥L¤å³¹¥i°Ñ¦Òªº©O |
|
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-6-23
- ³Ì«áµn¿ý
- 2012-4-6
|
¥»©«³Ì«á¥Ñ moonsmyrna ©ó 2011-12-20 17:57 ½s¿è
¬Û«Hµª®×´N¦b°Q½×ª©¤¤¡A©Ò¥H¤j®a¤~³£¨S²z§Ú¡A¬JµM³o¼Ë¡A¥u¦n¦Û¤O±ÏÀÙ¤F!!
³Ì«áª¦¤åɧUGBKEE«e½úªºVBAµ{¦¡&google¤j¯«ªº¤O¶q¸Ñ¨M¤F³o¦¸ªº§xÃø
GBKEE«e½ú¦^µªªº¥DÃD
´£¨Ñ¹Ïªí¬ÛÃöªºVBAµ{¦¡¡A¹ï§Ú¨Ó»¡º¡¦³¥Îªº(-¤£¥l¸Á¤Þ½ºªº¤pªá-)
²×©ó§¹¦¨¤£ºÞ·s¼W¦C©ÎÄ檺¸ê®Æ¡A¹Ïªí³£·|¸òµÛÅÜ°Ê~vbaµ{¦¡½XÅܧó¦p¤U- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim ø¹Ï°Ï As Range
- Dim i, j As String
-
- If [COUNTA(¦X¨Ö!$A:$A)] > 0 Then
- i = [COUNTA(¦X¨Ö!$A:$A)] 'pºâ¦³Èªº¦C¼Æ
- j = [SUBSTITUTE(ADDRESS(ROW(),COUNTA(¦X¨Ö!$A$2:$Z$2),4),ROW(),"")] 'pºâ¦³Èªº¦æ¼Æ¡A¨ÃÂà´«¦¨¦æ¦W ex:²Ä1¦æ¬°A
- Else
- i = 2
- j = "B"
- End If
-
- Set ø¹Ï°Ï = Range("B2", j & i)
- ChartObjects("Chart 1").Activate
- ActiveChart.SetSourceData ø¹Ï°Ï, 2
- ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="cheryl" '³]©w¹ÏªíÃþ«¬ ¦Ûqcheryl
- ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Throughput" 'Y¶btitle
- ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Engines" 'X¶btitle
- ActiveChart.SeriesCollection(1).XValues = Range("A3", "A" & i) '³]©wX¶bÃþ§O
- Target.Select
- End Sub
½Æ»s¥N½X ªþ¤W§¹¦¨ª©excel
Netbecnch2_o2.zip (22.79 KB)
·íµMÁÙ¦³¨ÇBUG...¹³¬O¦pªG¤£¬O³sÄò¸ê®Æ(ex: AAA,BBB,<ªÅ®æ>,CCC)ªº¸Ü ¹Ïªí´N·|©Ç©Çªº
¦A½Ð¤j®a«ü±ÐOTZ |
|
|
|
|
|
|