大学生実験レポートを全力でお助け。

サボレポ

【エクセル】グラフの凡例の文字を上付き・下付き文字にする方法

&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;99 -->&NewLine;<div class&equals;"quads-location quads-ad3" id&equals;"quads-ad3" style&equals;"float&colon;none&semi;margin&colon;50px 0 50px 0&semi;text-align&colon;center&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-my-box st-mybox has-title st-title-border" style&equals;"background-color&colon;&num;fff&semi;border-width&colon;3px&semi;border-color&colon;&num;8ed1fc&semi;margin-top&colon;100px&semi;margin-bottom&colon;100px"><p class&equals;"st-mybox-title" style&equals;"color&colon;&num;8ed1fc&semi;font-weight&colon;bold&semi;border-bottom-color&colon;&num;8ed1fc&semi;background-color&colon;&num;fff"><i aria-hidden&equals;"true" class&equals;"fa fa-user st-css-no"><&sol;i>こんな方におすすめ<&sol;p><div class&equals;"st-in-mybox">&NewLine;<ul class&equals;"is-style-st-circle wp-block-list"><li>グラフの凡例に上付き文字・下付き文字を使いたい<&sol;li><&sol;ul>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-my-box st-mybox has-title st-title-border" style&equals;"background-color&colon;&num;fff&semi;border-width&colon;3px&semi;border-color&colon;&num;7bdcb5&semi;margin-top&colon;100px&semi;margin-bottom&colon;100px"><p class&equals;"st-mybox-title" style&equals;"color&colon;&num;7bdcb5&semi;font-weight&colon;bold&semi;border-bottom-color&colon;&num;7bdcb5&semi;background-color&colon;&num;fff"><i aria-hidden&equals;"true" class&equals;"fa fa-file-text-o st-css-no"><&sol;i>本記事の内容<&sol;p><div class&equals;"st-in-mybox">&NewLine;<ul class&equals;"is-style-st-circle wp-block-list"><li>凡例に上付き・下付き文字をつける2つの方法<ul><li>環境依存文字を使う方法<&sol;li><li>テキストボックスを使う方法<&sol;li><&sol;ul><&sol;li><&sol;ul>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<p>エクセルでグラフを作成する際,<strong>凡例で上付き文字・下付き文字をつけたい<&sol;strong>ときがあると思います。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<p>本記事では,その方法を解説します。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<h2 class&equals;"wp-block-heading">凡例に上付き・下付き文字をつける2つの方法<&sol;h2>&NewLine;&NewLine;&NewLine;&NewLine;<h3 class&equals;"wp-block-heading">環境依存文字を使う方法<&sol;h3>&NewLine;&NewLine;&NewLine;&NewLine;<p>このように,セルの内容がそのまま凡例に反映されます。(データは適当です。)<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image1-4-1024x414&period;png" alt&equals;"" class&equals;"wp-image-1475"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>上付きにしたい文字を選択し,環境依存文字に変換します。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image2-4&period;png" alt&equals;"" class&equals;"wp-image-1485"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>環境依存文字には,「&plus;」や「-」も用意されています。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image3-4&period;png" alt&equals;"" class&equals;"wp-image-1486"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>下付き文字も同様に変換してみましょう。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image4-4&period;png" alt&equals;"" class&equals;"wp-image-1487"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>これで完成です!<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image5-4-1024x464&period;png" alt&equals;"" class&equals;"wp-image-1488"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-flexbox st-header-flexwrap st-flexbox-left" style&equals;"width&colon;100&percnt;&semi;box-sizing&colon;border-box&semi;height&colon;auto&semi;background-color&colon;&num;fafafa&semi;border&colon;3px solid &num;fdebee&semi;border-radius&colon;5px&semi;padding&colon;20px"><div class&equals;"st-header-flexbox"><p class&equals;"st-header-flextitle" style&equals;"color&colon;&num;313131&semi;font-size&colon;200&percnt;"><i aria-hidden&equals;"true" class&equals;"fa fa-exclamation-circle st-css-no"><&sol;i>環境依存文字に変換しても凡例が変わらない場合<&sol;p>&NewLine;<p>「グラフのデザイン」&Implies;「データの選択」を選択。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image6-3-1024x496&period;png" alt&equals;"" class&equals;"wp-image-1489"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>「凡例項目」の部分が「Fe<sup>2&plus;<&sol;sup>」,「H<sub>2<&sol;sub>SO<sub>4<&sol;sub>」になっているか確認してください。もしなっていなかったら,セルの内容と凡例がうまく対応していません。「編集」を選択しましょう。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image7-3&period;png" alt&equals;"" class&equals;"wp-image-1490"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>「系列名」で凡例名にしたいセルを指定してください。これでうまく対応してくれるはずです。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image8-3&period;png" alt&equals;"" class&equals;"wp-image-1491"&sol;><&sol;figure>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<h3 class&equals;"wp-block-heading">テキストボックスを使う方法<&sol;h3>&NewLine;&NewLine;&NewLine;&NewLine;<p>テキストボックスを用いて,手動で凡例を入力する方法もあります。まず,グラフ内のプロットエリアを左にドラッグし,テキストボックスを置くスペースを設けます。<&sol;p>&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;99 -->&NewLine;<div class&equals;"quads-location quads-ad2" id&equals;"quads-ad2" style&equals;"float&colon;none&semi;margin&colon;50px 0 50px 0&semi;text-align&colon;center&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image9-3-1024x472&period;png" alt&equals;"" class&equals;"wp-image-1492"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>こんな感じです。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image10-3-1024x506&period;png" alt&equals;"" class&equals;"wp-image-1476"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>「挿入」&Implies;「テキストボックス」でテキストボックスを先ほどのスペースに設置します。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image11-3-1024x328&period;png" alt&equals;"" class&equals;"wp-image-1477"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>ここに手動で書いていきます。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image12-3-1024x371&period;png" alt&equals;"" class&equals;"wp-image-1478"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>入力しました。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image13-3-1024x364&period;png" alt&equals;"" class&equals;"wp-image-1479"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>次に,上付きにしたい文字を選択し,「Ctrl &plus; Shift &plus; F」を押します。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image14-3-1024x487&period;png" alt&equals;"" class&equals;"wp-image-1480"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>「Alt &plus; P」を押して,上付き文字にします。「Enter」で確定します。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image15-2&period;png" alt&equals;"" class&equals;"wp-image-1481"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>下付き文字も同様に行ってください。できたらこんな感じです。あとは,マークをつけるだけです。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image16-2-1024x503&period;png" alt&equals;"" class&equals;"wp-image-1482"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>「まる」と入力し,「●」に変換します。<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image17-2&period;png" alt&equals;"" class&equals;"wp-image-1483"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<p>あとは,適宜,「●」のサイズを変更し,色も変更します。これで完成です!<&sol;p>&NewLine;&NewLine;&NewLine;&NewLine;<figure class&equals;"wp-block-image size-large"><img src&equals;"https&colon;&sol;&sol;saborepo&period;com&sol;wp-content&sol;uploads&sol;2021&sol;07&sol;image18-2-1024x469&period;png" alt&equals;"" class&equals;"wp-image-1484"&sol;><&sol;figure>&NewLine;&NewLine;&NewLine;&NewLine;<h2 class&equals;"wp-block-heading">まとめ~比較してみる~<&sol;h2>&NewLine;&NewLine;&NewLine;&NewLine;<h3 class&equals;"wp-block-heading">環境依存文字を使う<&sol;h3>&NewLine;&NewLine;&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-midashi-box freebox has-title" style&equals;"background-color&colon;&num;fafafa&semi;border-width&colon;3px&semi;border-color&colon;&num;ffc107&semi;border-radius&colon;0 5px 5px 5px"><p class&equals;"p-free" style&equals;"border-color&colon;&num;ffc107&semi;font-weight&colon;bold"><span class&equals;"p-entry-f" style&equals;"color&colon;&num;313131&semi;font-weight&colon;bold&semi;background-color&colon;&num;ffc107&semi;border-radius&colon;0 0 5px 0"><i aria-hidden&equals;"true" class&equals;"fa fa-plus-circle st-css-no"><&sol;i>メリット<&sol;span><&sol;p><div class&equals;"free-inbox">&NewLine;<p>速い<&sol;p>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-midashi-box freebox has-title" style&equals;"background-color&colon;&num;fafafa&semi;border-width&colon;3px&semi;border-color&colon;&num;0693e3&semi;border-radius&colon;0 5px 5px 5px"><p class&equals;"p-free" style&equals;"border-color&colon;&num;0693e3&semi;font-weight&colon;bold"><span class&equals;"p-entry-f" style&equals;"color&colon;&num;313131&semi;font-weight&colon;bold&semi;background-color&colon;&num;0693e3&semi;border-radius&colon;0 0 5px 0"><i aria-hidden&equals;"true" class&equals;"fa fa-minus-circle st-css-no"><&sol;i>デメリット<&sol;span><&sol;p><div class&equals;"free-inbox">&NewLine;<p>1~9の数字,「&plus;&comma;-」の記号のみに限られている<&sol;p>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<h3 class&equals;"wp-block-heading">テキストボックスを使う<&sol;h3>&NewLine;&NewLine;&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-midashi-box freebox has-title" style&equals;"background-color&colon;&num;fafafa&semi;border-width&colon;3px&semi;border-color&colon;&num;ffc107&semi;border-radius&colon;0 5px 5px 5px"><p class&equals;"p-free" style&equals;"border-color&colon;&num;ffc107&semi;font-weight&colon;bold"><span class&equals;"p-entry-f" style&equals;"color&colon;&num;313131&semi;font-weight&colon;bold&semi;background-color&colon;&num;ffc107&semi;border-radius&colon;0 0 5px 0"><i aria-hidden&equals;"true" class&equals;"fa fa-plus-circle st-css-no"><&sol;i>メリット<&sol;span><&sol;p><div class&equals;"free-inbox">&NewLine;<p>どんな文字も上付き・下付きに変換できる<&sol;p>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<div class&equals;"wp-block-st-blocks-midashi-box freebox has-title" style&equals;"background-color&colon;&num;fafafa&semi;border-width&colon;3px&semi;border-color&colon;&num;0693e3&semi;border-radius&colon;0 5px 5px 5px"><p class&equals;"p-free" style&equals;"border-color&colon;&num;0693e3&semi;font-weight&colon;bold"><span class&equals;"p-entry-f" style&equals;"color&colon;&num;313131&semi;font-weight&colon;bold&semi;background-color&colon;&num;0693e3&semi;border-radius&colon;0 0 5px 0"><i aria-hidden&equals;"true" class&equals;"fa fa-minus-circle st-css-no"><&sol;i>デメリット<&sol;span><&sol;p><div class&equals;"free-inbox">&NewLine;<p>時間はかかる<&sol;p>&NewLine;<&sol;div><&sol;div>&NewLine;&NewLine;&NewLine;&NewLine;<p><&sol;p>&NewLine;&NewLine;<&excl;-- WP QUADS Content Ad Plugin v&period; 2&period;0&period;99 -->&NewLine;<div class&equals;"quads-location quads-ad1" id&equals;"quads-ad1" style&equals;"float&colon;none&semi;margin&colon;50px 0 50px 0&semi;text-align&colon;center&semi;">&NewLine;&NewLine;<&sol;div>&NewLine;&NewLine;