ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

(¤w¸Ñ¨M)Ãö©ó°ÊºA¹Ïªí©w¸q©R¦W½d³ò«á ·s¼W¸ê®Æ¤£·|¦Û°Ê§ó·s

(¤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¤ÏÀ³¡A­n¤â°Ê¦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

¥»©«³Ì«á¥Ñ 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
  1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  2.     Dim ø¹Ï°Ï As Range
  3.     Dim i, j As String
  4.    
  5.     If [COUNTA(¦X¨Ö!$A:$A)] > 0 Then
  6.         i = [COUNTA(¦X¨Ö!$A:$A)] '­pºâ¦³­Èªº¦C¼Æ
  7.         j = [SUBSTITUTE(ADDRESS(ROW(),COUNTA(¦X¨Ö!$A$2:$Z$2),4),ROW(),"")] '­pºâ¦³­Èªº¦æ¼Æ¡A¨ÃÂà´«¦¨¦æ¦W ex:²Ä1¦æ¬°A
  8.     Else
  9.         i = 2
  10.         j = "B"
  11.     End If
  12.    
  13.     Set ø¹Ï°Ï = Range("B2", j & i)
  14.     ChartObjects("Chart 1").Activate
  15.     ActiveChart.SetSourceData ø¹Ï°Ï, 2
  16.     ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="cheryl" '³]©w¹ÏªíÃþ«¬ ¦Û­qcheryl
  17.     ActiveChart.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Throughput" 'Y¶btitle
  18.     ActiveChart.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Engines" 'X¶btitle
  19.     ActiveChart.SeriesCollection(1).XValues = Range("A3", "A" & i) '³]©wX¶bÃþ§O
  20.     Target.Select
  21. 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

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD