{"id":3640,"date":"2012-11-30T05:37:22","date_gmt":"2012-11-29T20:37:22","guid":{"rendered":"http:\/\/tsu\/?p=3640"},"modified":"2012-11-30T05:37:22","modified_gmt":"2012-11-29T20:37:22","slug":"excel-graph-name","status":"publish","type":"post","link":"https:\/\/www.hpymt.net\/tsu\/excel-graph-name\/","title":{"rendered":"Excel-\u30b0\u30e9\u30d5\u4f5c\u6210\u4f8b3(\u6c0f\u540d\u3092\u5165\u529b\u3057\u305f\u5834\u5408\uff09"},"content":{"rendered":"<p>Excel\u306b\u3088\u308b\u30b0\u30e9\u30d5\u306e\u4f5c\u6210\u306f\u3001\u5165\u529b\u3057\u305f\u9805\u76ee\u306b\u3088\u3063\u3066\u3001\u7c21\u5358\u306b\u306a\u3063\u305f\u308a\u3001\u8907\u96d1\u306b\u306a\u3063\u305f\u308a\u3057\u307e\u3059\u3002<\/p>\n<p>\u9805\u76ee\u540d\u3084\u30c7\u30fc\u30bf\u306e\u5165\u529b\u306e\u4ed5\u65b9\u3067\u4f5c\u6210\u3055\u308c\u308b\u30b0\u30e9\u30d5\u304c\u5909\u308f\u3063\u3066\u304d\u307e\u3059\u3002<\/p>\n<p>\u9805\u76ee\u540d\u304c\u6f22\u5b57\u3001\u6a2a\u8ef8\u3068\u306a\u308b\u3001\u3064\u304e\u306e\u884c\u4ee5\u964d\u304c\u6570\u5b57\u3067\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n<a title=\"Excel-\u30b0\u30e9\u30d5\u4f5c\u6210\u4f8b2(\u756a\u53f7\u3092\u5165\u529b\u3057\u305f\u5834\u5408\uff09\" href=\"https:\/\/www.hpymt.net\/tsu\/lecture\/excel-graph-num.html\" rel=\"bookmark\">Excel-\u30b0\u30e9\u30d5\u4f5c\u6210\u4f8b2(\u756a\u53f7\u3092\u5165\u529b\u3057\u305f\u5834\u5408\uff09<\/a><\/p>\n<p>\u3053\u3053\u3067\u306f\u3001\u6a2a\u8ef8\u306b\u6c0f\u540d\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306e\u6f14\u7fd2\u3067\u3059\u3002<br \/>\n\u30c7\u30fc\u30bf\u90e8\u5206\u304c\u3001\u6570\u5b57\u3060\u3051\u3067\u3042\u308c\u3070\u3001\u7c21\u5358\u306b\u30b0\u30e9\u30d5\u304c\u63cf\u3051\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u6b21\u306e\u4f8b\u306e\u3088\u3046\u306b\u3001\u3082\u3057\u6f22\u5b57\u304c\u542b\u307e\u308c\u305f\u5834\u5408\u3001\u304b\u306a\u308a\u306a\u90e8\u5206\u3092\u4fee\u6b63\u3057\u306a\u3051\u308c\u3070\u306a\u308a\u307e\u305b\u3093\u3002<\/p>\n<p>\u4ee5\u4e0b\u306f\u3001\u305d\u306e\u624b\u9806\u3067\u3059\u3002<\/p>\n<ol>\n<li>A2\u306b\u307e\u305a<span style=\"color: #ff0000;\"><strong>\u6c0f\u540d<\/strong><\/span>\u3001\u4e0b\u306e\u884c\u3001A\u5217\u306b\u306f<span style=\"color: #ff0000;\"><strong>\u540d\u524d<\/strong><\/span>\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u3068\u3057\u307e\u3059\u3002<\/li>\n<li>\u6b21\u306b\u30b0\u30e9\u30d5\u306b\u3057\u305f\u3044\u30c7\u30fc\u30bf\u3092\u3059\u3079\u3066<strong>\u30c9\u30e9\u30c3\u30b0<\/strong>\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/01select.png\" alt=\"01select\" \/><\/li>\n<li><strong>\u633f\u5165<\/strong>&#8211;<strong>\u30b0\u30e9\u30d5<\/strong>\uff0d<strong>\u7e26\u68d2<\/strong>\uff0d<strong>2D\u7e26\u68d2<\/strong>\uff0d<strong>\u96c6\u5408\u7e26\u68d2<\/strong>\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/02clusteredcolumnchart.png\" alt=\"02clusteredcolumnchart\" \/><\/li>\n<li>\u30b0\u30e9\u30d5\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u4f5c\u6210\u306b\u3042\u305f\u3063\u3066\u3001\u5bfe\u8c61\u3068\u306a\u308b\u30c7\u30fc\u30bf\u7bc4\u56f2\u304c\u5909\u308f\u3063\u3066\u304d\u307e\u3059\u3002<br \/>\n\u3053\u308c\u306f\u3001\u6b20\u5e2d\u3068\u3044\u3046\u6587\u5b57\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u305d\u3053\u307e\u3067\u304c\u9805\u76ee\u540d\u3067\u3042\u308b\u3068\u3001Excel\u304c\u5224\u65ad\u3059\u308b\u305f\u3081\u3067\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/03range.png\" alt=\"03range\" \/><br \/>\n\u305d\u3053\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u4fee\u6b63\u3057\u307e\u3059\u3002<\/li>\n<li>\u30b0\u30e9\u30d5\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u90e8\u5206\uff08\u30d7\u30ed\u30c3\u30c8\u30a8\u30ea\u30a2\uff09\u306b\u30de\u30a6\u30b9\u3092\u79fb\u52d5\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/04plotarea.png\" alt=\"04plotarea\" \/><\/li>\n<li><strong>\u53f3\u30af\u30ea\u30c3\u30af<\/strong>\u3057\u3001<strong>\u30c7\u30fc\u30bf\u306e\u9078\u629e<\/strong>\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/05selectdata.png\" alt=\"05selectdata\" \/><\/li>\n<li><strong>\u56fd\u8a9e<\/strong>\u304c\u9078\u3070\u308c\u3066\u3044\u308b\u306e\u3092\u78ba\u8a8d\u3057\u3001<strong>\u7de8\u96c6<\/strong>\u3092<strong>\u30af\u30ea\u30c3\u30af<\/strong>\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/06edit.png\" alt=\"06edit\" \/><\/li>\n<li>\u7cfb\u5217\u540d\u306e\u6b04\u3092B2\uff08\u56fd\u8a9e\uff09\u306b\u4e0a\u66f8\u304d\u3057\u307e\u3059\u3002\u305d\u308c\u306b\u306f\u6b21\u306e2\u3064\u306e\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n\uff11\uff0e\u6d88\u3057\u3066\u304b\u3089\u3001\u9805\u76ee9\u306e\u3088\u3046\u306bB2\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5<br \/>\n\uff12\uff0e\u4e0b\u306e\u3088\u3046\u306b\u3001=Sheet2!$B$2:$B$6 \u3092\u5168\u90e8\u9078\u3073\uff08\u30c9\u30e9\u30c3\u30b0\u3057\uff09\u3001\u9ed2\u304f\u53cd\u8ee2\u3057\u3066\u3044\u308b\u72b6\u614b\u3067\u3001\u9805\u76ee9\u756a\u306e\u3088\u3046\u306b\u3001B2\u3092\u6307\u5b9a\u3059\u308b\u65b9\u6cd5<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/07drag.png\" alt=\"07drag\" \/><\/li>\n<li>B2\u3092<strong>\u30af\u30ea\u30c3\u30af<\/strong>\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/08clickb2.png\" alt=\"08clickb2\" \/><\/li>\n<li>\u7cfb\u5217\u5024\u306e\u6b04\u3092\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/09drag.png\" alt=\"09drag\" \/><\/li>\n<li><span style=\"color: #ff0000;\"><strong>\u56fd\u8a9e<\/strong><\/span>\u306e\u30c7\u30fc\u30bf\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u6b04\uff08<strong><span style=\"color: #ff0000;\">B3\u304b\u3089B12\u307e\u3067<\/span><\/strong>\uff09\u3092\u30c9\u30e9\u30c3\u30b0\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/10b3-b12.png\" alt=\"10b3-b12\" \/><\/li>\n<li>\u56fd\u8a9e\u306e\u30c7\u30fc\u30bf\u6570\u3060\u3051\u30b0\u30e9\u30d5\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/11graph.png\" alt=\"11graph\" \/><\/li>\n<li>\u6570\u5b66\u3082\u4e0a\u3068\u540c\u69d8\u306b\u3057\u3066\u3001\u7de8\u96c6\u3057\u307e\u3059\u3002<br \/>\n<span style=\"color: #ff0000;\"><strong>\u6570\u5b66<\/strong><\/span>\u3092\u30af\u30ea\u30c3\u30af\u3001<span style=\"color: #ff0000;\"><strong>\u7de8\u96c6<\/strong><\/span>\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/12editmath.png\" alt=\"12editmath\" \/><\/li>\n<li>\u7cfb\u5217\u540d\u3068\u7cfb\u5217\u5024\u3092\u305d\u308c\u305e\u308c\u6b63\u3057\u3044\u5024\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/13c2.png\" alt=\"13c2\" \/><\/li>\n<li>\u82f1\u8a9e\u3082\u540c\u69d8\u306b\u3057\u3066\u7de8\u96c6\u3057\u307e\u3059\u3002<br \/>\n<span style=\"color: #ff0000;\"><strong>\u82f1\u8a9e<\/strong><\/span>\u3092\u30af\u30ea\u30c3\u30af\u3001<span style=\"color: #ff0000;\"><strong>\u7de8\u96c6<\/strong><\/span>\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/14editeng.png\" alt=\"14editeng\" \/><\/li>\n<li>\u7cfb\u5217\u540d\u3068\u7cfb\u5217\u5024\u3092\u305d\u308c\u305e\u308c\u6b63\u3057\u3044\u5024\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/15d2.png\" alt=\"15d2\" \/><\/li>\n<li>\uff13\u3064\u306e\u79d1\u76ee\u306e<strong><span style=\"color: #ff0000;\">\u7e26\u68d2<\/span><\/strong>\u3068\u53f3\u5074\u306e<strong><span style=\"color: #ff0000;\">\u5224\u4f8b<\/span><\/strong>\u304c\u6b63\u3057\u304f\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/16graph.png\" alt=\"16graph\" \/><br \/>\n\u6b21\u306b\u3001\u6a2a\u8ef8\u306e\u540d\u524d\u3092\u4fee\u6b63\u3057\u307e\u3059\u3002<\/li>\n<li>\u53f3\u5074\u306e\u6b04\u3001<span style=\"color: #ff0000;\"><strong>\u6a2a\uff08\u9805\u76ee\uff09\u8ef8\u30e9\u30d9\u30eb<\/strong><\/span>\u306e<strong><span style=\"color: #ff0000;\">\u7de8\u96c6<\/span><\/strong>\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/17horizontalaxis.png\" alt=\"17horizontalaxis\" \/><\/li>\n<li>\u4eba\u6570\u5206\u306e\u6c0f\u540d\uff08<span style=\"color: #ff0000;\"><strong>A3\u304b\u3089A12\u307e\u3067<\/strong><\/span>\uff09\u3092\u30c9\u30e9\u30c3\u30b0\u3057\u3001\u6b63\u3057\u3044\u5024\u306b\u5909\u66f4\u3057\u307e\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/18a3to12.png\" alt=\"18a3to12\" \/><\/li>\n<li>OK\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\uff08\u6589\u6728\u304b\u3089\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\uff09<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/19ok.png\" alt=\"19ok\" \/><\/li>\n<li>\u6a2a\u8ef8\u306b\u6c0f\u540d\u304c\u6b63\u3057\u304f\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002\u5b8c\u6210\u3067\u3059\u3002<br \/>\n<img decoding=\"async\" src=\"..\/intro2\/graph3\/20finished.png\" alt=\"20finished\" \/><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u306b\u3088\u308b\u30b0\u30e9\u30d5\u306e\u4f5c\u6210\u306f\u3001\u5165\u529b\u3057\u305f\u9805\u76ee\u306b\u3088\u3063\u3066\u3001\u7c21\u5358\u306b\u306a\u3063\u305f\u308a\u3001\u8907\u96d1\u306b\u306a\u3063\u305f\u308a\u3057\u307e\u3059\u3002 \u9805\u76ee\u540d\u3084\u30c7\u30fc\u30bf\u306e\u5165\u529b\u306e\u4ed5\u65b9\u3067\u4f5c\u6210\u3055\u308c\u308b\u30b0\u30e9\u30d5\u304c\u5909\u308f\u3063\u3066\u304d\u307e\u3059\u3002 \u9805\u76ee\u540d\u304c\u6f22\u5b57\u3001\u6a2a\u8ef8\u3068\u306a\u308b\u3001\u3064\u304e\u306e\u884c\u4ee5\u964d\u304c\u6570\u5b57\u3067\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.hpymt.net\/tsu\/excel-graph-name\/\">\u7d9a\u304d\u3092\u8aad\u3080 &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,13,14,16],"tags":[70,92,93,103],"class_list":["post-3640","post","type-post","status-publish","format-standard","hentry","category-lecture","category-nyumon","category-pctips","category-software","tag-chart","tag-excel","tag-excel2010","tag-graph"],"_links":{"self":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts\/3640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/comments?post=3640"}],"version-history":[{"count":0,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/posts\/3640\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/media?parent=3640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/categories?post=3640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hpymt.net\/tsu\/wp-json\/wp\/v2\/tags?post=3640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}