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

[µo°Ý] K ½uªÑ²¼¹Ï¦p¦ó¯à»P¥D¤O¡B´²¤á¡B¤Î¦¨¥æ¶q½u¦@¦s¡H

¦^´_ 1# c_c_lai


    ½Ð±Ð¤@¤U
   §Ú§â¨ä¤¤»yªk§ï¦¨  with Sheets("¤u§@ªí1").ChartObjects("¹Ïªí 1").Chart
¦ýÁÙ¬O­n¿ï¾Ü¹Ïªí¤~¥i¥H¶]
¯àÅý¥¨¶°¦Û°Ê­I«áRUN¶Ü ¤£»Ý­n¥h¿ï¨ú¹Ïªí


ªÑ²¼¹Ïªí2.rar (23.18 KB)

TOP

¦^´_ 43# c_c_lai


    ¤£¿f§A»¡  «Ü¦h»yªk³£°Å°Å¶K¶Kªº «Ü¦h»yªk ¬Ý¤£¤ÓÀ´
   §Ú·Ó§A»¡ªº§âchartname §ï¦ì¸m¤F..
¦ý¬O¹Ïªí¦ì¸m ¤£·|°ÊA
©ó¬O§Ú§ï¤F³Ì«á¨â¦æ  ÁÙ¬O¤£·|°Ê  ³Â·ÐÀ°§Ú¬Ý¤@¤U
  1.         chartname = Trim(Replace(.Name, .Name, ""))
  2.     End With
  3.    
  4.    
  5.     Sheets("¤u§@ªí1").Shapes(chartname).Left = Cells(xRow, yCol).Left     ' ³]©w¦¹¹Ïªí¹ê»ÚÂ\©ñªº X¡BY ®y¼Ð¦ì¸m¡C
  6.     Sheets("¤u§@ªí1").Shapes(chartname).Top = Cells(xRow, yCol).Top
  7.    
  8.     Range("A1").Select
  9. End Sub
½Æ»s¥N½X

TOP

¦^´_ 43# c_c_lai

°Ê¤F°Ê¤F
Sheets("¤u§@ªí1").ChartObjects("¹Ïªí 1").Left  = Cells(xRow, yCol).Left   
§ï¦¨³o¼Ë´N¥i¥H°Ê¤F..

   ÁÂÁ«e½ú«ü±Ð

TOP

¦^´_ 46# c_c_lai


    ·s°ÝÃD¤S¨Ó¤F.
   .Legend.Position = xlCorner                         ' ±N¹Ïªí¹Ï¥Ü±q¹Ïªí³Ì¤U¤è½Õ¾ã¨ì¹Ïªí¤§¥k¤W¨¤¦ì¸m

   xlCorner        §Ú§ä¤£¨ì³o­Ó°Ñ¼Æ¬O±q­þ¸Ì¨Óªº
  §ä¨ì³o­Ó  
   xlLegendPositionBottom -4107 ¹Ïªí¤U¤è
xlLegendPositionCorner 2 ¦ì©ó¹Ïªí®Ø½uªº¥k¤W¨¤
xlLegendPositionCustom -4161 ¦Û­q¦ì¸m
xlLegendPositionLeft -4131 ¹Ïªí¥ªÃä
xlLegendPositionRight -4152 ¹Ïªí¥kÃä
xlLegendPositionTop -4160 ¹Ïªí¤W¤è

§â xlCorner §ï¦¨¼Æ¦r(-4152) ¤§Ãþªº¦ì¸m´N¥i¥H§ïÅÜ  ¦ýxlCorner¬O±q­þ¸Ì±oª¾ªº

¦A¦h°Ý¤@­Ó°ÝÃD
§Ú¬Ý§Aªº ¼Æ¾Ú¬O¤G¤Q¬íºI¨ú¤@¦¸ À³¸Ó¬O¥ÎDDE§a?
½Ð°Ý§A¤@¦¸ºI¨ú¦h¤Ö®æªº¼Æ¾Ú  ·|¤£·|¦³©µ¿ðªº°ÝÃD?
§Ú¥Î³Í°ò¤j¤T¤¸ ºI¨ú 24X300 ­Ó¼Æ¾Ú  ¦n¹³¤£¬O«Ü¶¶ ¦³¤°»ò¦n«Øij©O?

TOP

¦^´_ 51# c_c_lai


    §Ú¥u¬O·Q°Ñ¦Ò¤@¤U¦³¨S¦³§óí©wªºDDEµ{¦¡
   ²{¦b¤]¤£¥i¯à¯²¤@±ø±M½u (¨S¿ú)

¤j¤j  ¤U­±³o­Ó°ÝÃD½Ð¬Ý¤@¤U

  .Legend.Position = xlCorner                         ' ±N¹Ïªí¹Ï¥Ü±q¹Ïªí³Ì¤U¤è½Õ¾ã¨ì¹Ïªí¤§¥k¤W¨¤¦ì¸m

   xlCorner        §Ú§ä¤£¨ì³o­Ó°Ñ¼Æ¬O±q­þ¸Ì¨Óªº
  §ä¨ì³o­Ó  
   xlLegendPositionBottom -4107 ¹Ïªí¤U¤è
xlLegendPositionCorner 2 ¦ì©ó¹Ïªí®Ø½uªº¥k¤W¨¤
xlLegendPositionCustom -4161 ¦Û­q¦ì¸m
xlLegendPositionLeft -4131 ¹Ïªí¥ªÃä
xlLegendPositionRight -4152 ¹Ïªí¥kÃä
xlLegendPositionTop -4160 ¹Ïªí¤W¤è

§â xlCorner §ï¦¨¼Æ¦r(-4152) ¤§Ãþªº¦ì¸m´N¥i¥H§ïÅÜ  ¦ýxlCorner¬O±q­þ¸Ì±oª¾ªº

TOP

¦^´_ 51# c_c_lai


    ¦A¸É¥R¤@­Ó°ÝÃD
   ¨ä¥Lªº¼Æ¦C ¥i¥H¸òªÑ²¼³]©w¦¨¦P¤@­Ó®y¼Ð¶b¶Ü?
   §Ú§â.AxisGroup = 2   §ï¦¨ 1  ÁÙ¬O¤£¦æ

TOP

¦^´_ 55# c_c_lai


    ¨º­n«ç»ò«ü©w ¨ä¥Lªº¼Æ¦C¨ì ªÑ²¼¹Ïªº®y¼Ð¶b©O?

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD