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

[µo°Ý] (¤w¸Ñ¨M)¦p¦óÅý¥D°Æ¶bªº³Ì¤j­È¤Î³Ì¤p­È¤@¼Ë?

[µo°Ý] (¤w¸Ñ¨M)¦p¦óÅý¥D°Æ¶bªº³Ì¤j­È¤Î³Ì¤p­È¤@¼Ë?

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 16:52 ½s¿è

½Ð°Ý­n¦p¦ó³]©wÅý¥D°Æ¶bªº³Ì¤j­È¸ò³Ì¤p­È¤@¼Ë
¦³¨â¦U·Qªk
1.¥D¶bªº³Ì¤j­È³Ì¤p­È¦Û°Ê¦ý¬O°Æ¶bªº³Ì¤j­È¤Î³Ì¤p­È»P¥D¶b¬Û¦P
2.³Ì¤j­È¤Î³Ì¤p­È¥H¥D°Æ¶b¸ê®Æ§PÂ_¡A¨âÃä³]©w­n¨Ì¼Ë

²Ä¤GºØ¤£ª¾¹D¥i¤£¥i¦æ¡A¦]¬°­nµo°Ý·Q­n¶¶«K°Ý¨Ì¤U






¹Ï.rar (4.84 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¦^´_ 1# freeffly


        With ActiveSheet.ChartObjects("¹Ïªí 1").Chart
        With .Axes(xlValue, xlPrimary)
        k = .MinimumScale
        m = .MaximumScale
        n = .MinorUnit
        s = .MajorUnit
    End With
    With .Axes(xlValue, xlSecondary)
        .MinimumScale = k
        .MaximumScale = m
        .MinorUnit = n
        .MajorUnit = s
    End With
    End With
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ÁÂÁª©¥D
   ¤ñ·Q¹³¤¤ªºÂ²³æ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD