{"id":7624,"date":"2019-11-07T06:00:49","date_gmt":"2019-11-06T21:00:49","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=7624"},"modified":"2019-11-07T06:43:16","modified_gmt":"2019-11-06T21:43:16","slug":"excel%e3%81%ae%e3%82%b0%e3%83%a9%e3%83%95%e3%81%ae%e8%bb%b8%e3%81%ae%e6%9b%b8%e5%bc%8f%e8%a8%ad%e5%ae%9a%e3%81%a7%e3%83%8f%e3%83%9e%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=7624","title":{"rendered":"EXCEL\u306e\u30b0\u30e9\u30d5\u306e\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3067\u30cf\u30de\u308b"},"content":{"rendered":"\n<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306f VBA \u306e\u7f85\u91dd\u76e4\u3067\u3042\u308b\uff0e\u3057\u304b\u3057\u6642\u306b\u5f79\u306b\u7acb\u305f\u306a\u3044\u3053\u3068\u304c\u3042\u308b\uff0e\u4eca\u56de\u306f\u30b0\u30e9\u30d5\u306e\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3067\u30cf\u30de\u3063\u305f\u7d4c\u7def\u3092\u5099\u5fd8\u9332\u3068\u3057\u3066\u8a18\u3057\u3066\u304a\u304f\uff0e<\/p>\n<p><!--more--><\/p>\n<h3>\u30de\u30af\u30ed\u306e\u8a18\u9332\u304b\u3089<\/h3>\n<p>\u3000VBA \u306e\u6319\u52d5\u3092\u8abf\u3079\u308b\u306b\u306f\u30de\u30af\u30ed\u306e\u8a18\u9332\u304b\u3089\u5165\u308b\u306e\u304c\u666e\u901a\u3067\u3042\u308b\uff0e\u4f7f\u308f\u308c\u3066\u3044\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u7279\u5b9a\u3057\uff0c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u304b\u3089\u30d7\u30ed\u30d1\u30c6\u30a3\u3068\u30e1\u30bd\u30c3\u30c9\u3092\u8abf\u3079\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u9593\u306e\u7e4b\u304c\u308a\u3092\u4e39\u5ff5\u306b\u7d10\u89e3\u3044\u3066\u3044\u304f\uff0e\u9762\u5012\u3067\u3082\u3053\u306e\u4f5c\u696d\u306f\u6b20\u304b\u305b\u306a\u3044\uff0e<\/p>\n<h4>\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9<\/h4>\n<p>\u3000Y \u8ef8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a&#8230;\u300d\u3092\u9078\u3076\uff0e<\/p>\n<figure id=\"attachment_7793\" aria-describedby=\"caption-attachment-7793\" style=\"width: 273px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7793\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/20.png\" alt=\"Y\u8ef8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u3092\u9078\u3076\" width=\"273\" height=\"280\"><\/a><figcaption id=\"caption-attachment-7793\" class=\"wp-caption-text\">Y\u8ef8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u3092\u9078\u3076<\/figcaption><\/figure>\n<h4>\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a<\/h4>\n<p>\u3000\u300c\u8ef8\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u30d1\u30cd\u30eb\u304c\u958b\u304f\uff0e\u3053\u3053\u306f\u30c7\u30fc\u30bf\u306e\u672c\u8cea\u306b\u304b\u304b\u308f\u308b\u4f5c\u696d\u3068\u306a\u308b\uff0e\u4e0b\u56f3\u306b Axis \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u8a18\u3057\u3066\u304a\u304f\uff0e\u3053\u3053\u3067\u306f\u8ef8\u306e\u6700\u5c0f\u5024\uff0c\u6700\u5927\u5024\uff0c\u5358\u4f4d\uff0c\u6a2a\u8ef8\u3068\u306e\u4ea4\u70b9\uff0c\u8868\u793a\u5358\u4f4d\uff0c\u5bfe\u6570\u76ee\u76db\u306e\u8868\u793a\uff0c\u8ef8\u306e\u53cd\u8ee2\u306b\u3064\u3044\u3066\u8a2d\u5b9a\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_7795\" aria-describedby=\"caption-attachment-7795\" style=\"width: 458px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-7795\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/21-458x1024.png\" alt=\"\u300c\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u306e\u300c\u8ef8\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u3067\u6700\u5c0f\u5024\uff0c\u6700\u5927\u5024\uff0c\u5358\u4f4d\uff0c\u6a2a\u8ef8\u3068\u306e\u4ea4\u70b9\uff0c\u8868\u793a\u5358\u4f4d\uff0c\u5bfe\u6570\u76ee\u76db\u306e\u8868\u793a\uff0c\u8ef8\u306e\u53cd\u8ee2\u306b\u3064\u3044\u3066\u8a2d\u5b9a\u3059\u308b\" width=\"458\" height=\"1024\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/21-458x1024.png 458w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/21-134x300.png 134w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/21.png 560w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/a><figcaption id=\"caption-attachment-7795\" class=\"wp-caption-text\">\u300c\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u306e\u300c\u8ef8\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u3067\u6700\u5c0f\u5024\uff0c\u6700\u5927\u5024\uff0c\u5358\u4f4d\uff0c\u6a2a\u8ef8\u3068\u306e\u4ea4\u70b9\uff0c\u8868\u793a\u5358\u4f4d\uff0c\u5bfe\u6570\u76ee\u76db\u306e\u8868\u793a\uff0c\u8ef8\u306e\u53cd\u8ee2\u306b\u3064\u3044\u3066\u8a2d\u5b9a\u3059\u308b<\/figcaption><\/figure>\n<h4>\u8ef8\u306e\u30d5\u30a9\u30f3\u30c8\u306e\u8a2d\u5b9a<\/h4>\n<p>\u3000Y \u8ef8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u30d5\u30a9\u30f3\u30c8&#8230;\u300d\u3092\u9078\u3076\uff0e<\/p>\n<figure id=\"attachment_7799\" aria-describedby=\"caption-attachment-7799\" style=\"width: 272px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7799\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/07.png\" alt=\"Y\u8ef8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u30d5\u30a9\u30f3\u30c8...\u300d\u3092\u9078\u3076\" width=\"272\" height=\"280\"><\/a><figcaption id=\"caption-attachment-7799\" class=\"wp-caption-text\">Y\u8ef8\u3092\u9078\u629e\u3057\u305f\u72b6\u614b\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u30d5\u30a9\u30f3\u30c8&#8230;\u300d\u3092\u9078\u3076<\/figcaption><\/figure>\n<p>\u3000\u300c\u30d5\u30a9\u30f3\u30c8\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u958b\u304f\uff0e\u8272\u304c\u767d\u8272\u3067\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3059\u308b\u3060\u3051\u306a\u306e\u3067\u7279\u306b\u8a2d\u5b9a\u306f\u3057\u306a\u3044\uff0e<\/p>\n<figure id=\"attachment_7807\" aria-describedby=\"caption-attachment-7807\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/06.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-7807\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/06-1024x822.png\" alt=\"\u300c\u30d5\u30a9\u30f3\u30c8\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\" width=\"525\" height=\"421\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/06.png 1024w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/06-300x241.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/06-768x617.png 768w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-7807\" class=\"wp-caption-text\">\u300c\u30d5\u30a9\u30f3\u30c8\u300d\u30c0\u30a4\u30a2\u30ed\u30b0<\/figcaption><\/figure>\n<h4>\u6700\u521d\u306e\u30b3\u30fc\u30c9\u304c\u52d5\u304b\u306a\u3044\uff01<\/h4>\n<p>\u3000\u4e0b\u306e\u30b3\u30fc\u30c9\u304c\u30de\u30af\u30ed\u306e\u8a18\u9332\u3067\u5f97\u3089\u308c\u305f\u3082\u306e\u3067\u3042\u308b\uff0e\u91cd\u8981\u306a\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u9593\u306e\u7e4b\u304c\u308a\u306f 3 \u884c\u76ee\u3068 4 \u884c\u76ee\uff0c\u3055\u3089\u306b 12 \u884c\u76ee\u306b\u3042\u308a\u305d\u3046\u3060\uff0e<\/p>\n<p>\u3000\u5b9f\u969b\u306b\u306f 4 \u884c\u76ee\u304b\u3089 11 \u884c\u76ee\u3067\u306f\u8ef8\u306e\u30d5\u30a9\u30f3\u30c8\u306e\u8272\u3092\u5909\u66f4\u3057\uff0c12 \u884c\u76ee\u304b\u3089 15 \u884c\u76ee\u3067\u306f\u8ef8\u306e\u30d5\u30a9\u30f3\u30c8\u3092\u5909\u66f4\u3057\u3066\u3044\u308b\uff0e<\/p>\n<pre class=\"\">Sub Macro1()\n    ActiveSheet.ChartObjects(\"\u30b0\u30e9\u30d5 1\").Activate\n    ActiveChart.Axes(xlValue).Select\n    With Selection.Format.TextFrame2.TextRange.Font.Fill\n        .Visible = msoTrue\n        .ForeColor.ObjectThemeColor = msoThemeColorBackground1\n        .ForeColor.TintAndShade = 0\n        .ForeColor.Brightness = 0\n        .Transparency = 0\n        .Solid\n    End With\n    With Selection.Format.TextFrame2.TextRange.Font\n        .BaselineOffset = 0\n        .Name = \"Times New Roman\"\n    End With\nEnd Sub\n<\/pre>\n<p>\u3000\u3057\u304b\u3057\uff0c\u3053\u306e\u30b3\u30fc\u30c9\u3092\u305d\u306e\u307e\u307e\u5b9f\u884c\u3057\u3066\u3082\u5b9f\u884c\u6642\u30a8\u30e9\u30fc\u304c\u8fd4\u3063\u3066\u304f\u308b\uff0e<\/p>\n<figure id=\"attachment_7647\" aria-describedby=\"caption-attachment-7647\" style=\"width: 427px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/00-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7647\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/00-1.png\" alt=\"\u5b9f\u884c\u6642\u30a8\u30e9\u30fc'-2147467259(80004005)' 'TextFrame2' \u30e1\u30bd\u30c3\u30c9\u306f\u5931\u6557\u3057\u307e\u3057\u305f\uff0e'ChartFormat' \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\" width=\"427\" height=\"194\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/00-1.png 427w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/00-1-300x136.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/a><figcaption id=\"caption-attachment-7647\" class=\"wp-caption-text\">\u5b9f\u884c\u6642\u30a8\u30e9\u30fc&#8217;-2147467259(80004005)&#8217; &#8216;TextFrame2&#8242; \u30e1\u30bd\u30c3\u30c9\u306f\u5931\u6557\u3057\u307e\u3057\u305f\uff0e&#8217;ChartFormat&#8217; \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/figcaption><\/figure>\n<p>\u3000\u30c7\u30d0\u30c3\u30b0\u753b\u9762\u306b\u5207\u308a\u66ff\u308f\u308a\uff0c\u30a8\u30e9\u30fc\u306e\u51fa\u305f\u30b3\u30fc\u30c9\u304c\u30cf\u30a4\u30e9\u30a4\u30c8\u3055\u308c\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_7649\" aria-describedby=\"caption-attachment-7649\" style=\"width: 489px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7649\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/01.png\" alt=\"\u30a8\u30e9\u30fc\u306e\u51fa\u305f\u30b3\u30fc\u30c9\u304c\u30cf\u30a4\u30e9\u30a4\u30c8\u3055\u308c\u3066\u3044\u308b\" width=\"489\" height=\"242\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/01.png 489w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/01-300x148.png 300w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/a><figcaption id=\"caption-attachment-7649\" class=\"wp-caption-text\">\u30a8\u30e9\u30fc\u306e\u51fa\u305f\u30b3\u30fc\u30c9\u304c\u30cf\u30a4\u30e9\u30a4\u30c8\u3055\u308c\u3066\u3044\u308b<\/figcaption><\/figure>\n<h3>\u554f\u984c\u306e\u5207\u308a\u5206\u3051\u306b\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4e00\u3064\u3065\u3064\u5207\u308a\u5206\u3051\u308b<\/h3>\n<p>\u3000\u5b9f\u884c\u6642\u30a8\u30e9\u30fc\u306f\u5927\u62b5\u306e\u5834\u5408\uff0c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u53d6\u5f97\u304c\u3046\u307e\u304f\u884c\u3063\u3066\u3044\u306a\u3044\u6642\u306b\u8d77\u3053\u308a\u3084\u3059\u3044\uff0e\u305d\u3053\u3067\uff0cTypeName \u95a2\u6570\u3092\u4f7f\u3063\u3066\u3069\u3053\u3067\u53d6\u5f97\u306b\u5931\u6557\u3057\u3066\u3044\u308b\u306e\u304b\u5207\u308a\u5206\u3051\u308b\u4f5c\u696d\u306b\u5165\u308b\uff0e<\/p>\n<p>\u3000\u6700\u5f8c\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304b\u3089\u59cb\u3081\u308b\u4eba\u3068\uff0c\u6700\u521d\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304b\u3089\u59cb\u3081\u308b\u4eba\u304c\u3044\u308b\uff0e\u3069\u3061\u3089\u3067\u3082\u69cb\u308f\u306a\u3044\u304c\uff0c\u4ffa\u306f\u6700\u521d\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304b\u3089\u59cb\u3081\u308b\u65b9\u3060\uff0e<\/p>\n<h4>Select \u3068 Selection \u306f\u6d88\u3059<\/h4>\n<figure id=\"attachment_7655\" aria-describedby=\"caption-attachment-7655\" style=\"width: 511px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/02-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7655\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/02-1.png\" alt=\".Select \u3068 Selection \u306f\u6d88\u3059\" width=\"511\" height=\"244\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/02-1.png 511w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/02-1-300x143.png 300w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/a><figcaption id=\"caption-attachment-7655\" class=\"wp-caption-text\">.Select \u3068 Selection \u306f\u6d88\u3059<\/figcaption><\/figure>\n<p>\u3000\u30de\u30af\u30ed\u306e\u8a18\u9332\u306b\u7279\u6709\u306e\u8a18\u8ff0\u3060\uff0e\u982d\u306b With \u3092\u3064\u3051\u3066\uff0c\u3053\u3053\u306f\u3055\u3063\u3055\u3068\u6d88\u3057\u3066\u3057\u307e\u3046\uff0e\u3053\u308c\u306f\u5f62\u5f0f\u7684\u4f5c\u696d\u3060\uff0e<\/p>\n<figure id=\"attachment_7657\" aria-describedby=\"caption-attachment-7657\" style=\"width: 576px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/03-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7657\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/03-3.png\" alt=\"Select \u3068 Selection \u3092\u6d88\u3057\uff0cWith \u53e5\u30671\u884c\u306e\u30b3\u30fc\u30c9\u306b\u66f8\u304d\u63db\u3048\u308b\" width=\"576\" height=\"231\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/03-3.png 576w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/03-3-300x120.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/a><figcaption id=\"caption-attachment-7657\" class=\"wp-caption-text\">Select \u3068 Selection \u3092\u6d88\u3057\uff0cWith \u53e5\u30671\u884c\u306e\u30b3\u30fc\u30c9\u306b\u66f8\u304d\u63db\u3048\u308b<\/figcaption><\/figure>\n<pre class=\"\">With ActiveChart.Axes(xlValue).Format.TextFrame2.TextRange.Font.Fill\n<\/pre>\n<h4>TypeName \u95a2\u6570\u3067\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u304b\u8abf\u3079\u308b<\/h4>\n<p>\u3000\u4e0a\u8a18\u30b3\u30fc\u30c9\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u6570\u306f 7 \u500b\u3042\u308b\uff0e\u305d\u3053\u3067 TypeName \u95a2\u6570\u3092 7 \u500b\u4e26\u3079\u308b\uff0e<\/p>\n<pre class=\"\">Sub TEST1()\nActiveSheet.ChartObjects(\"\u30b0\u30e9\u30d5 1\").Activate\n\nDebug.Print TypeName()\nDebug.Print TypeName()\nDebug.Print TypeName()\nDebug.Print TypeName()\nDebug.Print TypeName()\nDebug.Print TypeName()\nDebug.Print TypeName()\nEnd Sub\n<\/pre>\n<p>\u3000\u6b21\u306b\u6700\u521d\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304b\u3089\u59cb\u3081\u3066\uff0c\u4e00\u3064\u305a\u3064\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u5897\u3084\u3057\u3066\u3044\u304f\uff0e\u6b21\u306e\u3088\u3046\u306b\u306a\u308b\uff0e<\/p>\n<pre class=\"\">Sub TEST1()\nActiveSheet.ChartObjects(\"\u30b0\u30e9\u30d5 1\").Activate\n\nDebug.Print TypeName(ActiveChart)\nDebug.Print TypeName(ActiveChart.Axes(xlValue))\nDebug.Print TypeName(ActiveChart.Axes(xlValue).Format)\nDebug.Print TypeName(ActiveChart.Axes(xlValue).Format.TextFrame2)\nDebug.Print TypeName(ActiveChart.Axes(xlValue).Format.TextFrame2.TextRange)\nDebug.Print TypeName(ActiveChart.Axes(xlValue).Format.TextFrame2.TextRange.Font)\nDebug.Print TypeName(ActiveChart.Axes(xlValue).Format.TextFrame2.TextRange.Font.Fill)\nEnd Sub\n<\/pre>\n<h4>\u7d50\u679c<\/h4>\n<p>\u30007 \u884c\u76ee\u306e TextFrame2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u53d6\u5f97\u306b\u5931\u6557\u3059\u308b\uff0e<\/p>\n<pre>Chart\nAxis\nChartFormat\n<\/pre>\n<figure id=\"attachment_7668\" aria-describedby=\"caption-attachment-7668\" style=\"width: 669px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7668\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/04.png\" alt=\"ChartFormat \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u307e\u3067\u306f\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u304c TextFrame2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u53d6\u5f97\u306b\u5931\u6557\u3057\u3066\u3044\u308b\" width=\"669\" height=\"181\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/04.png 669w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/08\/04-300x81.png 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><\/a><figcaption id=\"caption-attachment-7668\" class=\"wp-caption-text\">ChartFormat \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u307e\u3067\u306f\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u304c TextFrame2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u53d6\u5f97\u306b\u5931\u6557\u3057\u3066\u3044\u308b<\/figcaption><\/figure>\n<h4>ChartFormat \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068 TextFrame2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u7e4b\u304c\u3089\u306a\u3044\uff01<\/h4>\n<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u304b\u3089\u306f\u78ba\u304b\u306b\u7e4b\u304c\u3063\u3066\u304a\u308a\uff0c\u30b3\u30f3\u30d1\u30a4\u30eb\u30a8\u30e9\u30fc\u3082\u767a\u751f\u3057\u3066\u3044\u306a\u3044\u306e\u306b\uff0c\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u30a8\u30e9\u30fc\u3068\u306a\u308b\uff0e\u4f55\u304b\u304c\u304a\u304b\u3057\u3044\uff0e<\/p>\n<p>\u3000\u4f55\u5ea6\u304b\u8a66\u884c\u932f\u8aa4\u3057\u3066\u307f\u305f\u304c\uff0c\u3069\u3046\u3082\u3053\u306e\u7d4c\u8def\u306f\u884c\u304d\u6b62\u307e\u308a\u306e\u3088\u3046\u3067\u57d2\u304c\u3042\u304b\u306a\u3044\uff0e<\/p>\n<p>\u3000\u305d\u3082\u305d\u3082 VBA \u3067\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3059\u308b\u306e\u306b\u552f\u4e00\u306e\u7d4c\u8def\u3057\u304b\u5b58\u5728\u3057\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u306f\u307e\u308c\u3067\uff0c\u666e\u901a\u306f\u3044\u304f\u3064\u304b\u306e\u8907\u6570\u306e\u7d4c\u8def\u304c\u5b58\u5728\u3059\u308b\uff0e\u4ed6\u306e\u7d4c\u8def\u304b\u3089\u8fbf\u308c\u306a\u3044\u304b\uff1f\u3053\u3046\u3044\u3046\u6642\u306f\u691c\u7d22\u3057\u3066\u307f\u308b\uff0e<\/p>\n<h3>Google \u691c\u7d22<\/h3>\n<p>\u3000\u691c\u7d22\u30ad\u30fc\u30ef\u30fc\u30c9\u306f\u3082\u3061\u308d\u3093 &#8220;ChartFormat&#8221; &#8220;TextFrame2&#8221; \u306e AND \u691c\u7d22\u3067\u3042\u308b\uff0e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u3067\u56f2\u3046\u306e\u306f\u5b8c\u5168\u4e00\u81f4\u3092\u610f\u56f3\u3057\u3066\u3044\u308b\uff0e\u3069\u3046\u3084\u3089\u4ed6\u306b\u3082\u610f\u56f3\u305b\u3056\u308b\u30a8\u30e9\u30fc\u3067\u60a9\u3093\u3067\u3044\u308b\u4eba\u304c\u3044\u308b\u3089\u3057\u3044\u3053\u3068\u304c\u5206\u304b\u308b\uff0e<\/p>\n<p><a href=\"https:\/\/answers.microsoft.com\/ja-jp\/msoffice\/forum\/all\/exxcel%E3%81%A7%E4%BD%9C%E6%88%90%E3%81%97\/60d30565-2aa3-4895-8270-16682530c20e\" target=\"_blank\" rel=\"noopener noreferrer\">Excel\u3067\u4f5c\u6210\u3057\u305f\u30b0\u30e9\u30d5\u306e\u7e26\u8ef8,\u6a2a\u8ef8\u306e\u76ee\u76db\u308a\uff08\u6570\u5024\uff09\u306e\u30d5\u30a9\u30f3\u30c8\u3092\u5909\u3048\u308b\u30de\u30af\u30ed\u304c\u3046\u307e\u304f\u3044\u304b\u306a\u3044<\/a><\/p>\n<p><a href=\"http:\/\/waji-mart.com\/homeandabroad\/excelvba%E3%81%A7%E3%82%B0%E3%83%A9%E3%83%95%E3%81%AE%E3%82%B5%E3%82%A4%E3%82%BA%E3%82%84%E3%83%95%E3%82%A9%E3%83%B3%E3%83%88%E7%A8%AE%E9%A1%9E%E3%82%92%E5%A4%89%E6%9B%B4\/\" target=\"_blank\" rel=\"noopener noreferrer\">ExcelVBA\u3067\u30b0\u30e9\u30d5\u306e\u30b5\u30a4\u30ba\u3084\u30d5\u30a9\u30f3\u30c8\u7a2e\u985e\u3092\u5909\u66f4<\/a><\/p>\n<h4>Chart \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068 ChartFormat \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u9593\u306b\u3044\u305f\u4f0f\u5175\uff0c\u305d\u308c\u306f ChartArea \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h4>\n<p>\u3000\u898b\u843d\u3068\u3057\u3066\u3044\u305f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\uff0e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u304b\u3089\u306f\u898b\u3064\u3051\u3089\u308c\u306a\u304b\u3063\u305f\uff0e\u3053\u308c\u3092\u9593\u306b\u5165\u308c\u308b\u3053\u3068\u3067\u5b9f\u884c\u6642\u30a8\u30e9\u30fc\u304c\u89e3\u6d88\u3055\u308c\u305f\uff0e<\/p>\n<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f<\/p>\n<pre class=\"\">Chart.ChartArea.ChartFormat.TextFrame2.TextRange2.Font2.FillFormat<\/pre>\n<p>&nbsp;\u3068\u7e4b\u304c\u308b\uff0e<\/p>\n<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u304b\u3089\u60f3\u50cf\u3067\u304d\u308b\u3088\u3046\u306b\uff0c\u3053\u306e\u8a2d\u5b9a\u306f\u30b0\u30e9\u30d5\u5168\u4f53\u306b\u53ca\u3076\uff0e\u8ef8\u3092\u7279\u5b9a\u3057\u3066\u3044\u306a\u3044\u304b\u3089\u3067\u3042\u308b\uff0e<\/p>\n<h4>TickLabels \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h4>\n<p>\u3000\u8ef8\u3092\u7279\u5b9a\u3057\u3066\u66f8\u5f0f\u8a2d\u5b9a\u3057\u305f\u3044\u5834\u5408\u306b\u306f TickLabels \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3059\u308b\uff0e<\/p>\n<pre class=\"\">Chart.ChartFormat.Axis.TickLabels.Font.ColorFormat<\/pre>\n<p>\u3068\u7e4b\u304c\u308b\uff0e<\/p>\n<h4>\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9<\/h4>\n<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u9806\u306b\u3064\u306a\u3044\u3067\u3044\u304f\uff0e\u78ba\u8a8d\u306e\u305f\u3081\u306b\uff0c\u53d6\u5f97\u3059\u308b\u305f\u3073\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u7a2e\u985e\u3092\u30a4\u30df\u30c7\u30a3\u30a8\u30a4\u30c8\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u51fa\u529b\u3057\u3066\u3044\u308b\uff0e\u5ba3\u8a00\u3057\u3066\u3044\u308b\u5909\u6570\u304c\u3059\u3079\u3066 Object \u578b\u3067\u3042\u308b\u3053\u3068\u306b\u6ce8\u610f\u3055\u308c\u305f\u3044\uff0e<\/p>\n<pre class=\"\">Sub TEST()\nDim myCht       As Object\n\nDim myFmt       As Object\nDim myAxis      As Object\nDim myTckLbl    As Object\nDim myFont      As Object\n\nDim myChtArea   As Object\nDim myFmt2      As Object\nDim myTxtFrm    As Object\nDim myObj       As Object\n\nSet myCht = Worksheets(\"\u6563\u5e03\u56f3\").ChartObjects(1).Chart\nDebug.Print TypeName(myCht)\n\nSet myFmt = myCht.Axes(xlValue).Format\nDebug.Print TypeName(myFmt)\n\nSet myAxis = myCht.Axes(xlValue)\nDebug.Print TypeName(myAxis)\n\nSet myTckLbl = myAxis.TickLabels\nDebug.Print TypeName(myTckLbl)\n\nSet myFont = myTckLbl.Font\nDebug.Print TypeName(myFont)\n\nDebug.Print TypeName(myFont.Color), myFont.Color\n\n'==============================\n\nSet myChtArea = myCht.ChartArea\nDebug.Print TypeName(myChtArea)\n\nSet myFmt2 = myChtArea.Format\nDebug.Print TypeName(myFmt2)\n\nSet myTxtFrm = myFmt2.TextFrame2\nDebug.Print TypeName(myTxtFrm)\n\nSet myObj = myTxtFrm.TextRange\nDebug.Print TypeName(myObj)\n\nSet myObj = myObj.Font\nDebug.Print TypeName(myObj)\n\nSet myObj = myObj.Fill\nDebug.Print TypeName(myObj)\n\nEnd Sub<\/pre>\n<h4>\u30c6\u30b9\u30c8\u7d50\u679c<\/h4>\n<p>\u3000\u9593\u9055\u3044\u306a\u304f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u3059\u3079\u3066\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u308b\uff0e<\/p>\n<pre class=\"\">Chart\nChartFormat\nAxis\nTickLabels\nFont\nLong           5855577 \nChartArea\nChartFormat\nTextFrame2\nTextRange2\nFont2\nFillFormat\n<\/pre>\n<h3>\u300eEXCEL VBA\u3067\u304d\u308b\u5927\u4e8b\u5178\u300f\u3067\u767a\u898b<\/h3>\n<p>\u3000<a href=\"https:\/\/amzn.to\/30pr5Re\" target=\"_blank\" rel=\"noopener noreferrer\">EXCEL VBA\u3067\u304d\u308b\u5927\u4e8b\u5178<\/a> \u306e\u300c\u30b0\u30e9\u30d5\u306e\u8ef8\u3092\u8a2d\u5b9a\u3059\u308b\u306b\u306f (p678)\u300d\u306b\u8a18\u8ff0\u304c\u3042\u3063\u305f\uff0eChart \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068 Axis \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u306e\u9593\u306b ChartFormat \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u306a\u3044\u306e\u304c\u6c17\u306b\u306a\u308b\uff0e<\/p>\n<pre class=\"\">Chart.Axis.TickLabels<\/pre>\n<h4>\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u305d\u306e2<\/h4>\n<p>\u3000\u6c17\u306b\u306a\u308b\u306e\u3067\u30c6\u30b9\u30c8\u3057\u3066\u307f\u308b\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true\" title=\"\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\uff12\">Sub TEST2()\nDim myCht   As Chart\nSet myCht = ActiveSheet.ChartObjects(1).Chart\n\nDebug.Print TypeName(myCht.Axes(xlValue).TickLabels), myCht.Axes(xlValue).TickLabels.Orientation\nDebug.Print TypeName(myCht.Axes(xlValue).TickLabels.Font), myCht.Axes(xlValue).TickLabels.Font.Name\n\nEnd Sub\n<\/pre>\n<p>\u3000\u3069\u3046\u3084\u3089\u53d6\u5f97\u3067\u304d\u3066\u3044\u308b\u3088\u3046\u3060\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true\">TickLabels    -4105 \nFont          \u6e38\u30b4\u30b7\u30c3\u30af<\/pre>\n<h3>\u518d\u3073\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306b\u623b\u308b<\/h3>\n<h4>TickLabels \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h4>\n<p>\u3000TickLabels \u306f\u30b0\u30e9\u30d5\u8ef8\u306e\u76ee\u76db\u308a\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\uff0e\u4e0b\u8a18\u306f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u8abf\u3079\u305f\u30e1\u30f3\u30d0\u30fc\u306e\u4e00\u89a7\u3067\u3042\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 414px;\">\n<tbody>\n<tr style=\"height: 23px;\">\n<th style=\"width: 33.3333%; height: 23px;\">CLASS<\/th>\n<th style=\"width: 33.3333%; height: 23px;\">MEMBER<\/th>\n<th style=\"width: 33.3333%; height: 23px;\">Type of Return<\/th>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">TickLabels<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\" width=\"311\">Alignment<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\" width=\"208\">Long<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Application<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Application<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Creator<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlCreator<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Delete<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Function<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Depth<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Long<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>Font<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Font<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Format<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">ChartFormat<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MultiLevel<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Name<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">String<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">NumberFormat<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">String<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">NumberFormatLinked<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">NumberFormatLocal<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Variant<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Offset<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Long<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Orientation<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTickLabelOrientation<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Parent<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Object<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">ReadingOrder<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Long<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Select<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Function<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>Axis \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h4>\n<p>\u3000\u30b0\u30e9\u30d5\u306e\u8ef8\u3092\u64cd\u4f5c\u3059\u308b\u306b\u306f Axis \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3059\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 93.2136%; height: 1219px;\">\n<tbody>\n<tr style=\"height: 23px;\">\n<th style=\"width: 33.3333%; height: 23px;\">CLASS<\/th>\n<th style=\"width: 33.3333%; height: 23px;\">MEMBER<\/th>\n<th style=\"width: 33.3333%; height: 23px;\">Type of Return<\/th>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">Axis<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\" width=\"311\">AxisBetweenCategories<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\" width=\"208\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">AxisGroup<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlAxisGroup<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">AxisTitle<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">AxisTitle<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">BaseUnit<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTimeUnit<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">BaseUnitIsAuto<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Border<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Border<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">CategoryNames<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Variant<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">CategorySortOrder<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlCategorySortOrder<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">CategoryType<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlCategoryType<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Creator<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlCreator<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>Crosses<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlAxisCrosses<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>CrossesAt<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Delete<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Function<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">DisplayUnit<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlDisplayUnit<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">DisplayUnitCustom<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">DisplayUnitLabel<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">DisplayUnitLabel<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>Format<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">ChartFormat<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">GetProperty<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Function<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">HasDisplayUnitLabel<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">HasMajorGridlines<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">HasMinorGridlines<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">HasTitle<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Height<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Left<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">LogBase<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>MajorGridlines<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Gridlines<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MajorTickMark<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTickMark<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MajorUnit<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MajorUnitIsAuto<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MajorUnitScale<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTimeUnit<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>MaximumScale<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MaximumScaleIsAuto<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>MinimumScale<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MinimumScaleIsAuto<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MinorGridlines<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Gridlines<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MinorTickMark<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTickMark<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MinorUnit<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MinorUnitIsAuto<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">MinorUnitScale<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTimeUnit<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Parent<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Object<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">ReversePlotOrder<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>ScaleType<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlScaleType<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Select<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Function<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">SetProperty<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Sub<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">TickLabelPosition<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlTickLabelPosition<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>TickLabels<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">TickLabels<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">TickLabelSpacing<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Long<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">TickLabelSpacingIsAuto<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Boolean<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">TickMarkSpacing<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Long<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Top<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\"><strong>Type<\/strong><\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">XlAxisType<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.3333%; height: 23px;\">&nbsp;<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Width<\/td>\n<td style=\"font-weight: 400; width: 33.3333%; height: 23px;\">Double<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>\u8ef8\u306e\u4ea4\u70b9\u306f Axis.Crosses \u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u8a2d\u5b9a\u3059\u308b<\/h4>\n<p>\u3000\u30de\u30af\u30ed\u306e\u8a18\u9332\u3060\u3051\u3067\u306f\u6c17\u304c\u3064\u304b\u306a\u3044\u7f60\u306e\u4e00\u3064\u3067\u3042\u308b\uff0e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3092\u4e39\u5ff5\u306b\u898b\u76f4\u3057\u3066\u6c17\u304c\u3064\u3044\u305f\uff0e<\/p>\n<p>\u3000\u30b0\u30e9\u30d5\u306b\u3088\u3063\u3066\u306f X \u8ef8\u3092\u4e0a\u7aef\u306b\u5bc4\u305b\u305f\u3044\u3068\u304b Y \u8ef8\u3092\u5de6\u7aef\u306b\u5bc4\u305b\u305f\u3044\u3068\u304b\u3044\u3046\u8981\u671b\u3082\u3042\u308b\u3060\u308d\u3046\uff0e\u305d\u306e\u6642\u306f\u3053\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u8a2d\u5b9a\u3059\u308b\u306e\u3067\u3042\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<th style=\"width: 20%;\">MEMBER<\/th>\n<th style=\"width: 10%;\">VALUE<\/th>\n<th style=\"width: 70%;\">Description<\/th>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400; width: 20%;\" width=\"294\">xlAxisCrossesAutomatic<\/td>\n<td style=\"font-weight: 400; width: 10%;\" width=\"93\">-4105<\/td>\n<td style=\"width: 70%;\">\u4ea4\u5dee\u3059\u308b\u70b9\u306f\u81ea\u52d5<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400; width: 20%;\">xlAxisCrossesCustom<\/td>\n<td style=\"font-weight: 400; width: 10%;\">-4114<\/td>\n<td style=\"width: 70%;\">CrossesAt\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u5024\u3067\u4ea4\u5dee<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400; width: 20%;\">xlAxisCrossesMaximum<\/td>\n<td style=\"font-weight: 400; width: 10%;\">2<\/td>\n<td style=\"width: 70%;\">\u6700\u5927\u5024\u3067\u4ea4\u5dee<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400; width: 20%;\">xlAxisCrossesMinimum<\/td>\n<td style=\"font-weight: 400; width: 10%;\">4<\/td>\n<td style=\"width: 70%;\">\u6700\u5c0f\u5024\u3067\u4ea4\u5dee<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>\u5bfe\u6570\u8ef8\u306f Axis.ScaleType \u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u8a2d\u5b9a\u3059\u308b<\/h4>\n<p>\u3000\u8ef8\u3092\u7dda\u5f62\u3067\u8868\u793a\u3059\u308b\u304b\u5bfe\u6570\u3067\u8868\u793a\u3059\u308b\u304b\u306f\u3053\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u8a2d\u5b9a\u3059\u308b\uff0e<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<th style=\"width: 33.3333%;\">MEMBER<\/th>\n<th style=\"width: 33.3333%;\">VALUE<\/th>\n<th style=\"width: 33.3333%;\">Description<\/th>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400; width: 33.3333%;\" width=\"294\">xlScaleLinear<\/td>\n<td style=\"font-weight: 400; width: 33.3333%;\" width=\"93\">-4132<\/td>\n<td style=\"font-weight: 400; width: 33.3333%;\" width=\"435\">Linear<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400; width: 33.3333%;\">xlScaleLogarithmic<\/td>\n<td style=\"font-weight: 400; width: 33.3333%;\">-4133<\/td>\n<td style=\"font-weight: 400; width: 33.3333%;\">Logarithmic<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Font \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068 Font2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h3>\n<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u8abf\u3079\u3066\u307f\u308b\u3068\uff0c\u4e21\u8005\u306e\u9055\u3044\u304c\u4f55\u3068\u306a\u304f\u5206\u304b\u3063\u3066\u304f\u308b\uff0eFont \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u307b\u3068\u3093\u3069\u304c Variant \u578b\u3067\u3042\u308b\u306e\u306b\u5bfe\u3057\u3066\uff0cFont2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u306f\u578b\u304c\u6c7a\u307e\u3063\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000\u6050\u3089\u304f\u521d\u671f\u306b\u5b9f\u88c5\u3057\u305f Font \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u4ed5\u69d8\u3092\u5909\u66f4\u3067\u304d\u305a\u306b\uff0c\u65b0\u3057\u304f Font2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308b\u3053\u3068\u306b\u3057\u305f\u306e\u3060\u308d\u3046\uff0e\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u6570\u3060\u3051\u3067\u3082 Font2 \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c 36 \u500b\u306b\u5bfe\u3057\u3066 Font \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f 18 \u500b\u3057\u304b\u306a\u3044\uff0e<\/p>\n<p>\u3000\u30d5\u30a9\u30f3\u30c8\u306b\u3064\u3044\u3066\u306f\u5f8c\u65e5\u5225\u8a18\u4e8b\u3067\u53d6\u308a\u4e0a\u3052\u308b\u3053\u3068\u306b\u3059\u308b\uff0e<\/p>\n<h3>\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u305d\u306e3<\/h3>\n<p>\u3000\u3053\u308c\u307e\u3067\u898b\u3066\u304d\u305f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30e1\u30f3\u30d0\u30fc\u3092\u51fa\u529b\u3057\u3066\u3044\u308b\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true \" title=\"\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\uff13\">Sub TEST3()\nDim myCht       As Chart\n\nSet myCht = ActiveSheet.ChartObjects(1).Chart\n\nWith myCht\n    Debug.Print TypeName(myCht)\n    Debug.Print \".Name\", .Name\n\nWith .ChartArea\n    Debug.Print TypeName(myCht.ChartArea)\n    Debug.Print \".Name\", .Name\n    Debug.Print \".Left\", .Left\n    Debug.Print \".Top\", .Top\n    Debug.Print \".Width\", .Width\n    Debug.Print \".Height\", .Height\nEnd With\n\nDebug.Print \"===============================\"\n\nWith .PlotArea\n    Debug.Print TypeName(myCht.PlotArea)\n    Debug.Print \".Name\", .Name\n    Debug.Print \".Left\", .Left\n    Debug.Print \".Top\", .Top\n    Debug.Print \".Width\", .Width\n    Debug.Print \".Height\", .Height\n    Debug.Print \".InsideLeft\", .InsideLeft\n    Debug.Print \".InsideTop\", .InsideTop\n    Debug.Print \".InsideWidth\", .InsideWidth\n    Debug.Print \".InsideHeight\", .InsideHeight\nEnd With\n\nDebug.Print \"===============================\"\n\nWith .Axes(xlCategory)\n    Debug.Print TypeName(myCht.Axes(xlCategory))\n    Debug.Print \".Type\", .Type\n    Debug.Print \".ScaleType\", .ScaleType\n    Debug.Print \".MaximumScale\", .MaximumScale\n    Debug.Print \".MinimumScale\", .MinimumScale\n    Debug.Print \".Crosses\", .Crosses\n    Debug.Print \".HasTitle\", .HasTitle\n    Debug.Print \".Left\", .Left\n    Debug.Print \".Top\", .Top\n    Debug.Print \".Width\", .Width\n    Debug.Print \".Height\", .Height\n    \nWith .TickLabels\n    Debug.Print TypeName(myCht.Axes(xlCategory).TickLabels)\n    Debug.Print , TypeName(.Font)\n    Debug.Print , \".Font.Name\", .Font.Name\n    Debug.Print , \".Font.Size\", .Font.Size\n    Debug.Print , \".Font.Color\", .Font.Color\n    Debug.Print , \".Font.Bold\", .Font.Bold\n    Debug.Print , \".Font.FontStyle\", .Font.FontStyle\n    Debug.Print \".Name\", .Name\n    Debug.Print \".NumberFormat\", .NumberFormat\n    Debug.Print \".NumberFormatLinked\", .NumberFormatLinked\n    Debug.Print \".NumberFormatLocal\", .NumberFormatLocal\n    Debug.Print \".Offset\", .Offset\n    Debug.Print \".Orientation\", .Orientation\n    Debug.Print \".ReadingOrder\", .ReadingOrder\n    Debug.Print \".Depth\", .Depth\n    \nEnd With\nEnd With\n\nDebug.Print \"===============================\"\n\nWith .Axes(xlValue)\n    Debug.Print TypeName(myCht.Axes(xlValue))\n    Debug.Print \".Type\", .Type\n    Debug.Print \".ScaleType\", .ScaleType\n    Debug.Print \".MaximumScale\", .MaximumScale\n    Debug.Print \".MinimumScale\", .MinimumScale\n    Debug.Print \".LogBase\", .LogBase\n    Debug.Print \".Crosses\", .Crosses\n    Debug.Print \".HasTitle\", .HasTitle\n    Debug.Print \".Left\", .Left\n    Debug.Print \".Top\", .Top\n    Debug.Print \".Width\", .Width\n    Debug.Print \".Height\", .Height\nWith .TickLabels\n    Debug.Print TypeName(myCht.Axes(xlValue).TickLabels)\n    Debug.Print , TypeName(.Font)\n    Debug.Print , \".Font.Name\", .Font.Name\n    Debug.Print , \".Font.Size\", .Font.Size\n    Debug.Print , \".Font.Color\", .Font.Color\n    Debug.Print , \".Font.Bold\", .Font.Bold\n    Debug.Print , \".Font.FontStyle\", .Font.FontStyle\n    Debug.Print \".Name\", .Name\n    Debug.Print \".NumberFormat\", .NumberFormat\n    Debug.Print \".NumberFormatLinked\", .NumberFormatLinked\n    Debug.Print \".NumberFormatLocal\", .NumberFormatLocal\n    Debug.Print \".Offset\", .Offset\n    Debug.Print \".Orientation\", .Orientation\n    Debug.Print \".ReadingOrder\", .ReadingOrder\n    Debug.Print \".Depth\", .Depth\n    \nEnd With\nEnd With\n\nEnd With\n\nEnd Sub<\/pre>\n<p>\u3000\u30a4\u30df\u30c7\u30a3\u30a8\u30a4\u30c8\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u51fa\u529b\u3055\u308c\u308b\uff0e\u51fa\u529b\u7d50\u679c\u306f\u5404\u81ea\u306e\u74b0\u5883\u3067\u7570\u306a\u308b\uff0eY \u8ef8\u306f\u5bfe\u6570\u8868\u8a18\u306b\u3057\u3066\u3042\u308b\u305f\u3081 .LogBase \u30d7\u30ed\u30d1\u30c6\u30a3\u304c\u30a8\u30e9\u30fc\u306b\u306a\u3089\u306a\u3044\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true\" title=\"\u7d50\u679c\">Chart\n.Name         \u6563\u5e03\u56f3 \u30b0\u30e9\u30d5 1\nChartArea\n.Name         \u30b0\u30e9\u30d5\n.Left          0 \n.Top           0 \n.Width         795 \n.Height        795 \n===============================\nPlotArea\n.Name         \u30d7\u30ed\u30c3\u30c8\n.Left          26.73 \n.Top           39.43 \n.Width         758.27 \n.Height        745.57 \n.InsideLeft    26.73 \n.InsideTop     39.43 \n.InsideWidth   750.022519685039 \n.InsideHeight  734.758346456693 \n===============================\nAxis\n.Type          1 \n.ScaleType    -4132 \n.MaximumScale  0.3 \n.MinimumScale -0.3 \n.Crosses      -4105 \n.HasTitle     False\n.Left          27 \n.Top           774 \n.Width         750 \n.Height        17 \nTickLabels\n              Font\n              .Font.Name    \u6e38\u30b4\u30b7\u30c3\u30af\n              .Font.Size     9 \n              .Font.Color    16777215 \n              .Font.Bold    False\n              .Font.FontStyle             Regular\n.Name         \u8ef8 2\n.NumberFormat 0%\n.NumberFormatLinked         False\n.NumberFormatLocal          0%\n.Offset        100 \n.Orientation  -4105 \n.ReadingOrder -5002 \n.Depth         0 \n===============================\nAxis\n.Type          2 \n.ScaleType    -4133 \n.MaximumScale  1000000 \n.MinimumScale  1000 \n.LogBase       10 \n.Crosses      -4114 \n.HasTitle     False\n.Left          368 \n.Top           39 \n.Width         34 \n.Height        735 \nTickLabels\n              Font\n              .Font.Name    \u6e38\u30b4\u30b7\u30c3\u30af\n              .Font.Size     9 \n              .Font.Color    16777215 \n              .Font.Bold    False\n              .Font.FontStyle             Regular\n.Name         \u8ef8 1\n.NumberFormat General\n.NumberFormatLinked         True\n.NumberFormatLocal          G\/\u6a19\u6e96\n.Offset        100 \n.Orientation  -4105 \n.ReadingOrder -5002 \n.Depth         0 \n<\/pre>\n<h3>Chart.SetElement \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3044\u3053\u306a\u305b<\/h3>\n<p>\u3000<a href=\"https:\/\/amzn.to\/30prdjI\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel 2019 VBA and Macros (Business Skills)<\/a> \u306e p 314 \u4ee5\u964d\u306b\u8a18\u8ff0\u304c\u3042\u308b\u304c\uff0cChart \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e .SetElement \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3068\uff0c\u5217\u6319\u578b\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u30b0\u30e9\u30d5\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u305b\u305a\u3068\u3082\u4e00\u767a\u3067\u8a2d\u5b9a\u3067\u304d\u308b\uff0e<\/p>\n<p>\u3000\u4f8b\u3048\u3070 Y \u8ef8\u3092\u5bfe\u6570\u8868\u8a18\u306b\u3057\u305f\u3044\u5834\u5408\u306f\uff0c\u4e0b\u8a18\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308b\u306e\u304c\u666e\u901a\u3060\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true\" title=\"Sample1\">With Chart.Axes(XlValue)\n    .ScaleType = xlScaleLogarithmic\nEnd with<\/pre>\n<p>\u3000\u3068\u3053\u308d\u304c\uff0cChart.SetElement \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3068 Axis \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u304c\u306a\u3044\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true\" title=\"Sample2\">With Chart\n    .SetElement msoElementPrimaryValueAxisLogScale\nEnd with<\/pre>\n<p>\u3000\u5217\u6319\u578b\u3092\u77e5\u3063\u3066\u3044\u308b\u3068\uff0c\u3053\u3046\u3044\u3046\u30c1\u30fc\u30c8\u304c\u4f7f\u3048\u308b\uff0eMsoChartElementType \u3068\u3044\u3046\u8a00\u8449\u3092\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u691c\u7d22\u3057\u3066\u307f\u3066\u307b\u3057\u3044\uff0e\u8a2d\u5b9a\u3067\u304d\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u3060\uff0e<\/p>\n<ul>\n<li>Axis<\/li>\n<li>AxisTitle<\/li>\n<li>DataTable<\/li>\n<li>ErrorBar<\/li>\n<li>Gridline<\/li>\n<li>Legend<\/li>\n<li>Line<\/li>\n<li>PlotArea<\/li>\n<li>Trendline<\/li>\n<li>Up\/DownBars<\/li>\n<\/ul>\n<a href=\"https:\/\/www.amazon.co.jp\/gp\/product\/1509306110\/ref=as_li_ss_il?ie=UTF8&amp;psc=1&amp;linkCode=li3&amp;tag=gwho-22&amp;linkId=0b72f3f2c45c6fedb2ec34c8e2f4165c&amp;language=ja_JP\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" border=\"0\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=1509306110&amp;Format=_SL250_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=gwho-22&amp;language=ja_JP\"><\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=gwho-22&amp;language=ja_JP&amp;l=li3&amp;o=9&amp;a=1509306110\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\"><a href=\"https:\/\/www.amazon.co.jp\/gp\/product\/4295000914\/ref=as_li_ss_il?ie=UTF8&amp;psc=1&amp;linkCode=li3&amp;tag=gwho-22&amp;linkId=a59db34b8d532454bb40cebcc0d68444&amp;language=ja_JP\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" border=\"0\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=4295000914&amp;Format=_SL250_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=gwho-22&amp;language=ja_JP\"><\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=gwho-22&amp;language=ja_JP&amp;l=li3&amp;o=9&amp;a=4295000914\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\">\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306f VBA \u306e\u7f85\u91dd\u76e4\u3067\u3042\u308b\uff0e\u3057\u304b\u3057\u6642\u306b\u5f79\u306b\u7acb\u305f\u306a\u3044\u3053\u3068\u304c\u3042\u308b\uff0e\u4eca\u56de\u306f\u30b0\u30e9\u30d5\u306e\u8ef8\u306e\u66f8\u5f0f\u8a2d\u5b9a\u3067\u30cf\u30de\u3063\u305f\u7d4c\u7def\u3092\u5099\u5fd8\u9332\u3068\u3057\u3066\u8a18\u3057\u3066\u304a\u304f\uff0e<\/p>\n","protected":false},"author":1,"featured_media":7812,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[5027,5028,5033,5034,5029,5030,4987,4526,5001,4542,4998,5047,4525,5004,4994,4524,5008,5014,5015,5048,4997,5049,265,4992,5011,4991,5010,4883,5000,5050,5020,4545,4884,2474,5017,5018,5019,5044,5045,5007,4541,5021,4672,4988,5046,4989,4990,5009,5005,5051,4995,4996,5052,5035,459,4658,5016,5023,5024,5025,5026,5031,5032,5022,4544,4329,4330,4945,460,4554,1013,4999,3891,5002,3948,1811,4986,4255,4629,5006,4552,5036,5039,5038,4857,5041,4503,5003,4993,4427,5037,2770,3527,3528,4414,5012,5013,4626,4890,5042,2591,4983,5040,5043],"class_list":{"0":"post-7624","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-technology","8":"tag-5027","9":"tag-5028","10":"tag-5033","11":"tag-5034","12":"tag-5029","13":"tag-5030","14":"tag-activate","15":"tag-activesheet","16":"tag-and","17":"tag-axes","18":"tag-axis","19":"tag-axistitle","20":"tag-chart","21":"tag-chartarea","22":"tag-chartformat","23":"tag-chartobjects","24":"tag-color","25":"tag-crosses","26":"tag-crossesat","27":"tag-datatable","28":"tag-debug-print","29":"tag-errorbar","30":"tag-excel","31":"tag-fill","32":"tag-fillformat","33":"tag-font","34":"tag-font2","35":"tag-format","36":"tag-google","37":"tag-gridline","38":"tag-gridlines","39":"tag-legend","40":"tag-line","41":"tag-long","42":"tag-majorgridlines","43":"tag-maximumscale","44":"tag-minimumscale","45":"tag-msochartelementtype","46":"tag-msoelementprimaryvalueaxislogscale","47":"tag-object","48":"tag-plotarea","49":"tag-scaletype","50":"tag-select","51":"tag-selection","52":"tag-setelement","53":"tag-textframe2","54":"tag-textrange","55":"tag-textrange2","56":"tag-ticklabels","57":"tag-trendline","58":"tag-typename","60":"tag-up-downbars","61":"tag-variant","62":"tag-vba","63":"tag-with","64":"tag-xlaxiscrosses","65":"tag-xlaxiscrossesautomatic","66":"tag-xlaxiscrossescustom","67":"tag-xlaxiscrossesmaximum","68":"tag-xlaxiscrossesminimum","69":"tag-xlscalelinear","70":"tag-xlscalelogarithmic","71":"tag-xlscaletype","72":"tag-xlvalue","73":"tag-x","74":"tag-y","75":"tag-4945","76":"tag-460","77":"tag-4554","78":"tag-1013","79":"tag-4999","80":"tag-3891","81":"tag-5002","82":"tag-3948","83":"tag-1811","84":"tag-4986","85":"tag-4255","86":"tag-4629","87":"tag-5006","88":"tag-4552","89":"tag-5036","90":"tag-5039","91":"tag-5038","92":"tag-4857","93":"tag-5041","94":"tag-4503","95":"tag-5003","96":"tag-4993","97":"tag-4427","98":"tag-5037","99":"tag-2770","100":"tag-3527","101":"tag-3528","102":"tag-4414","103":"tag-5012","104":"tag-5013","105":"tag-4626","106":"tag-4890","107":"tag-5042","108":"tag-2591","109":"tag-4983","110":"tag-5040","111":"tag-5043"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7624"}],"version-history":[{"count":175,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7624\/revisions"}],"predecessor-version":[{"id":7838,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7624\/revisions\/7838"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/7812"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}