{"id":7,"date":"2006-08-12T17:43:52","date_gmt":"2006-08-12T17:43:52","guid":{"rendered":"http:\/\/blogs.wabash.edu\/technotes\/2006\/08\/12\/excel-tip-creating-in-cell-bar-charts\/"},"modified":"2006-08-12T17:43:52","modified_gmt":"2006-08-12T17:43:52","slug":"excel-tip-creating-in-cell-bar-charts","status":"publish","type":"post","link":"https:\/\/blog.wabash.edu\/technotes\/2006\/08\/12\/excel-tip-creating-in-cell-bar-charts\/","title":{"rendered":"Excel Tip: Creating In-Cell Bar Charts"},"content":{"rendered":"<p style=\"margin-top: 0\">Quentin came across a cool Excel tip the other day on the Juice Analytics blog &#8212; creating in-cell bar charts. Using the Excel <b>REPT<\/b> function, you can quickly and easily add a visual representation of a list of numbers, as demonstrated in the following spreadsheet:<\/p>\n<p style=\"margin-top: 0\"><img decoding=\"async\" align=\"center\" src=\"http:\/\/blogs.wabash.edu\/www2images\/excel_incell_graph.jpg\" alt=\"\" \/><\/p>\n<p>For more examples, and instructions on using this tool, see the Juice Analytics blog entry at <a class=\"moz-txt-link-freetext\" href=\"http:\/\/www.juiceanalytics.com\/weblog\/?p=236\">http:\/\/www.juiceanalytics.com\/weblog\/?p=236<\/a>.<\/p>\n<p><i>Have a suggestion for the Tip Jar? &nbsp;Send it to IT Services at <a href=\"mailto:tipjar@wabash.edu\">tipjar@wabash.edu<\/a> for a chance to win a $20.00 gift certificate to the Wabash Bookstore. &nbsp;Learn more here.<\/i><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quentin came across a cool Excel tip the other day on the Juice Analytics blog &#8212; creating in-cell bar charts. Using the Excel REPT function, you can quickly and easily add a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"w_featured_image_url":"","_links":{"self":[{"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/comments?post=7"}],"version-history":[{"count":0,"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/posts\/7\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/media?parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/categories?post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wabash.edu\/technotes\/wp-json\/wp\/v2\/tags?post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}