Note
ãã®ãã¼ã¸ã«ã¢ã¯ã»ã¹ããã«ã¯ãæ¿èªãå¿ è¦ã§ãã ãµã¤ã³ã¤ã³ã¾ãã¯ãã£ã¬ã¯ããªã®å¤æ´ã試ããã¨ãã§ãã¾ãã
ãã®ãã¼ã¸ã«ã¢ã¯ã»ã¹ããã«ã¯ãæ¿èªãå¿ è¦ã§ãã ãã£ã¬ã¯ããªã®å¤æ´ã試ããã¨ãã§ãã¾ãã
横æ£ã°ã©ãã¨ç¸¦æ£ã°ã©ã: 横æ£ã¾ãã¯ç¸¦æ£ã®å¹ ã«å¯¾ããå²åã¨ãã¦ãæ£ã¾ãã¯åã®ã¯ã©ã¹ã¿ã¼éã®ã¹ãã¼ã¹ãè¨å®ã¾ãã¯è¿ãã¾ãã
åã°ã©ãã¨åã°ã©ãã®æ¨ªæ£ã°ã©ã: ã°ã©ãã®ç¬¬ 1 ã»ã¯ã·ã§ã³ã¨ç¬¬ 2 ã»ã¯ã·ã§ã³ã®éã®ã¹ãã¼ã¹ãè¨å®ã¾ãã¯è¿ãã¾ãã èªã¿åã/æ¸ãè¾¼ã¿ãå¯è½ãª Long ã§ãã
æ§æ
å¼ãGapWidth
å¼ChartGroup ãªãã¸ã§ã¯ãã表ã夿°ã
注é
ãã®ããããã£ã«ä½¿ç¨ã§ããç¯å²ã¯ 5 ï½ 200 ã®å¤ã§ãã
ä¾
次ã®ä½¿ç¨ä¾ã¯ãChart1 ã®åã¯ã©ã¹ã¿ã¼éã®ã¹ãã¼ã¹ãåå¹ ã® 50% ã«è¨å®ãã¾ãã
Charts("Chart1").ChartGroups(1).GapWidth = 50
ãµãã¼ãã¨ãã£ã¼ãããã¯
Office VBA ã¾ãã¯ãã®èª¬ææ¸ã«é¢ããã質åããã£ã¼ãããã¯ãããã¾ããï¼ ãµãã¼ãã®åãæ¹ããã³ãã£ã¼ãããã¯ããå¯ãããã ãæ¹æ³ã®ã¬ã¤ãã³ã¹ã«ã¤ãã¦ã¯ãOffice VBA ã®ãµãã¼ãããã³ãã£ã¼ãããã¯ãåç §ãã¦ãã ããã