{"id":6963,"date":"2019-09-12T06:00:33","date_gmt":"2019-09-11T21:00:33","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=6963"},"modified":"2019-08-11T08:15:42","modified_gmt":"2019-08-10T23:15:42","slug":"vba%e3%81%8b%e3%82%89%e8%a6%8b%e3%82%8bexcel%e3%81%ae%e3%82%b0%e3%83%a9%e3%83%95%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e7%b3%bb%e5%88%97","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=6963","title":{"rendered":"VBA\u304b\u3089\u898b\u308bEXCEL\u306e\u30b0\u30e9\u30d5\u306e\u30c7\u30fc\u30bf\u7cfb\u5217"},"content":{"rendered":"\n<p>\u3000EXCEL \u306e\u30b0\u30e9\u30d5\u306e\u968e\u5c64\u69cb\u9020\u306f\u8907\u96d1\u3067\u3042\u308b\uff0e\u4e2d\u3067\u3082\u30c7\u30fc\u30bf\u7cfb\u5217\u306f\u57fa\u672c\u3067\u3042\u308a\u306a\u304c\u3089\u304a\u308d\u305d\u304b\u306b\u3055\u308c\u304c\u3061\u3067\u3042\u308b\uff0e\u4eca\u56de\u306f VBA \u306e\u8996\u70b9\u304b\u3089\u30b0\u30e9\u30d5\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u898b\u3066\u307f\u305f\u3044\uff0e<\/p>\n<p><!--more--><\/p>\n<h3>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306f EXCEL VBA \u306e\u7f85\u91dd\u76e4<\/h3>\n<p>\u3000EXCEL \u306e\u901a\u5e38\u64cd\u4f5c\u753b\u9762\uff08\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\uff09\u304b\u3089\u306f\u60f3\u50cf\u3082\u3064\u304b\u306a\u3044\u304c\uff0cEXCEL \u306b\u306f\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u8a00\u8a9e\u3068\u3044\u3046\u300c\u88cf\u306e\u9854\u300d\u304c\u3042\u308b\uff0e\u666e\u6bb5\u64cd\u4f5c\u3057\u3066\u3044\u308b EXCEL \u306e\u8981\u7d20\u306f\u307b\u307c\u5168\u3066\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u3057\u3066\u5b9a\u7fa9\u3055\u308c\u3066\u304a\u308a\uff0c\u8907\u96d1\u306a\u968e\u5c64\u69cb\u9020\u3092\u306a\u3057\u3066\u3044\u308b\uff0e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306f\u305d\u306e\u7f85\u91dd\u76e4\u3068\u306a\u308b\uff0e<\/p>\n<p>\u3000Alt \u30ad\u30fc\u3068 F11 \u30ad\u30fc\u3092\u540c\u6642\u306b\u62bc\u3059\u3068 VBE \u3068\u3044\u3046\u958b\u767a\u74b0\u5883\u304c\u8d77\u52d5\u3059\u308b\uff0e\u3055\u3089\u306b F2 \u30ad\u30fc\u3092\u62bc\u3059\u3068\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u304c\u958b\u304f\uff0e<\/p>\n<figure id=\"attachment_6974\" aria-describedby=\"caption-attachment-6974\" style=\"width: 418px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/000-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6974\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/000-1.png\" alt=\"\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3092\u958b\u3044\u305f\u3068\u3053\u308d\" width=\"418\" height=\"324\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/000-1.png 418w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/000-1-300x233.png 300w\" sizes=\"auto, (max-width: 418px) 100vw, 418px\" \/><\/a><figcaption id=\"caption-attachment-6974\" class=\"wp-caption-text\">\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3092\u958b\u3044\u305f\u3068\u3053\u308d<\/figcaption><\/figure>\n<h3>\u30c7\u30fc\u30bf\u7cfb\u5217 = Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h3>\n<p>\u3000\u6700\u521d\u306b\u7b54\u3048\u3092\u66f8\u3044\u3066\u304a\u304f\u3068\uff0c\u30b0\u30e9\u30d5\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u306f VBA \u306e Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306b\u3042\u305f\u308b\uff0e<\/p>\n<p>\u3000\u691c\u7d22\u30a6\u30a3\u30f3\u30c9\u30a6\u306b series \u3068\u30bf\u30a4\u30d7\u5165\u529b\u3057\u3066\u30ea\u30bf\u30fc\u30f3\u3059\u308b\u3068\uff0c\u4e0a\u6bb5\u306b\u305a\u3089\u305a\u3089\u3068\u691c\u7d22\u7d50\u679c\u304c\u4e26\u3076\uff0e<\/p>\n<figure id=\"attachment_6975\" aria-describedby=\"caption-attachment-6975\" style=\"width: 416px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/001-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6975\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/001-1.png\" alt=\"\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067series\u3092\u691c\u7d22\u3057\u305f\u3068\u3053\u308d\" width=\"416\" height=\"322\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/001-1.png 416w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/001-1-300x232.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a><figcaption id=\"caption-attachment-6975\" class=\"wp-caption-text\">\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u3067series\u3092\u691c\u7d22\u3057\u305f\u3068\u3053\u308d<\/figcaption><\/figure>\n<p>\u3000\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u6700\u5927\u5316\u3059\u308b\uff0e\u4e2d\u7a0b\u306e\u30af\u30e9\u30b9 Series \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u4e0b\u6bb5\u5de6\u5074\u306e\u30da\u30a4\u30f3\u306b\u8a72\u5f53\u30af\u30e9\u30b9\u304c\u9078\u629e\u3055\u308c\u305f\u72b6\u614b\u306b\u306a\u308b\u306e\u3067\uff0c\u305d\u3053\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\uff0c\u30e1\u30f3\u30d0\u30fc\u304c\u4e0b\u6bb5\u53f3\u5074\u306b\u8868\u793a\u3055\u308c\u308b\uff0e<\/p>\n<figure id=\"attachment_6976\" aria-describedby=\"caption-attachment-6976\" style=\"width: 891px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/002-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6976\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/002-1.png\" alt=\"\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306e\u691c\u7d22\u7d50\u679c\u306e\u4e0a\u6bb5\" width=\"891\" height=\"749\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/002-1.png 891w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/002-1-300x252.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/002-1-768x646.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-6976\" class=\"wp-caption-text\">\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306e\u691c\u7d22\u7d50\u679c\u306e\u4e0a\u6bb5<\/figcaption><\/figure>\n<p>\u300011 \u500b\u306e\u30e1\u30bd\u30c3\u30c9\u3068 51 \u500b\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_6977\" aria-describedby=\"caption-attachment-6977\" style=\"width: 525px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/003-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-6977\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/003-1-864x1024.png\" alt=\"\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306e\u691c\u7d22\u7d50\u679c\u306e\u4e0b\u6bb5\" width=\"525\" height=\"622\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/003-1-864x1024.png 864w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/003-1-253x300.png 253w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/003-1-768x911.png 768w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/003-1.png 894w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><figcaption id=\"caption-attachment-6977\" class=\"wp-caption-text\">\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30d6\u30e9\u30a6\u30b6\u30fc\u306e\u691c\u7d22\u7d50\u679c\u306e\u4e0b\u6bb5<\/figcaption><\/figure>\n<h3>\u5fc5\u8981\u306a\u30d7\u30ed\u30d1\u30c6\u30a3\u3068\u30e1\u30bd\u30c3\u30c9\u306f\u56db\u3064\u3060\u3051<\/h3>\n<p>\u3000\u3053\u306e\u6570\u3060\u3051\u3067\u5727\u5012\u3055\u308c\u305d\u3046\u306b\u306a\u308b\u304c\uff0c\u5b9f\u969b\u306b\u5fc5\u8981\u306a\u3082\u306e\u306f\u5c11\u306a\u3044\uff0e\u3068\u3044\u3046\u304b\uff0c\u56db\u3064\u3060\u3051\u3067\u3042\u308b\uff0e\u3059\u306a\u308f\u3061\u4e09\u3064\u306e\u30d7\u30ed\u30d1\u30c6\u30a3 (.Name, .Values, .XValues), \u4e00\u3064\u306e\u30e1\u30bd\u30c3\u30c9 (.Points) \u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u30e1\u30bd\u30c3\u30c9\u3068\u304b\u30d7\u30ed\u30d1\u30c6\u30a3\u3068\u304b\u5206\u304b\u3089\u306a\u3044\u3068\u601d\u3046\u304c\uff0c\u4eca\u306f\u305d\u3046\u3044\u3046\u3082\u306e\u3060\u3068\u601d\u3063\u3066\u6d41\u3057\u3066\u307b\u3057\u3044\uff0e<\/p>\n<p>\u3000.Name \u306f\u7cfb\u5217\u540d, .Values \u306f Y \u306e\u5024\u306e\u96c6\u5408, .XValues \u306f X \u306e\u5024\u306e\u96c6\u5408\u3092\u6307\u3059\uff0e<\/p>\n<h3>\u70b9 = Point \u30aa\u30d6\u30b8\u30a7\u30af\u30c8<\/h3>\n<p>\u3000Point \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3068\u306f\u30b0\u30e9\u30d5\u4e0a\u306b\u63cf\u304b\u308c\u305f\u4e00\u500b\u4e00\u500b\u306e\u70b9\u306e\u3053\u3068\u3067\u3042\u308b\uff0e\u30d7\u30ed\u30d1\u30c6\u30a3\u306f 28 \u500b\uff0c\u30e1\u30bd\u30c3\u30c9\u306f 9 \u500b\u3042\u308b\u304c\uff0c\u91cd\u8981\u306a\u30d7\u30ed\u30d1\u30c6\u30a3\u306f .MarkerStyle, .MarkerSize, .MarkerBackgroundColor, .MarkerForegroundColor \u3042\u305f\u308a\u3067\u3042\u308d\u3046\u304b\uff0e<\/p>\n<figure id=\"attachment_6980\" aria-describedby=\"caption-attachment-6980\" style=\"width: 487px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/005-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6980\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/005-1.png\" alt=\"Point\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eMarkerStyle\u30d7\u30ed\u30d1\u30c6\u30a3\" width=\"487\" height=\"305\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/005-1.png 487w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/005-1-300x188.png 300w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/a><figcaption id=\"caption-attachment-6980\" class=\"wp-caption-text\">Point\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eMarkerStyle\u30d7\u30ed\u30d1\u30c6\u30a3<\/figcaption><\/figure>\n<p>\u3000\u7cfb\u5217\u3072\u3068\u584a\u306e\u70b9\u306e\u96c6\u5408\u306f Points \u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u8868\u73fe\u3059\u308b\u304c\uff0c\u3053\u3061\u3089\u306f 4 \u500b\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3068 1 \u500b\u306e\u30e1\u30bd\u30c3\u30c9\u304c\u3042\u308b\u306b\u904e\u304e\u305a\uff0c\u4e3b\u306b Item \u30e1\u30bd\u30c3\u30c9\u7d4c\u7531\u3067 1 \u500b\u306e Point \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u7279\u5b9a\u3059\u308b\u76ee\u7684\u3067\u4f7f\u308f\u308c\u308b\uff0e<\/p>\n<figure id=\"attachment_6982\" aria-describedby=\"caption-attachment-6982\" style=\"width: 416px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/004-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6982\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/004-1.png\" alt=\"Points\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eItem\u30e1\u30bd\u30c3\u30c9\u3067\u552f\u4e00\u306ePoint\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u7279\u5b9a\u3059\u308b\" width=\"416\" height=\"157\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/004-1.png 416w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/004-1-300x113.png 300w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a><figcaption id=\"caption-attachment-6982\" class=\"wp-caption-text\">Points\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306eItem\u30e1\u30bd\u30c3\u30c9\u3067\u552f\u4e00\u306ePoint\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u7279\u5b9a\u3059\u308b<\/figcaption><\/figure>\n<h3>.Item \u30e1\u30bd\u30c3\u30c9 = \u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/h3>\n<p>\u3000\u3042\u307e\u308a VBA \u95a2\u9023\u306e\u30b5\u30a4\u30c8\u306b\u66f8\u304b\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3067\u3042\u308b\u304c\uff0c\u30e1\u30f3\u30d0\u30fc\u306b .Item \u30e1\u30bd\u30c3\u30c9\u3092\u6301\u3064\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308a\uff0c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u304c\u8907\u6570\u5f62\u306b\u306a\u3063\u3066\u3044\u308b\uff0e\u305f\u3044\u3066\u3044 .Count \u30d7\u30ed\u30d1\u30c6\u30a3\u3082\u30bb\u30c3\u30c8\u3067\u3064\u3044\u3066\u304a\u308a\uff0c\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u6700\u5f8c\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6b21\u306e\u3088\u3046\u306a\u5f62\u3067\u7279\u5b9a\u3067\u304d\u308b\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true \" title=\"\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u6700\u5f8c\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u53d6\u5f97\">With Objects\n    .Item(.Count).Select\nEnd with<\/pre>\n<p>\u3000\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3068\u306f\u540c\u7a2e\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u96c6\u5408\u306e\u3053\u3068\u3067\u3042\u308b\uff0eCharts, ChartObjects, FullSeriesCollection, SeriesCollection, ListObjects, Points \u3042\u305f\u308a\u304c\u6563\u5e03\u56f3\u306b\u95a2\u9023\u3059\u308b\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308b\uff0e<\/p>\n<h3>FullSeriesCollection \u306f Series \u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/h3>\n<p>\u3000\u3064\u3044\u3067\u306b FullSeriesCollection \u306b\u3082\u89e6\u308c\u3066\u304a\u304f\uff0e<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=6917\" target=\"_blank\" rel=\"noopener noreferrer\">\u6563\u5e03\u56f3\u306e\u30de\u30af\u30ed\u8a18\u9332<\/a>\u306b\u3088\u308b\u3068\uff0c\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f FullSeriesCollection \u3067\u53d6\u5f97\u3055\u308c\u308b\uff0e\u3053\u308c\u306f\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308a\uff0c\u4e00\u3064\u306e\u7cfb\u5217\u306f .Item \u30e1\u30bd\u30c3\u30c9\u306b\u3088\u308a\u7279\u5b9a\u3067\u304d\u308b\uff0e<\/p>\n<figure id=\"attachment_6991\" aria-describedby=\"caption-attachment-6991\" style=\"width: 573px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/006-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6991\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/006-1.png\" alt=\"\u6563\u5e03\u56f3\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u306fFullSeriesCollection\u3067\u53d6\u5f97\u3067\u304d\u308b\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308b\" width=\"573\" height=\"439\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/006-1.png 573w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/006-1-300x230.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><figcaption id=\"caption-attachment-6991\" class=\"wp-caption-text\">\u6563\u5e03\u56f3\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u306fFullSeriesCollection\u3067\u53d6\u5f97\u3067\u304d\u308b\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308b<\/figcaption><\/figure>\n<p>\u3000FullSeriesCollection \u306e\u89aa\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f Chart \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_6992\" aria-describedby=\"caption-attachment-6992\" style=\"width: 573px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/009.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6992\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/009.png\" alt=\"FullSeriesCollection\u306e\u89aa\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306fChart\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\" width=\"573\" height=\"476\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/009.png 573w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/009-300x249.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><figcaption id=\"caption-attachment-6992\" class=\"wp-caption-text\">FullSeriesCollection\u306e\u89aa\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306fChart\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b<\/figcaption><\/figure>\n<h3>SeriesCollection \u3082 Series \u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3<\/h3>\n<p>\u3000SeriesCollection \u3082\u307e\u305f\u6563\u5e03\u56f3\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308b\uff0e\u4e00\u3064\u306e\u7cfb\u5217\u306f .Item \u30e1\u30bd\u30c3\u30c9\u306b\u3088\u308a\u7279\u5b9a\u3067\u304d\u308b\uff0e<\/p>\n<figure id=\"attachment_6993\" aria-describedby=\"caption-attachment-6993\" style=\"width: 573px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/007-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6993\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/007-1.png\" alt=\"SeriesCollection\u306fSeries\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308a .Item\u30e1\u30bd\u30c3\u30c9\u306b\u3088\u308a\u7279\u5b9a\u3067\u304d\u308b\" width=\"573\" height=\"475\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/007-1.png 573w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/007-1-300x249.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><figcaption id=\"caption-attachment-6993\" class=\"wp-caption-text\">SeriesCollection\u306fSeries\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3067\u3042\u308a .Item\u30e1\u30bd\u30c3\u30c9\u306b\u3088\u308a\u7279\u5b9a\u3067\u304d\u308b<\/figcaption><\/figure>\n<p>\u3000SeiresCollection \u306e\u89aa\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f Chart \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_6994\" aria-describedby=\"caption-attachment-6994\" style=\"width: 574px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/008-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6994\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/008-1.png\" alt=\"SeriesCollection\u306e\u89aa\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306fChart\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b\" width=\"574\" height=\"476\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/008-1.png 574w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/07\/008-1-300x249.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/a><figcaption id=\"caption-attachment-6994\" class=\"wp-caption-text\">SeriesCollection\u306e\u89aa\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306fChart\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3067\u3042\u308b<\/figcaption><\/figure>\n<p>\u3000\u3082\u3046\u5c11\u3057\u7a81\u3063\u8fbc\u3093\u3067\u304a\u304f\u3068\uff0c.Item \u30e1\u30bd\u30c3\u30c9\u306e\u5f15\u6570\uff08\u30ab\u30c3\u30b3\u5185\u306e\u6570\u5b57\uff09\u306f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3067\u3042\u308a\uff0c1 \u304b\u3089\u9806\u756a\u306b\u52a0\u7b97\u3057\u3066\u3044\u3063\u3066\u30eb\u30fc\u30d7\u3092\u4f5c\u308b\u3053\u3068\u304c\u3067\u304d\u308b\uff0e\u6b21\u306e\u30c6\u30b9\u30c8\u30b3\u30fc\u30c9\u3067\u306f\u30a4\u30df\u30c7\u30a3\u30a8\u30a4\u30c8\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u540d\u524d\u3092\u9806\u306b\u51fa\u529b\u3059\u308b\uff0e<\/p>\n<pre class=\"lang:vbnet decode:true \" title=\"\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u540d\u524d\u3092\u9806\u306b\u51fa\u529b\">With Worksheets(1).ChartObjects(1).Chart\n    For i = 1 to .SeriesCollection.Item(.Count)\n        Debug.Print .SeriesCollection.Item(i).Name\n    Next i\nEnd with<\/pre>\n<h3>FullSeriesCollection \u3068 SeriesCollection, \u3069\u3046\u4f7f\u3044\u5206\u3051\u308b\uff1f<\/h3>\n<p>\u3000\u516c\u5f0f\u306b\u306f <a href=\"https:\/\/docs.microsoft.com\/ja-jp\/office\/vba\/api\/excel.fullseriescollection\" target=\"_blank\" rel=\"noopener noreferrer\">FullSeriesCollection<\/a> \u306f\u300c\u30b0\u30e9\u30d5\u306e Seires \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5b8c\u5168\u306a\u30bb\u30c3\u30c8\u300d\u3068\u306e\u3053\u3068\u3067\uff0c\u300c\u30d5\u30a3\u30eb\u30bf\u30fc\u3067\u9664\u5916\u3057\u305f Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3057\u305f\u308a\u518d\u9664\u5916\u3057\u305f\u308a\u3067\u304d\u308b\u300d\u305d\u3046\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/office\/vba\/api\/excel.seriescollection\" target=\"_blank\" rel=\"noopener noreferrer\">SeriesCollection<\/a> \u306f\u300c\u6307\u5b9a\u3055\u308c\u305f\u30b0\u30e9\u30d5\u307e\u305f\u306f\u30b0\u30e9\u30d5\u7a2e\u985e\u30b0\u30eb\u30fc\u30d7\u306b\u3042\u308b\u3059\u3079\u3066\u306e Series \u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u300d\u3060\u305d\u3046\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u3069\u3046\u306b\u3082\u3088\u304f\u5206\u304b\u3089\u306a\u3044\u304c\uff0c\u30d5\u30a3\u30eb\u30bf\u30fc\u306b\u95a2\u9023\u3057\u305f\u30c7\u30fc\u30bf\u3092\u6271\u3046\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u306f FullSeriesCollection \u306b\u3057\u3066\u304a\u3044\u305f\u65b9\u304c\u7121\u96e3\u3067\u3042\u308d\u3046\uff0e<\/p>\n<h3>\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u5897\u3084\u3057\u3066\u3044\u304f\u306a\u3089 SeriesCollection \u4e00\u629e<\/h3>\n<p>\u3000\u305d\u306e\u5f8c\u306e\u5b9f\u9a13\u3067\uff0cVBA \u3067\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u52d5\u7684\u306b\u8ffd\u52a0\u3057\u3066\u3044\u304f\u969b\u306b\u306f SeriesCollection \u304c\u3075\u3055\u308f\u3057\u3044\u3068\u601d\u308f\u308c\u305f\uff0e.NewSeries \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\uff0e<\/p>\n<figure id=\"attachment_7017\" aria-describedby=\"caption-attachment-7017\" style=\"width: 552px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/09\/011.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7017\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/09\/011.png\" alt=\"VBA\u306e\u30eb\u30fc\u30d7\u3067\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u5897\u3084\u3057\u305f\u3044\u5834\u5408\u306b\u306fSeriesCollection.NewSeries\u3092\u4f7f\u3046\" width=\"552\" height=\"458\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/09\/011.png 552w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/09\/011-300x249.png 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/a><figcaption id=\"caption-attachment-7017\" class=\"wp-caption-text\">VBA\u306e\u30eb\u30fc\u30d7\u3067\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u5897\u3084\u3057\u305f\u3044\u5834\u5408\u306b\u306fSeriesCollection.NewSeries\u3092\u4f7f\u3046<\/figcaption><\/figure>\n<p>\u3000\u591a\u6570\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u30eb\u30fc\u30d7\u5185\u3067\u5897\u3084\u3057\u305f\u3044\u5834\u5408\u304c\u305d\u308c\u306b\u5f53\u305f\u308b\uff0e\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9\u3092\u8f09\u305b\u3066\u304a\u3053\u3046\uff0e<\/p>\n<pre>Sub myDateSeries()\n\nDim myXValue()  As Double\nDim myValue()   As Long\nDim myName      As String\nDim myCht       As Chart\nDim mySeries    As Series\nDim mySht       As Worksheet\n\nSet mySht = ActiveSheet\nSet myCht = mySht.ChartObjects(1).Chart\n\nReDim myXValue(2)\nReDim myValue(2)\n\nmyXValue(0) = 0.2\nmyXValue(1) = 0.5\nmyXValue(2) = 0.7\nmyValue(0) = 3\nmyValue(1) = 5\nmyValue(2) = 7\n\nSet mySeries = myCht.SeriesCollection.NewSeries\n\nWith mySeries\n    .Name = \"SERIES1\"\n    .XValues = myXValue\n    .Values = myValue\nEnd With\n\nEnd Sub\n<\/pre>\n<p><a href=\"https:\/\/www.amazon.co.jp\/Microsoft-Office-%E3%82%AA%E3%83%B3%E3%83%A9%E3%82%A4%E3%83%B3%E3%82%B3%E3%83%BC%E3%83%89%E7%89%88-%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB%E5%8F%B0%E6%95%B0%E7%84%A1%E5%88%B6%E9%99%90-1TB%E3%81%AE%E3%82%B9%E3%83%88%E3%83%AC%E3%83%BC%E3%82%B8%E3%81%A4%E3%81%8D\/dp\/B00O2TXF8O\/ref=as_li_ss_il?__mk_ja_JP=%E3%82%AB%E3%82%BF%E3%82%AB%E3%83%8A&amp;crid=RCMWOEG1HNDV&amp;keywords=office+365+solo&amp;qid=1563352743&amp;s=gateway&amp;sprefix=of,aps,246&amp;sr=8-1&amp;linkCode=li3&amp;tag=gwho-22&amp;linkId=5bcff65c23f54aeabfcbf8cfab272383&amp;language=ja_JP\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=B00O2TXF8O&amp;Format=_SL250_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=gwho-22&amp;language=ja_JP\" border=\"0\" \/><\/a><img loading=\"lazy\" decoding=\"async\" style=\"border: none !important; margin: 0px !important;\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=gwho-22&amp;language=ja_JP&amp;l=li3&amp;o=9&amp;a=B00O2TXF8O\" alt=\"\" width=\"1\" height=\"1\" border=\"0\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000EXCEL \u306e\u30b0\u30e9\u30d5\u306e\u968e\u5c64\u69cb\u9020\u306f\u8907\u96d1\u3067\u3042\u308b\uff0e\u4e2d\u3067\u3082\u30c7\u30fc\u30bf\u7cfb\u5217\u306f\u57fa\u672c\u3067\u3042\u308a\u306a\u304c\u3089\u304a\u308d\u305d\u304b\u306b\u3055\u308c\u304c\u3061\u3067\u3042\u308b\uff0e\u4eca\u56de\u306f VBA \u306e\u8996\u70b9\u304b\u3089\u30b0\u30e9\u30d5\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u898b\u3066\u307f\u305f\u3044\uff0e<\/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":[4580,4583,4573,4574,4572,4571,4592,4566,4567,4557,4524,4584,265,4558,4560,4547,4577,4586,4528,2763,4569,4548,4576,4575,4561,4585,459,3897,4562,460,4554,346,1013,4581,3891,4594,1495,646,3576,1669,4555,4255,4552,4564,4845,4593,4587,4590,4591,4503,4579,4589,4563,4588,2975,4570,4578,4401,4626,4582,4556,2506,2834,4559,3525,4553],"class_list":{"0":"post-6963","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-technology","7":"tag-count","8":"tag-item-count","9":"tag-markerbackgroundcolor","10":"tag-markerforegroundcolor","11":"tag-markersize","12":"tag-markerstyle","13":"tag-newseries","14":"tag-values","15":"tag-xvalues","16":"tag-alt","17":"tag-chartobjects","18":"tag-charts","19":"tag-excel","20":"tag-f11","21":"tag-f2","22":"tag-fullseriescollection","23":"tag-item","24":"tag-listobjects","25":"tag-name","26":"tag-office-365-solo","27":"tag-point","28":"tag-points","31":"tag-series","32":"tag-seriescollection","33":"tag-vba","34":"tag-vbe","35":"tag-4562","36":"tag-460","37":"tag-4554","38":"tag-346","39":"tag-1013","40":"tag-4581","41":"tag-3891","42":"tag-4594","43":"tag-1495","44":"tag-646","45":"tag-3576","46":"tag-1669","47":"tag-4555","48":"tag-4255","49":"tag-4552","50":"tag-4564","51":"tag-4845","52":"tag-4593","53":"tag-4587","54":"tag-4590","55":"tag-4591","56":"tag-4503","57":"tag-4579","58":"tag-4589","59":"tag-4563","60":"tag-4588","61":"tag-2975","62":"tag-4570","63":"tag-4578","64":"tag-4401","65":"tag-4626","66":"tag-4582","67":"tag-4556","68":"tag-2506","69":"tag-2834","70":"tag-4559","71":"tag-3525","72":"tag-4553"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6963","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=6963"}],"version-history":[{"count":40,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6963\/revisions"}],"predecessor-version":[{"id":7897,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6963\/revisions\/7897"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}