{"id":39824,"date":"2018-07-30T03:01:52","date_gmt":"2018-07-29T17:01:52","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/ITblog\/?p=39824"},"modified":"2018-07-29T13:58:45","modified_gmt":"2018-07-29T03:58:45","slug":"microsoft-excel-spreadsheet-line-chart-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/microsoft-excel-spreadsheet-line-chart-primer-tutorial\/","title":{"rendered":"Microsoft Excel Spreadsheet Line Chart Primer Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/data_gov_excel_line_chart.pdf\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Microsoft Excel Spreadsheet Line Chart Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/data_gov_excel_line_chart.jpg\" title=\"Microsoft Excel Spreadsheet Line Chart Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">Microsoft Excel Spreadsheet Line Chart Primer Tutorial<\/p><\/div>\n<p>The recent <a title='LibreOffice Spreadsheet via dBase Primer Tutorial' href='#losbpt'>LibreOffice Spreadsheet via dBase Primer Tutorial<\/a> mentioned &#8230;<\/p>\n<blockquote><p>\n &#8230; and amongst the many functionalities in &#8220;not shown&#8221; you should know that spreadsheets and charts are good bedfellows of functionality<\/p>\n<\/blockquote\n\n\n\n<p> &#8230; and so today we &#8230;<\/p>\n<ul>\n<li>again use the brilliant United States data resource website <a target=_blank title='US data.gov' href='http:\/\/data.gov'>data.gov<\/a> website to search for some State based spending data and arrived at some collected regarding &#8220;Spending in the State of Maryland in the Fiscal Year 2010&#8221; &#8230; so &#8230;<\/li>\n<li>downloaded the CSV form of this data &#8230; thanks &#8230; and &#8230;<\/li>\n<li>in Mac OS X Finder desktop application on this MacBook Pro opened the CSV file downloaded into the wonderful Microsoft <a target=_blank title='Excel information from Microsoft' href='https:\/\/products.office.com\/en-us\/excel'>Excel<\/a> desktop application &#8230;<\/li>\n<li>within Excel we highlighted 6 (7++ started causing an error) columns of interest we could use in conjunction with &#8230;<\/li>\n<li>Insert -&gt; Chart &gt; Line to create an interesting Line Chart &#8230; we &#8230;<\/li>\n<li>drag and resize into position &#8230; and &#8230;<\/li>\n<li>click on the chart title to adjust it &#8230; then &#8230;<\/li>\n<li>File -&gt; SaveAs&#8230; &#8230; Web Page (.htm) to &#8220;Our Mac&#8221; &#8230; which involved, for us &#8230;<\/li>\n<li>many fonts downloaded to the MacBook Pro and eventually the *.htm was saved and worked locally with a file:\/\/ type of URL &#8230; so we &#8230;<\/li>\n<li>uploaded those Web Page (.htm) files to rjmprogramming.com.au domain &#8230; that we can show you <a target=_blank title='Chart' href='\/\/www.rjmprogramming.com.au\/Mac\/Per_Capita_County_Expenditures_By_Category___Fiscal_Year_2010.htm'>as below<\/a> &#8230;<br \/>\n<iframe style='width:100%;height:720px;' src='\/\/www.rjmprogramming.com.au\/Mac\/Per_Capita_County_Expenditures_By_Category___Fiscal_Year_2010.htm#chartimg' title='Maryland, USA 2010 Spending'><\/iframe>\n<\/li>\n<\/ul>\n<p><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/data_gov_excel_line_chart.pdf\" title=\"Click picture\">Interesting, huh?!<\/a>   And you could do this, too, with <a target=_blank title='LibreOffice' href='http:\/\/libreoffice.org'>LibreOffice<\/a>.<\/p>\n<hr>\n<p id='losbpt'>Previous relevant <a target=_blank title='LibreOffice Spreadsheet via dBase Primer Tutorial' href='\/\/www.rjmprogramming.com.au\/ITblog\/libreoffice-spreadsheet-via-dbase-primer-tutorial\/'>LibreOffice Spreadsheet via dBase Primer Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice_dbf_xls_pivot_table.pdf\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"LibreOffice Spreadsheet via dBase Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice_dbf_xls_pivot_table.jpg\" title=\"LibreOffice Spreadsheet via dBase Primer Tutorial\"  \/><\/a><p class=\"wp-caption-text\">LibreOffice Spreadsheet via dBase Primer Tutorial<\/p><\/div>\n<p>When we presented the blog posting thread ending with <a target=_blank href='https:\/\/www.rjmprogramming.com.au\/ITblog\/dams-in-the-united-states-timeline-tutorial\/' title='Dams in the United States Timeline Tutorial'>Dams in the United States Timeline Tutorial<\/a> its data basis had the same origin as today&#8217;s, that being the wonderful United States data resource website <a target=_blank title='US data.gov' href='http:\/\/data.gov'>data.gov<\/a> website.  From there we got to a website of interest, as following our interest in bees (and ants) to <a target=_blank title='El Programa Cooperativo Sobre la Apifauna Mexicana' href='http:\/\/wwx.inhs.illinois.edu\/collections\/insect\/data\/mexican-bee\/'>El Programa Cooperativo Sobre la Apifauna Mexicana<\/a> (a database in <a target=_blank title='dBase database' href='http:\/\/www.dbase.com\/'>dBase<\/a> format &#8230;<\/p>\n<blockquote cite='http:\/\/wwx.inhs.illinois.edu\/collections\/insect\/data\/mexican-bee\/'><p>\nThe PCAM (El Programa Cooperativo Sobre la Apifauna Mexicana) Database of Mexican Bees,with Floral Records;by Douglas Yanega, Illinois Natural History Survey. Funded by NSF Grant#BSR-90-24723 to Wallace E. LaBerge (INHS) and Ronald J. McGinley (Smithsonian Institution), principal investigators.\n<\/p><\/blockquote>\n<p> &#8230; regarding Mexican bees).<\/p>\n<p>We then realized these loose dBase database files have header records within them, where there is enough information for those (previously readable by FoxPro) dBase database (*.dbf) files be read by <a target=_blank title='LibreOffice' href='http:\/\/libreoffice.org'>LibreOffice<\/a> Spreadsheet functionality and then Save As Microsoft Excel *.xlsx format.<\/p>\n<p>As might be more familiar to most of us, once you have the data in Microsoft Excel *.xlsx format, a whole new world of functionality is available to you, some of which we touch on with today&#8217;s <a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Mac\/LibreOffice_dbf_xls_pivot_table.pdf\" title=\"Click picture\">PDF slideshow<\/a> presentation &#8230;<\/p>\n<ul>\n<li>formulae best applicable to numerical data columns of the spreadsheet<\/li>\n<li>scenarios &#8230; like views of the data with styling choices<\/li>\n<li>pivot table creation to check the validity of data, a pretty important tool for large data sets, as a pivot table can summarize and collate the data to check for weird aberrations perhaps<\/li>\n<\/ul>\n<p> &#8230; and amongst the many functionalities in &#8220;not shown&#8221; you should know that spreadsheets and charts are good bedfellows of functionality.<\/p>\n<p>We hope this synergy between spreadsheets and RDBMS (relational database management system) systems is of help to you.<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d39709' onclick='var dv=document.getElementById(\"d39709\"); dv.innerHTML = \"<iframe width=670 height=600 src=\" + \"\/\/www.rjmprogramming.com.au\/ITblog\/tag\/database\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d39709' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d39824' onclick='var dv=document.getElementById(\"d39824\"); dv.innerHTML = \"<iframe width=670 height=600 src=\" + \"\/\/www.rjmprogramming.com.au\/ITblog\/tag\/chart\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d39824' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The recent LibreOffice Spreadsheet via dBase Primer Tutorial mentioned &#8230; &#8230; and amongst the many functionalities in &#8220;not shown&#8221; you should know that spreadsheets and charts are good bedfellows of functionality<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[199,230,290,403,699,782,785,1185,1319],"class_list":["post-39824","post","type-post","status-publish","format-standard","hentry","category-uncategorised","tag-chart","tag-column","tag-data","tag-excel","tag-line-chart","tag-microsoft","tag-microsoft-office","tag-spreadsheet","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/39824"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=39824"}],"version-history":[{"count":5,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/39824\/revisions"}],"predecessor-version":[{"id":39829,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/39824\/revisions\/39829"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=39824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=39824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=39824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}