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

½Ð°Ý¦p¦ó±N¤w¦s¦b¤§´²§G¹ÏªºX¶b³Ì¤j»P³Ì¤p­È¦s¤JVBAµ{¦¡ÅܼƤ¤?

½Ð°Ý¦p¦ó±N¤w¦s¦b¤§´²§G¹ÏªºX¶b³Ì¤j»P³Ì¤p­È¦s¤JVBAµ{¦¡ÅܼƤ¤?

½Ð°Ý¦p¦ó±N¤w¦s¦b¤§´²§G¹ÏªºX¶b³Ì¤j»P³Ì¤p­È¦s¤JVBAµ{¦¡ÅܼƤ¤?

¦^´_ 1# sasser
¹ÏªíªºÄÝ©Ê:¥i¥Î¿ý»s¥¨¶°±oª¾
  1. Option Explicit
  2. Sub Ex()
  3.     Dim ³Ì¤j­È As Single, ³Ì¤p­È As Single
  4.     ³Ì¤j­È = ActiveSheet.ChartObjects(1).Chart.Axes(xlCategory).MaximumScale
  5.     ³Ì¤p­È = ActiveSheet.ChartObjects(1).Chart.Axes(xlCategory).MinimumScale
  6. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD