{"id":441,"date":"2021-01-24T21:25:39","date_gmt":"2021-01-24T21:25:39","guid":{"rendered":"http:\/\/drstephenrobertson.com\/hist395\/?page_id=441"},"modified":"2021-01-24T21:25:39","modified_gmt":"2021-01-24T21:25:39","slug":"google-sheets-creating-a-chart","status":"publish","type":"page","link":"https:\/\/drstephenrobertson.com\/hist395\/google-sheets-creating-a-chart\/","title":{"rendered":"Google Sheets: Creating a chart"},"content":{"rendered":"<p>To create the graph of the word length of your stories that is on the first page of the example:<\/p>\n<p>The chart is created in Google sheets, from your dataset: the word length is column O.<\/p>\n<p>To have the graph show longest to shortest you need to first sort the data based on column O<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>select column O, then click on Data in menu at the top of page under the sheet title and select &#8216;Sort sheet by column o Z-A [highest to lowest].<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>To create the graph<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>With column O selected, click on the insert chart button on the far right of the toolbar [the box with the 3 columns in it].<\/li>\n<li>It will open the chart editor and create a chart &#8211; a line graph is usually the default, but the first option in the set-up tab of the chart editor is chart type, and you can change it to the bar graph I used.<\/li>\n<li>Under the Customize tab are options to change the chart title etc.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>To add the graph to your Omeka site you download an image of the chart to your computer, and then upload that image as an item in Omeka.<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Click on the 3 dots in the top right corner of the chart<\/li>\n<li>Select Download as and then then the .png option<\/li>\n<li>The instructions for <a href=\"https:\/\/drstephenrobertson.com\/hist395\/resources\/adding-an-item-to-omeka-s\/\" target=\"_blank\" rel=\"noopener noreferrer\">uploading an item<\/a> are in the assignment instructions on the course website.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>To create the graph of the word length of your stories that is on the first page of the example: The chart is created in Google sheets, from your dataset: the word length is column&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"fullwidth.php","meta":{"footnotes":""},"class_list":["post-441","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages\/441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/comments?post=441"}],"version-history":[{"count":1,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages\/441\/revisions"}],"predecessor-version":[{"id":442,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages\/441\/revisions\/442"}],"wp:attachment":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/media?parent=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}