{"id":41516,"date":"2012-11-20T00:00:00","date_gmt":"2012-11-20T06:00:00","guid":{"rendered":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/"},"modified":"2012-11-20T00:00:00","modified_gmt":"2012-11-20T06:00:00","slug":"weekly-e-tip-prepare-excel-data-for-graphs","status":"publish","type":"post","link":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/","title":{"rendered":"Weekly e-Tip – Prepare Excel data for graphs"},"content":{"rendered":"

I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?<\/B><\/p>\n

One new feature of Excel 2010 is the ability to create “sparklines” for individual rows of data. Sparklines are a simple way to show individual “mini” graphs in cells next to your numbers. Check out this free short training course<\/a>. <\/p>\n

Otherwise, most people use charts based on data in a spreadsheet, or from pivot tables. You need to identify the data you wish to place in chart and determine which type of chart to use, and then customize with a number of options. There are many types of charts that can be used, based on the type of data you need to analyze. Here is a basic training course in charts<\/a>. <\/p>\n

For a “crash” course in creating and working with a variety of Excel Charts, come to the ITS mini-session on Monday, Nov. 26 from 1 to 2:30 p.m. You’ll work on a variety of examples and learn to work with a charts of all types. You’ll also learn what charts to avoid. We will also have a drop in Help session following from 2:30 to 3:30 p.m. for those who want more one-on-one help with their projects.<\/p>\n

Register for this session<\/a>.<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"

I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?<\/p>\n","protected":false},"author":94,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-41516","post","type-post","status-publish","format-standard","hentry","category-uncategorized","topic-inside-unmc","department-unmc-today-todays-headlines"],"yoast_head":"\nWeekly e-Tip - Prepare Excel data for graphs<\/title>\n<meta name=\"description\" content=\"I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Weekly e-Tip - Prepare Excel data for graphs\" \/>\n<meta property=\"og:description\" content=\"I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\" \/>\n<meta property=\"og:site_name\" content=\"Newsroom\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/unmcedu\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-20T06:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Chuck Brown\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@unmc\" \/>\n<meta name=\"twitter:site\" content=\"@unmc\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chuck Brown\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\"},\"author\":{\"name\":\"Chuck Brown\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/person\/f99efde0b91c6c20a256357d501c35d3\"},\"headline\":\"Weekly e-Tip – Prepare Excel data for graphs\",\"datePublished\":\"2012-11-20T06:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\"},\"wordCount\":225,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\",\"url\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\",\"name\":\"Weekly e-Tip - Prepare Excel data for graphs\",\"isPartOf\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#website\"},\"datePublished\":\"2012-11-20T06:00:00+00:00\",\"description\":\"I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?\",\"breadcrumb\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.unmc.edu\/newsroom\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Weekly e-Tip – Prepare Excel data for graphs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#website\",\"url\":\"https:\/\/www.unmc.edu\/newsroom\/\",\"name\":\"Newsroom\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.unmc.edu\/newsroom\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#organization\",\"name\":\"University of Nebraska Medical Center\",\"url\":\"https:\/\/www.unmc.edu\/newsroom\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.unmc.edu\/newsroom\/wp-content\/uploads\/2022\/08\/overview-1.png\",\"contentUrl\":\"https:\/\/www.unmc.edu\/newsroom\/wp-content\/uploads\/2022\/08\/overview-1.png\",\"width\":500,\"height\":153,\"caption\":\"University of Nebraska Medical Center\"},\"image\":{\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/unmcedu\",\"https:\/\/x.com\/unmc\",\"https:\/\/instagram.com\/iamunmc\",\"https:\/\/www.youtube.com\/user\/UNMCEDU\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/person\/f99efde0b91c6c20a256357d501c35d3\",\"name\":\"Chuck Brown\",\"url\":\"https:\/\/www.unmc.edu\/newsroom\/author\/f4b9ec30ad9f68f89b29639786cb62ef\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Weekly e-Tip - Prepare Excel data for graphs","description":"I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/","og_locale":"en_US","og_type":"article","og_title":"Weekly e-Tip - Prepare Excel data for graphs","og_description":"I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?","og_url":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/","og_site_name":"Newsroom","article_publisher":"https:\/\/www.facebook.com\/unmcedu","article_published_time":"2012-11-20T06:00:00+00:00","author":"Chuck Brown","twitter_card":"summary_large_image","twitter_creator":"@unmc","twitter_site":"@unmc","twitter_misc":{"Written by":"Chuck Brown","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#article","isPartOf":{"@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/"},"author":{"name":"Chuck Brown","@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/person\/f99efde0b91c6c20a256357d501c35d3"},"headline":"Weekly e-Tip – Prepare Excel data for graphs","datePublished":"2012-11-20T06:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/"},"wordCount":225,"commentCount":0,"publisher":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/","url":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/","name":"Weekly e-Tip - Prepare Excel data for graphs","isPartOf":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#website"},"datePublished":"2012-11-20T06:00:00+00:00","description":"I have a lot of Excel data I need to prepare graphs for and am not sure where to start. How do you recommend I get started?","breadcrumb":{"@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.unmc.edu\/newsroom\/2012\/11\/20\/weekly-e-tip-prepare-excel-data-for-graphs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.unmc.edu\/newsroom\/"},{"@type":"ListItem","position":2,"name":"Weekly e-Tip – Prepare Excel data for graphs"}]},{"@type":"WebSite","@id":"https:\/\/www.unmc.edu\/newsroom\/#website","url":"https:\/\/www.unmc.edu\/newsroom\/","name":"Newsroom","description":"","publisher":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.unmc.edu\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.unmc.edu\/newsroom\/#organization","name":"University of Nebraska Medical Center","url":"https:\/\/www.unmc.edu\/newsroom\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/logo\/image\/","url":"https:\/\/www.unmc.edu\/newsroom\/wp-content\/uploads\/2022\/08\/overview-1.png","contentUrl":"https:\/\/www.unmc.edu\/newsroom\/wp-content\/uploads\/2022\/08\/overview-1.png","width":500,"height":153,"caption":"University of Nebraska Medical Center"},"image":{"@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/unmcedu","https:\/\/x.com\/unmc","https:\/\/instagram.com\/iamunmc","https:\/\/www.youtube.com\/user\/UNMCEDU"]},{"@type":"Person","@id":"https:\/\/www.unmc.edu\/newsroom\/#\/schema\/person\/f99efde0b91c6c20a256357d501c35d3","name":"Chuck Brown","url":"https:\/\/www.unmc.edu\/newsroom\/author\/f4b9ec30ad9f68f89b29639786cb62ef\/"}]}},"_links":{"self":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/posts\/41516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/comments?post=41516"}],"version-history":[{"count":0,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/posts\/41516\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/media?parent=41516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/categories?post=41516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.unmc.edu\/newsroom\/wp-json\/wp\/v2\/tags?post=41516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}