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

[µo°Ý] EXCEL 2007 VBAµLªk¾Þ§@³Q«OÅ@ªº¤u§@ªí¤¤ªº¹Ïªí

[µo°Ý] EXCEL 2007 VBAµLªk¾Þ§@³Q«OÅ@ªº¤u§@ªí¤¤ªº¹Ïªí

¨D§Uª©¤W«e½ú­Ì,
ªþ¥ó¤u§@ªí¤¤¦³¤@­Ó¹Ïªí,
³q¹LVBA³]©w¥L¼Æ­ÈX¶bªº³Ì¤j³Ì¤p­È,
µo²{¤@¥¹¤u§@ªí³Q«OÅ@,
¨Ï¥ÎChartObjects(1).Chart.Axes(xlCategory)ªº»y¥y´N·|¥X¿ù,
¨Ò¦p:"'MinimumScale' ¤èªk ('Axis' ª«¥ó) ¥¢±Ñ"µ¥µ¥,
¤u§@ªí¨ú®ø«OÅ@«á¤S«ì´_¥¿±`,
½s¿è®É¦b¤u§@ªí«OÅ@¿ï¶µ¤w¸g¦³¤Ä¿ï"½s¿èª«¥ó",
¦Ó¥B¦bEXCEL 2003ª©¤¤¬O¥i¥H¥¿±`¹B§@,
ÀɮצbEXCEL 2007ª©¨Ï¥Î«h¤£¦æ~
¤£ª¾¹D¬°¤°»ò·|³o¼Ë©O?

TestAxesScale.zip (8.73 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD