{"id":7024,"date":"2019-09-19T06:00:29","date_gmt":"2019-09-18T21:00:29","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=7024"},"modified":"2019-12-17T11:34:55","modified_gmt":"2019-12-17T02:34:55","slug":"excel-vba-%e3%81%a7%e6%95%a3%e5%b8%83%e5%9b%b3%e3%82%92%e4%bd%9c%e6%88%90%e3%81%97%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e5%88%97%e3%82%92%e6%96%b0%e8%a6%8f%e3%81%ab%e8%bf%bd%e5%8a%a0%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=7024","title":{"rendered":"EXCEL VBA \u3067\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3057\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u65b0\u898f\u306b\u8ffd\u52a0\u3059\u308b"},"content":{"rendered":"\n

\u3000VBA\u304b\u3089\u898b\u305fEXCEL\u306e\u6563\u5e03\u56f3<\/a>\u3067\u306f\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3059\u308b\u969b\u306b .ChartObjects.Add \u3092\u7528\u3044\u305f\u304c\uff0c\u4eca\u56de\u306f\u5225\u306e\u7d4c\u8def\u3067\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3059\u308b\u30b3\u30fc\u30c9\u3092\u7d39\u4ecb\u3059\u308b\uff0e\u307e\u305f\u30c7\u30fc\u30bf\u7cfb\u5217\u306b\u4f55\u3082\u5165\u529b\u306e\u306a\u3044\uff0c\u7a7a\u3063\u307d\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u65b0\u898f\u4f5c\u6210\u3057\u305f\u3068\u304d\u306e\u30b3\u30fc\u30c9\u3082\u7d39\u4ecb\u3059\u308b\uff0e<\/p>\n

<\/p>\n

\u300c\u633f\u5165\u300d\u300c\u30b0\u30e9\u30d5\u300d\u300c\u6563\u5e03\u56f3\u300d\u300c\u76f4\u7dda\u3068\u30de\u30fc\u30ab\u30fc\u300d<\/h3>\n

\u3000EXCEL \u306e\u6a19\u6e96\u7684\u306a\u64cd\u4f5c\u3067\u306f\u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u300c\u30b0\u30e9\u30d5\u300d\u306b\u300c\u6563\u5e03\u56f3\u300d\u304c\u3042\u308b\u306e\u3067\u305d\u3053\u304b\u3089\u300c\u6563\u5e03\u56f3\uff08\u76f4\u7dda\u3068\u30de\u30fc\u30ab\u30fc\uff09\u300d\u3092\u9078\u3076\uff0e<\/p>\n

\"\u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u300c\u30b0\u30e9\u30d5\u300d\u304b\u3089\u300c\u6563\u5e03\u56f3\u300d\u306e\u300c\u6563\u5e03\u56f3\uff08\u76f4\u7dda\u3068\u30de\u30fc\u30ab\u30fc\uff09\u300d\"<\/a>
\u300c\u633f\u5165\u300d\u30bf\u30d6\u306e\u300c\u30b0\u30e9\u30d5\u300d\u304b\u3089\u300c\u6563\u5e03\u56f3\u300d\u306e\u300c\u6563\u5e03\u56f3\uff08\u76f4\u7dda\u3068\u30de\u30fc\u30ab\u30fc\uff09\u300d<\/figcaption><\/figure>\n

\u3000VBA \u3067\u306f\u3053\u306e\u884c\u7a0b\u3092\u6b21\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3059\u308b\uff0e<\/p>\n

Sub AddScatterPlot()\n\nDim mySht  As Worksheet\nDim myCht  As Chart\n\nSet mySht = Worksheets(1)\nSet myCht = mySht.Shapes.AddChart2(-1, xlXYScatterLines, 0, 0, 300, 300).Chart\n\nEnd Sub<\/pre>\n
\u6c4e\u7528\u6027\u306e\u3042\u308b\u30b3\u30fc\u30c9\u306f .Shapes.Addchart2.Chart<\/h3>\n
\u3000EXCEL 2013 \u304b\u3089\u5b9f\u88c5\u3055\u308c\u305f\u30e1\u30bd\u30c3\u30c9\u3067\u3042\u308b\uff0e\u3053\u308c\u304b\u3089\u899a\u3048\u308b\u306a\u3089\u3053\u306e\u624b\u6cd5\u304c\u826f\u3044\u3060\u308d\u3046\uff0e<\/p>\n
\u3000\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\u306f 7 \u884c\u76ee\u3067\u3042\u308b\uff0eShapes \u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306b\u5bfe\u3057\u3066 .Addchart2 \u30e1\u30bd\u30c3\u30c9\u3092\u5b9f\u884c\u3059\u308b\u3068\u65b0\u3057\u3044 Shape \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u53d6\u5f97\u3067\u304d\u308b\uff0e\u3053\u306e Shape \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b .Chart \u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u4ed8\u52a0\u3057\u3066 Chart \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3057\u3066\u3044\u308b\uff0e<\/p>\n
\u3000\u3084\u3084\u3053\u3057\u3044\u8a18\u8ff0\u3060\u304c\uff0c\u3053\u308c\u304c\u304a\u4f5c\u6cd5\u306a\u306e\u3067\u899a\u3048\u308b\u3057\u304b\u306a\u3044\uff0e<\/p>\n
\u7a7a\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u65b0\u898f\u306b\u4f5c\u6210\u3059\u308b<\/h3>\n
\u3000\u4f5c\u6210\u3057\u305f\u7a7a\u306e\u30b0\u30e9\u30d5\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30c7\u30fc\u30bf\u306e\u9078\u629e…\u300d\u3092\u9078\u3076\uff0e<\/p>\n
\"\u30c7\u30fc\u30bf\u306e\u9078\u629e\"<\/a>
\u30c7\u30fc\u30bf\u306e\u9078\u629e<\/figcaption><\/figure>\n
\u3000\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u958b\u304f\uff0e\u5de6\u4e0b\u306b\u300c\u51e1\u4f8b\u9805\u76ee\uff08\u7cfb\u5217\uff09\u300d\u3068\u3042\u308b\uff0e\u3053\u308c\u306f SeriesCollection \u3068\u3044\u3046\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u6307\u3057\u3066\u3044\u308b\uff0e\u3053\u306e\u3042\u305f\u308a\u672c\u5f53\u306b\u3084\u3084\u3053\u3057\u3044\uff0e<\/p>\n
\"\u51e1\u4f8b\u9805\u76ee\u306fSeriesCollection\"<\/a>
\u51e1\u4f8b\u9805\u76ee\u306fSeriesCollection<\/figcaption><\/figure>\n
\u3000\u300c\u8ffd\u52a0\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u3053\u308c\u304c .NewSeries \u30e1\u30bd\u30c3\u30c9\u306b\u3042\u305f\u308a\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4e00\u3064\u8ffd\u52a0\u3057\u305f\u3053\u3068\u306b\u306a\u308b\uff0e<\/p>\n
\u3000\u300c\u7cfb\u5217\u306e\u7de8\u96c6\u300d\u3067\u4f55\u3082\u5165\u529b\u305b\u305a\u306b\u300cOK\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e\u7cfb\u5217\u306f Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308a\uff0c\u7cfb\u5217\u540d\u306f .Name \u30d7\u30ed\u30d1\u30c6\u30a3\uff0c\u7cfb\u5217 X \u306e\u5024\u306f .XValues \u30d7\u30ed\u30d1\u30c6\u30a3\uff0c\u7cfb\u5217 Y \u306e\u5024\u306f .Values \u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u53d6\u5f97\u3055\u308c\u308b\uff0e<\/p>\n
\"\u7cfb\u5217\u306fSeries\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff0e\u7cfb\u5217\u540d\u306f.Name\u30d7\u30ed\u30d1\u30c6\u30a3\uff0c\u7cfb\u5217X\u306e\u5024\u306f.XValues\u30d7\u30ed\u30d1\u30c6\u30a3\uff0c\u7cfb\u5217Y\u306e\u5024\u306f.Values\u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u53d6\u5f97\"<\/a>
\u7cfb\u5217\u306fSeries\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff0e\u7cfb\u5217\u540d\u306f.Name\u30d7\u30ed\u30d1\u30c6\u30a3\uff0c\u7cfb\u5217X\u306e\u5024\u306f.XValues\u30d7\u30ed\u30d1\u30c6\u30a3\uff0c\u7cfb\u5217Y\u306e\u5024\u306f.Values\u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u53d6\u5f97<\/figcaption><\/figure>\n
\u3000\u3059\u308b\u3068\uff0c\u7a7a\u306e\u7cfb\u5217\u304c\u8ffd\u52a0\u3055\u308c\u308b\uff0e<\/p>\n
\"\u4e00\u3064\u8ffd\u52a0\u3055\u308c\u305f\u7cfb\u5217\u304cSeries\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\"<\/a>
\u4e00\u3064\u8ffd\u52a0\u3055\u308c\u305f\u7cfb\u5217\u304cSeries\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b<\/figcaption><\/figure>\n
\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8ffd\u52a0\u306f Chart.SeriesCollection.NewSeries \u3068\u899a\u3048\u308b<\/h3>\n
\u3000\u3053\u306e\u3042\u305f\u308a\u3082\u304a\u4f5c\u6cd5\u3068\u3057\u3066\u899a\u3048\u308b\u3057\u304b\u306a\u3044\uff0e\u30b3\u30fc\u30c9\u3092\u8f09\u305b\u3066\u304a\u304f\uff0e<\/p>\n
Sub mySeries()\n    \nDim mySht       As Worksheet\nDim myCht       As Chart\nDim mySeries    As Series\n\nSet mySht = Worksheets(1)\n\nWith mySht.ChartObjects\n    Set myCht = .Item(.Count).Chart\nEnd With\n\nSet mySeries = myCht.SeriesCollection.NewSeries\n\nEnd Sub<\/pre>\n
\u3000\u3053\u3053\u3067\u91cd\u8981\u306a\u30dd\u30a4\u30f3\u30c8\u306f 13 \u884c\u76ee\u3067\u3042\u308b\uff0e<\/p>\n
\u3068\u3053\u308d\u3067\uff0c\u306a\u305c\u7a7a\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u8ffd\u52a0\u3059\u308b\u306e\u304b\uff1f<\/h3>\n
\u3000\u3044\u3044\u3068\u3053\u308d\u306b\u6c17\u304c\u3064\u3044\u305f\uff0e\u30c7\u30fc\u30bf\u7cfb\u5217\u4e00\u3064\u4e00\u3064\u306f Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u53d6\u5f97\u3059\u308b\u306e\u3060\u304c\uff0c\u691c\u7d22\u3057\u3066\u3082\u901a\u5e38\u306f\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306e Range \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6307\u5b9a\u3057\u3066\u3044\u308b\u30b3\u30fc\u30c9\u304c\u307b\u3068\u3093\u3069\u3060\uff0e<\/p>\n
\u3000\u3057\u304b\u3057\u3084\u3063\u3066\u307f\u308b\u3068\u5206\u304b\u308b\u304c\uff0cSeries \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e .XValues \u30d7\u30ed\u30d1\u30c6\u30a3\u3084 .Values \u30d7\u30ed\u30d1\u30c6\u30a3\u306b\u306f\u914d\u5217\u305d\u306e\u3082\u306e\u3092\u76f4\u63a5\u6307\u5b9a\u3067\u304d\u308b<\/a>\uff0e\u305d\u308c\u3082 (X, Y) \u306e\u5024\u306e\u30da\u30a2\u3068\u3057\u3066\u3067\u306f\u306a\u304f\uff0cX \u306e\u5024\u306e\u914d\u5217\uff0cY \u306e\u5024\u306e\u914d\u5217\u3068\u3057\u3066\u3067\u3042\u308b\uff0e<\/p>\n
\u3000Range \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3060\u3068\u30c7\u30fc\u30bf\u3068\u30ed\u30b8\u30c3\u30af\u306e\u7d50\u5408\u3092\u758e\u306b\u3067\u304d\u306a\u3044\u304c\uff0c\u914d\u5217\u3092\u6307\u5b9a\u3067\u304d\u308b\u306a\u3089\u30c7\u30fc\u30bf\u3068\u30ed\u30b8\u30c3\u30af\u3092\u5206\u96e2\u3067\u304d\u308b\uff0e\u3053\u3053\u306b\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u81ea\u7531\u5ea6\u304c\u5897\u3059\u30dd\u30a4\u30f3\u30c8\u304c\u3042\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000VBA\u304b\u3089\u898b\u305fEXCEL\u306e\u6563\u5e03\u56f3\u3067\u306f\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3059\u308b\u969b\u306b .ChartObjects.Add \u3092\u7528\u3044\u305f\u304c\uff0c\u4eca\u56de\u306f\u5225\u306e\u7d4c\u8def\u3067\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3059\u308b\u30b3\u30fc\u30c9\u3092\u7d39\u4ecb\u3059\u308b\uff0e\u307e\u305f\u30c7\u30fc\u30bf\u7cfb\u5217\u306b\u4f55\u3082\u5165\u529b\u306e\u306a\u3044\uff0c\u7a7a\u3063\u307d\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u65b0\u898f\u4f5c\u6210\u3057 … <\/p>\n
“EXCEL VBA \u3067\u6563\u5e03\u56f3\u3092\u4f5c\u6210\u3057\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u65b0\u898f\u306b\u8ffd\u52a0\u3059\u308b” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4605,4608,4580,4628,4592,4612,4566,4618,4567,4617,4527,4601,4525,4524,4609,265,4606,4577,4528,4614,4530,4616,4561,4585,4613,4625,4600,4624,4607,459,4523,4599,4602,1013,4581,4622,4162,1026,4399,4516,4620,4536,4418,4552,2500,4597,4611,4621,4503,4627,2944,4326,4623,4598,4401,4400,2782,933,4610,2834,4619],"class_list":{"0":"post-7024","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-technology","7":"tag-char","8":"tag-chart","9":"tag-count","10":"tag-name","11":"tag-newseries","13":"tag-values","15":"tag-xvalues","17":"tag-add","18":"tag-addchart2","20":"tag-chartobjects","22":"tag-excel","23":"tag-excel2013","24":"tag-item","26":"tag-ok","27":"tag-range","29":"tag-series","30":"tag-seriescollection","32":"tag-shape","33":"tag-shapes","36":"tag-vba","37":"tag-worksheet","38":"tag-worksheets","39":"tag-xlxyscatterlines","40":"tag-1013","41":"tag-4581","42":"tag-4622","43":"tag-4162","44":"tag-1026","45":"tag-4399","46":"tag-4516","47":"tag-4620","48":"tag-4536","49":"tag-4418","50":"tag-4552","51":"tag-2500","52":"tag-4597","53":"tag-4611","54":"tag-4621","55":"tag-4503","56":"tag-4627","57":"tag-2944","58":"tag-4326","59":"tag-4623","60":"tag-4598","61":"tag-4401","62":"tag-4400","63":"tag-2782","64":"tag-933","65":"tag-4610","66":"tag-2834","67":"tag-4619"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7024","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=7024"}],"version-history":[{"count":35,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7024\/revisions"}],"predecessor-version":[{"id":9428,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/7024\/revisions\/9428"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}