{"id":12728,"date":"2020-05-03T13:57:06","date_gmt":"2020-05-03T04:57:06","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=12728"},"modified":"2020-09-03T16:03:04","modified_gmt":"2020-09-03T07:03:04","slug":"office-scripts%e3%82%b0%e3%83%a9%e3%83%95%e3%82%92%e4%bd%9c%e6%88%90%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=12728","title":{"rendered":"[Office Scripts]\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p>\u4eca\u56de\u306f\u3001Office Scripts\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p>Office Scripts\u3067\u306f\u3001<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/javascript\/api\/office-scripts\/excelscript\/excelscript.worksheet?WT.mc_id=M365-MVP-4029057#addchart-type--sourcedata--seriesby-\" title=\"ExcelScript.Worksheet interface - Office Scripts | Microsoft Docs\" target=\"_blank\" rel=\"noopener noreferrer\">(Worksheet).addChart<\/a>\u30e1\u30bd\u30c3\u30c9\u3067\u3001\u30b7\u30fc\u30c8\u4e0a\u306b\u30b0\u30e9\u30d5\u3092\u8ffd\u52a0\u3067\u304d\u307e\u3059\u3002<br \/>\ntype\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u3067\u6307\u5b9a\u3059\u308b\u30b0\u30e9\u30d5\u306e\u7a2e\u985e\u306b\u3064\u3044\u3066\u3001\u3069\u306e\u5024\u304c\u3069\u3093\u306a\u30b0\u30e9\u30d5\u306a\u306e\u304b\u304c\u5206\u304b\u308a\u3065\u3089\u3044\u306e\u3067\u3001\u79c1\u306f\u4e0b\u8a18\u30da\u30fc\u30b8\u3092\u53c2\u8003\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/support.office.com\/ja-jp\/article\/a6187218-807e-4103-9e0a-27cdb19afb90\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=support.office.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">support.office.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fsupport.office.com%2Fja-jp%2Farticle%2Fa6187218-807e-4103-9e0a-27cdb19afb90?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Office \u3067\u5229\u7528\u53ef\u80fd\u306a\u30b0\u30e9\u30d5\u306e\u7a2e\u985e<\/div><div class=\"lkc-url\" title=\"https:\/\/support.office.com\/ja-jp\/article\/a6187218-807e-4103-9e0a-27cdb19afb90\">https:\/\/support.office.com\/ja-jp\/article\/a6187218-807e-4103-9e0a-27cdb19afb90<\/div><div class=\"lkc-excerpt\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Excel \u3084\u4ed6\u306e Office \u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u4f7f\u7528\u3067\u304d\u308b\u591a\u69d8\u306a\u30b0\u30e9\u30d5\u306e\u7a2e\u985e\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002 \u30b0\u30e9\u30d5\u306e\u7a2e\u985e\u3068\u3057\u3066\u3001\u7e26\u68d2\u3001\u6298\u308c\u7dda\u3001\u5186\u3001\u6a2a\u68d2\u3001\u9762\u3001\u6563\u5e03\u56f3\u3001\u682a\u4fa1\u3001\u7b49\u9ad8\u7dda\u3001\u30ec\u30fc\u30c0\u30fc\u3001\u30c4\u30ea\u30fc\u30de\u30c3\u30d7\u3001\u30b5\u30f3\u30d0\u30fc\u30b9\u30c8\u3001\u30d2\u30b9\u30c8\u30b0\u30e9\u30e0\u3001\u7bb1\u3072\u3052\u56f3\u3001\u30a6\u30a9\u30fc\u30bf\u30fc\u30d5\u30a9\u30fc\u30eb\u304c\u3042\u308a\u307e\u3059\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/support.office.com\/en-us\/article\/a6187218-807e-4103-9e0a-27cdb19afb90\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=support.office.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">support.office.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fa6187218-807e-4103-9e0a-27cdb19afb90?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Available chart types in Office<\/div><div class=\"lkc-url\" title=\"https:\/\/support.office.com\/en-us\/article\/a6187218-807e-4103-9e0a-27cdb19afb90\">https:\/\/support.office.com\/en-us\/article\/a6187218-807e-4103-9e0a-27cdb19afb90<\/div><div class=\"lkc-excerpt\">This article describes the variety of chart types available in Excel and other Office programs. Chart types include column, line, pie, bar, area, scatter, stock, surface, radar, treemap, sunburst, histogram, box, whister, and waterfall.<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p>VBA\u306e<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/office\/vba\/api\/excel.xlcharttype?WT.mc_id=M365-MVP-4029057\" title=\"Xlcharttype \u30af\u30e9\u30b9\u5217\u6319 (Excel) | Microsoft Docs\" target=\"_blank\" rel=\"noopener noreferrer\">Xlcharttype<\/a>\u306e\u8aac\u660e\u3082\u53c2\u8003\u306b\u306a\u308b\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/docs.microsoft.com\/ja-jp\/office\/vba\/api\/excel.xlcharttype?WT.mc_id=M365-MVP-4029057\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=docs.microsoft.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">docs.microsoft.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Foffice%2Fvba%2Fapi%2Fexcel.xlcharttype%3FWT.mc_id%3DM365-MVP-4029057?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Xlcharttype \u30af\u30e9\u30b9\u5217\u6319 (Excel)<\/div><div class=\"lkc-url\" title=\"https:\/\/docs.microsoft.com\/ja-jp\/office\/vba\/api\/excel.xlcharttype?WT.mc_id=M365-MVP-4029057\">https:\/\/docs.microsoft.com\/ja-jp\/office\/vba\/api\/excel.xlcharttype?WT.mc_id=M365-MVP-4029057<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p><script src=\"https:\/\/gist.github.com\/kinuasa\/a53f046086fe29f961d56dc057486a32.js\"><\/script><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/OfficeScriptsAddcharts_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/OfficeScriptsAddcharts_02.jpg\" alt=\"\" width=\"1245\" height=\"631\" class=\"alignnone size-full wp-image-12912\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/OfficeScriptsAddcharts_02.jpg 1245w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/OfficeScriptsAddcharts_02-300x152.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/OfficeScriptsAddcharts_02-1024x519.jpg 1024w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/OfficeScriptsAddcharts_02-768x389.jpg 768w\" sizes=\"auto, (max-width: 1245px) 100vw, 1245px\" \/><\/a><\/p>\n<p>\u4e0a\u8a18\u30b3\u30fc\u30c9\u306e\u901a\u308a\u3001\u30bf\u30a4\u30c8\u30eb\u3084\u51e1\u4f8b\u7b49\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u304b\u3089\u69d8\u3005\u306a\u8a2d\u5b9a\u304c\u3067\u304d\u308b\u306e\u3067\u3059\u304c\u3001\u3053\u306e\u8fba\u308a\u306f\u3001<span style=\"color: #ff0000; font-weight: bold;\">\u30a4\u30f3\u30c6\u30ea\u30bb\u30f3\u30b9\u3067\u305d\u308c\u3063\u307d\u3044\u5019\u88dc<\/span>\u3092\u63a2\u3057\u3064\u3064\u3001<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/javascript\/api\/office-scripts\/excelscript\/excelscript.charttype?WT.mc_id=M365-MVP-4029057\" title=\"ExcelScript.ChartType enum - Office Scripts | Microsoft Docs\" target=\"_blank\" rel=\"noopener noreferrer\">\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/a>\u3092\u53c2\u7167\u3059\u308b\u3068(\u500b\u4eba\u7684\u306b\u306f)\u66f8\u304d\u3084\u3059\u3044\u3067\u3059\u3002<\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n<h4 class=\"style4a\">\u95a2\u9023\u8a18\u4e8b<\/h4>\n<div class=\"cardlink\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=12733\"><div class=\"cardlink_thumbnail\"><img src='https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-OfficeScripts-120x120.jpg' alt='Office Scripts(Office \u30b9\u30af\u30ea\u30d7\u30c8)\u306e\u8a18\u4e8b\u307e\u3068\u3081' width=120 height=120 \/><\/a><\/div><div class=\"cardlink_content\"><span class=\"timestamp\">2020.05.03<\/span><div class=\"cardlink_title\"><a href=\"https:\/\/www.ka-net.org\/blog\/?p=12733\">Office Scripts(Office \u30b9\u30af\u30ea\u30d7\u30c8)\u306e\u8a18\u4e8b\u307e\u3068\u3081 <\/a><\/div><div class=\"cardlink_excerpt\">\u5f53\u30d6\u30ed\u30b0\u306e\u300cOffice Scripts\u300d\u95a2\u9023\u306e\u8a18\u4e8b\u3092\u307e\u3068\u3081\u3066\u307f\u307e\u3057\u305f\u3002\r\n\r\n\r\nOffice Scripts\u306e\u57fa\u672c\r\n\u30bb\u30eb\u64cd\u4f5c\r\n\u30b7\u30fc\u30c8\u64cd\u4f5c\r\n\u56f3\u5f62\u30fb\u753b\u50cf\u64cd\u4f5c\r\n\u30c6\u30fc\u30d6\u30eb\u64cd\u4f5c\r\n\u30b0\u30e9\u30d5\u64cd\u4f5c\r\nPower Automate\u9023\u643a\r\n\u305d\u306e\u4ed6\r\n\r\n\r\n\r\n\r\nO...<\/div><\/div><div class=\"cardlink_footer\"><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"\u4eca\u56de\u306f\u3001Office Scripts\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 Office Scripts\u3067\u306f\u3001(Worksheet).addChart\u30e1\u30bd\u30c3\u30c9\u3067\u3001\u30b7\u30fc\u30c8\u4e0a\u306b\u30b0\u30e9\u30d5\u3092\u8ffd\u52a0\u3067\u304d\u307e\u3059\u3002 type\u30d1\u30e9\u30e1 [&hellip;]","protected":false},"author":1,"featured_media":12699,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[[Office Scripts]\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[173],"tags":[],"class_list":["post-12728","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-officescripts"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-OfficeScripts.jpg","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-3ji","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/12728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12728"}],"version-history":[{"count":8,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/12728\/revisions"}],"predecessor-version":[{"id":13111,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/12728\/revisions\/13111"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/12699"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}