{"id":388,"date":"2020-06-05T02:02:23","date_gmt":"2020-06-05T06:02:23","guid":{"rendered":"http:\/\/blog.fitnyc.edu\/professorshloming\/?p=388"},"modified":"2020-06-05T02:02:23","modified_gmt":"2020-06-05T06:02:23","slug":"how-do-you-get-the-legend-to-be-correct-without-editing-it-after-the-chart-shows-up","status":"publish","type":"post","link":"https:\/\/blog.fitnyc.edu\/professorshloming\/2020\/06\/05\/how-do-you-get-the-legend-to-be-correct-without-editing-it-after-the-chart-shows-up\/","title":{"rendered":"How do you get the legend to be correct without editing it after the chart shows up?"},"content":{"rendered":"<p>How do you get the legend to be correct without editing it after the chart shows up?<\/p>\n<p>ANSWER: So, in the last few years Google does make it a bit tricky to edit legends in charts for some reason. One quick solution is to write down what you want the legend to say in spreadsheet cells. For the module 2 spreadsheet you are asked to make any chart but many students choose to create a column chart comparing current data with older data. I enjoy these charts but a legend is necessary to know which color corresponds to which data set.<\/p>\n<p>Here is what I do:<\/p>\n<ul>\n<li>In this case I am going to make a chart looking at the percentages. (If you were making one with frequencies then you would be labeling the frequencies.) To make a distinction I edit the label percentage for each data set so they are unique and clearly represent each data set. In this case I am going to write 2020 percentage and 2000 percentage.<\/li>\n<li><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}-->What the first rows look like:<br \/>\n<table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col width=\"158\" \/>\n<col width=\"100\" \/>\n<col width=\"133\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/><\/colgroup>\n<tbody>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Places We Currently Live (2020)&quot;}\">Places We Currently Live (2020)<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;2020 Percentage &quot;}\"><em><strong>2020 Percentage<\/strong><\/em><\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Frequency&quot;}\">Frequency<\/td>\n<td data-sheets-numberformat=\"[null,3,&quot;0%&quot;,1,1]\"><\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Places We Lived 20 Years Ago&quot;}\">Places We Lived 20 Years Ago<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;2000 Percentage&quot;}\"><em><strong>2000 Percentage<\/strong><\/em><\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Frequency&quot;}\">Frequency<\/td>\n<\/tr>\n<tr>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Brooklyn&quot;}\">Brooklyn<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.125}\" data-sheets-numberformat=\"[null,3,&quot;0.00%&quot;,1]\" data-sheets-formula=\"=1\/8\">12.50%<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:1}\">1<\/td>\n<td data-sheets-numberformat=\"[null,3,&quot;0%&quot;,1,1]\"><\/td>\n<td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Brooklyn&quot;}\">Brooklyn<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:0.75}\" data-sheets-numberformat=\"[null,3,&quot;0.00%&quot;,1]\" data-sheets-formula=\"=6\/8\">75.00%<\/td>\n<td data-sheets-value=\"{&quot;1&quot;:3,&quot;3&quot;:6}\">6<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<li>That&#8217;s really it! You highlight ALL the cells that have the data you want including the headers\/descriptive word cells and it will show up in the legend:<\/li>\n<li>\n<figure id=\"attachment_386\" aria-describedby=\"caption-attachment-386\" style=\"width: 150px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/06\/a-title-would-go-here-_.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-thumbnail wp-image-386\" src=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/06\/a-title-would-go-here-_-150x150.png\" alt=\"chart with correct legend\" width=\"150\" height=\"150\" \/><\/a><figcaption id=\"caption-attachment-386\" class=\"wp-caption-text\">chart with correct legend<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p><figure id=\"attachment_387\" aria-describedby=\"caption-attachment-387\" style=\"width: 150px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/06\/Screen-Shot-2020-06-05-at-1.57.25-AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-thumbnail wp-image-387\" src=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/06\/Screen-Shot-2020-06-05-at-1.57.25-AM-150x150.png\" alt=\"creating an accurate legend with google spreadsheets\" width=\"150\" height=\"150\" \/><\/a><figcaption id=\"caption-attachment-387\" class=\"wp-caption-text\">creating an accurate legend with google spreadsheets<\/figcaption><\/figure><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How do you get the legend to be correct without editing it after the chart shows up? ANSWER: So, in the last few years Google does make it a bit tricky to edit legends in charts for some reason. One quick solution is to write [&hellip;]<\/p>\n","protected":false},"author":386,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","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},"jetpack_post_was_ever_published":false},"categories":[26127,28563,28562],"tags":[],"class_list":["post-388","post","type-post","status-publish","format-standard","hentry","category-assignments","category-googledocs-help","category-ma222"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ANrd-6g","_links":{"self":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/posts\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/users\/386"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/comments?post=388"}],"version-history":[{"count":0,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/posts\/388\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/media?parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/categories?post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/tags?post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}