{"id":171088,"date":"2013-02-06T16:36:50","date_gmt":"2013-02-06T16:36:50","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/project\/microsoft-research-data-visualization-apps-for-office\/"},"modified":"2016-09-07T18:38:05","modified_gmt":"2016-09-08T01:38:05","slug":"microsoft-research-data-visualization-apps-for-office","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/microsoft-research-data-visualization-apps-for-office\/","title":{"rendered":"Microsoft Research Data Visualization Apps for Office"},"content":{"rendered":"<p class=\"asset-content\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/microsoft-research-data-visualization-apps-for-office-2.png\" alt=\"\" width=\"96\" height=\"96\" \/><em><strong>This project has now been\u00a0concluded, and the apps have been deprecated. Thank you for your feedback!<\/strong><\/em><\/p>\n<hr \/>\n<p class=\"asset-content\">At Microsoft Research, we want to let users play with\u00a0new types of visualizations. We\u2019re doing it with <strong><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"https:\/\/store.office.com\/\">Apps for Office<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>, <\/strong>a new feature for Office 2013 and Office 365. These let users easily add new functionality to Office.<\/p>\n<p>You can see some of how the system worked in <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"http:\/\/office.microsoft.com\/en-us\/\/excel-help\/get-an-app-for-excel-HA102840206.aspx?CTT=5&origin=HA102900784\" target=\"_self\">this handy guide<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>.<\/p>\n<p><em><b>This is a Research Deployment<\/b><br \/>\nWe have released the Visualization Toolkit for us to learn about how users interact with advanced visualization. We return a small amount of anonymized information to learn how our users are working with the application; we keep no personally-identifiable information. This information is stored on secure servers, and is used only for research purposes.<\/em><\/p>\n<div id=\"en-usprojectsmsrdatavisdefault\" class=\"page-content\">\n\t\t\t<div class=\"moray-accordion\" data-show=\"false\">\n\t\t\t\t\t\t\t<div class=\"clearfix\">\n\t\t\t\t\t<div\n\t\t\t\t\t\tclass=\"btn-group align-items-center mb-g float-sm-right\"\n\t\t\t\t\t\trole=\"group\"\n\t\t\t\t\t\tdata-mount=\"collapse-controls\"\n\t\t\t\t\t\tdata-bi-aN=\"accordion-collapse-controls\"\n\t\t\t\t\t\tdata-target=\"#accordion-1\">\n\t\t\t\t\t\t<button class=\"btn btn-link m-0\" aria-disabled=\"false\" aria-pressed=\"false\" data-action=\"expand\" type=\"button\" data-bi-cN=\"Expand all\">Expand all<\/button>\n\t\t\t\t\t\t<span aria-hidden=\"true\"> | <\/span>\n\t\t\t\t\t\t<button class=\"btn btn-link m-0\" aria-disabled=\"false\" aria-pressed=\"false\" data-action=\"collapse\" type=\"button\" data-bi-cN=\"Collapse all\">Collapse all<\/button>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<ul class=\"accordion\" id=\"accordion-1\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"m-0\">\n\t\t\t<h4 class=\"accordion-header\">\n\t\t\t\t<button\n\t\t\t\t\tclass=\"btn btn-collapse m-0\"\n\t\t\t\t\ttype=\"button\"\n\t\t\t\t\tdata-mount=\"collapse\"\n\t\t\t\t\tdata-target=\"#collapse-2\"\n\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\taria-controls=\"collapse-2\">\n\t\tHistogram\t\t\t\t<\/button>\n\t\t\t<\/h4>\n\t\t\t<div class=\"collapse\" id=\"collapse-2\">\n\t\t\t\t<div class=\"accordion-body\">\n\t\t\t\t\t\t\t\t\t\t<h1>Histogram: Microsoft Research Data Visualization Apps for Office<\/h1>\n<p style=\"text-align: left\" align=\"center\"><span id=\"db347f18-15cd-4f32-b53d-50ffcc903137\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagedb347f18-15cd-4f32-b53d-50ffcc903137\" class=\"alignleft\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-histogram_large.png\" alt=\"\" \/><\/span>A histogram shows the distribution of data. It will count and bucket data points, and create a bar graph of the frequency of those points. A histogram can be helpful to see how many data points fall into different categories.<\/p>\n<h2><\/h2>\n<h2>How to use<\/h2>\n<p>First, add the <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"http:\/\/office.microsoft.com\/en-us\/store\/microsoft-research-histogram-WA104042888.aspx?redir=0\" target=\"_self\">Histogram from the Office Store<span class=\"sr-only\"> (opens in new tab)<\/span><\/a>. (Here are the basic instructions for getting started with Apps for Office.)<\/p>\n<p>Click <em>Sample Data <\/em>to add a column of sample data to your spreadsheet.<\/p>\n<p>Make sure you have\u00a0data in exactly one selected, and click <em>Set Data <\/em>to set the data in the histogram to the column.<\/p>\n<p>The slider controls the number of bins: drag it left to make fewer, big bins; drag right to make more, small ones.<\/p>\n<p>The <em>Color<\/em> box allows you to select a color for the bars.<\/p>\n<p>The histogram can view either categorical data (such as text labels) or continuous values. The <em>Category<\/em> checkbox forces the system to choose one bin for each distinct value in the dataset.<\/p>\n<p><span id=\"cfa99910-994b-4148-93c6-c1c79307f13d\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagecfa99910-994b-4148-93c6-c1c79307f13d\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-histogram_screenshot_0409.png\" alt=\"\" \/><span id=\"ImageCaptioncfa99910-994b-4148-93c6-c1c79307f13d\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/p>\n<p><em>A Histogram with five\u00a0bins,\u00a0showing the distribution of the sample data at left.<\/em><\/p>\n<p><b><span id=\"f77e1131-fcba-415d-a53e-a002de77bd22\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagef77e1131-fcba-415d-a53e-a002de77bd22\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-histogram_categorical_screen_0409.png\" alt=\"\" \/><span id=\"ImageCaptionf77e1131-fcba-415d-a53e-a002de77bd22\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/b><\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/li>\n\t\t\t\t\t\t<li class=\"m-0\">\n\t\t\t<h4 class=\"accordion-header\">\n\t\t\t\t<button\n\t\t\t\t\tclass=\"btn btn-collapse m-0\"\n\t\t\t\t\ttype=\"button\"\n\t\t\t\t\tdata-mount=\"collapse\"\n\t\t\t\t\tdata-target=\"#collapse-3\"\n\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\taria-controls=\"collapse-3\">\n\t\t2D Histogram (Density Plot)\t\t\t\t<\/button>\n\t\t\t<\/h4>\n\t\t\t<div class=\"collapse\" id=\"collapse-3\">\n\t\t\t\t<div class=\"accordion-body\">\n\t\t\t\t\t\t\t\t\t\t<h1>2D Histogram: Microsoft Research Data Visualization Apps for Office<\/h1>\n<\/p>\n<p style=\"text-align: left\" align=\"center\"><span id=\"e0100cb3-b3cc-4bd1-9995-96e49bd88e85\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagee0100cb3-b3cc-4bd1-9995-96e49bd88e85\" class=\"alignleft\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-hist2d_large.png\" alt=\"\" \/><\/span>A 2D Histogram, or\u00a0Density Plot,\u00a0visualizes the joint distribution of two different axes: it lets you see how much of one thing there is, given another.<\/p>\n<p>Consider the scenario in the scene below. There are two columns of raw data. On the left side, we have built individual histograms of each one\u2013and they both look a bit like normal curves. Only the 2D histogram reveals that there is a connection between the two dimensions: that high values in one axis go with low values on another.<\/p>\n<p>A 2D histogram is sort of like a scatterplot, but can show clusters of points. Even if there are a few thousand points, or the points overlap, the density plot can still show them all.<\/p>\n<div id=\"en-usprojectsmsrdatavistwodhistogram\" class=\"page-content\"><span id=\"c18120b8-7c26-4b4c-a653-6264da7ec594\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagec18120b8-7c26-4b4c-a653-6264da7ec594\" class=\"BorderedImageWrapper\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-agavue_2.png\" alt=\"\" \/><span id=\"ImageCaptionc18120b8-7c26-4b4c-a653-6264da7ec594\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/div>\n<h2>How to use<\/h2>\n<p>First, add the Histogram 2D App from the Office Store. (Here are the basic instructions for getting started with Apps for Office.)<\/p>\n<p>Click <em>Sample Data <\/em>to add two columns of sample data to your spreadsheet. Click the button again to see categorical-vs-numerical data, which can look at the frequency of sales of \u201capples\u201d compare to \u201cpears\u201d. Click a third time to see sample data for categorical-vs-categorical.<\/p>\n<p>Make sure you have data in exactly two columns selected, and click <em>Set Data <\/em>to set the data in the histogram to the column.The two sliders control the number of bins: drag it left to make fewer, big bins; drag right to make more, small ones.The <em>Color<\/em> box allows you to select a color for the squares in the chart.The histogram can view either categorical data (such as text labels) or continuous values. The <em>Category<\/em> checkbox forces the system to choose one bin for each distinct value in the dataset.<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/li>\n\t\t\t\t\t\t<li class=\"m-0\">\n\t\t\t<h4 class=\"accordion-header\">\n\t\t\t\t<button\n\t\t\t\t\tclass=\"btn btn-collapse m-0\"\n\t\t\t\t\ttype=\"button\"\n\t\t\t\t\tdata-mount=\"collapse\"\n\t\t\t\t\tdata-target=\"#collapse-4\"\n\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\taria-controls=\"collapse-4\">\n\t\tTreemap\t\t\t\t<\/button>\n\t\t\t<\/h4>\n\t\t\t<div class=\"collapse\" id=\"collapse-4\">\n\t\t\t\t<div class=\"accordion-body\">\n\t\t\t\t\t\t\t\t\t\t<h1>Treemap: Microsoft Research Data Visualization Apps for Office<\/h1>\n<\/p>\n<p style=\"text-align: left\" align=\"center\"><span id=\"89b11f6c-adde-469b-9e91-b9435f1096ff\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image89b11f6c-adde-469b-9e91-b9435f1096ff\" class=\"alignleft\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-treemap_large.png\" alt=\"\" \/><span id=\"ImageCaption89b11f6c-adde-469b-9e91-b9435f1096ff\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/p>\n<p>A treemap is a hierarchical view of data: it breaks an area into rectangles representing branches of a tree. Each rectangle is broken in turn into subrectangles, representing subbranches. Each subrectangle can be associated with two different numbers, once of which may be set to a color; the other to a size.<\/p>\n<p>A treemap can make it easy to discover how a whole is broken into parts: where the budget in your organization goes, or where the space on your disk has gone.<\/p>\n<p>For example, here\u2019s an organization divided into four offices: North, South, West, and East. Each sells volumes of \u201cfood\u201d, \u201coffice\u201d, and \u201ctech\u201d; each of these, in turn, has subcategories. We\u2019re using the size of each box to represent sales volume, and the color to represent the profit.<\/p>\n<div id=\"en-usprojectsmsrdatavistreemap\" class=\"page-content\"><span id=\"90e426e2-b6b0-412f-bcb9-8a00e82a3bbd\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image90e426e2-b6b0-412f-bcb9-8a00e82a3bbd\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-treemap_screenie.png\" alt=\"\" \/><span id=\"ImageCaption90e426e2-b6b0-412f-bcb9-8a00e82a3bbd\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/div>\n<div id=\"en-usprojectsmsrdatavistreemap\" class=\"page-content\"><em>The Treemap was invented by Ben Shneiderman, who maintains a <\/em><a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" href=\"http:\/\/www.cs.umd.edu\/hcil\/treemap-history\/\" target=\"_self\"><em>history of different treemaps<\/em><span class=\"sr-only\"> (opens in new tab)<\/span><\/a><em>.<\/em><\/div>\n<h3>Data Formats<\/h3>\n<p>Excel doesn\u2019t naturally have a way to represent hierarchical data: it likes rows and columns. In the Treemap module, you can enter data either as a <b>name list<\/b>, or as an <b>id\/parent<\/b> set.<\/p>\n<h4>Name List<\/h4>\n<p>The Name List format might be most natural for things like disk space. In a name list, you enter as many columns as you need to represent the deepest part of the hierarchy\u2013and then leave some parts of it blank. Here\u2019s an example from a disk:<\/p>\n<table>\n<tbody>\n<tr>\n<td><em><strong>Level 1 <\/strong><\/em><\/td>\n<td><em><strong>Level 2 <\/strong><\/em><\/td>\n<td><em><strong>Level 3 <\/strong><\/em><\/td>\n<td><em><strong>Level 4 <\/strong><\/em><\/td>\n<td><em><strong>Level 5<\/strong><\/em><\/td>\n<\/tr>\n<tr>\n<td><em>C: <\/em><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><em>C: <\/em><\/td>\n<td><em>Files <\/em><\/td>\n<td><em>Personal <\/em><\/td>\n<td><em>User <\/em><\/td>\n<td><em>MyFile.txt <\/em><\/td>\n<\/tr>\n<tr>\n<td><em>C: <\/em><\/td>\n<td><em>Temp <\/em><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>You might also use the Name List to handle data that isn\u2019t completely hierarchical:<\/p>\n<table>\n<tbody>\n<tr>\n<td>\n<p><em>\u00a0<\/em><\/p>\n<p><em><strong>Region<\/strong><\/em><\/p>\n<\/td>\n<td><em><strong>Category<\/strong><\/em><\/td>\n<td><em><strong>Product<\/strong><\/em><\/td>\n<td><em><strong>Volume<\/strong><\/em><\/td>\n<td><em><strong>Profit Each<\/strong><\/em><\/td>\n<\/tr>\n<tr>\n<td><em>West<\/em><\/td>\n<td><em>Sprockets<\/em><\/td>\n<td><em>Type A<\/em><\/td>\n<td><em>1000<\/em><\/td>\n<td><em>0.5<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>West<\/em><\/td>\n<td><em>Sprockets<\/em><\/td>\n<td><em>Type B<\/em><\/td>\n<td><em>400<\/em><\/td>\n<td><em>-5<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>East<\/em><\/td>\n<td><em>Ratchets <\/em><\/td>\n<td><\/td>\n<td><em>2000<\/em><\/td>\n<td><em>1.0<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Note the \u201cVolume\u201d and \u201cProfit\u201d columns. We can use them for size and color, respectively.<\/p>\n<h4>Id\/parent<\/h4>\n<p>If you have an organization chart stored in a database, then it might look different: you might have records with a person and their manager. Here\u2019s a small organization:<\/p>\n<table>\n<tbody>\n<tr>\n<td><em><strong>Name<\/strong><\/em><\/td>\n<td><em><strong>Manager<\/strong><\/em><\/td>\n<\/tr>\n<tr>\n<td><em>David Freese<\/em><\/td>\n<td><em>Wilfredo Baber<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>Wilfredo Baber<\/em><\/td>\n<td><em>Yolanda Hill<\/em><\/td>\n<\/tr>\n<tr>\n<td><em>Yolanda Hill<\/em><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Since it\u2019s very annoying to switch between the \u201cName List\u201d and the \u201cId\/Parent\u201d forms, the Treemap application accepts both.<\/p>\n<h1>Using the App<\/h1>\n<p>For basic instructions on starting up an App for Office, see the description on t.<\/p>\n<p>The easiest way to get started with the app is to generate sample data. on the \u201cSample Data\u201d tab, press either \u201cName List\u201d or \u201cID\/Parent\u201d.<\/p>\n<p>After\u00a0data is available, it will take <strong>three <\/strong>selections to build a complete chart: one to add the names; one to select the column for the size, and one more to select the column for color. Note that these last two columns are optional: it\u2019s a perfectly fine treemap even without size or color.<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/li>\n\t\t\t\t\t\t<li class=\"m-0\">\n\t\t\t<h4 class=\"accordion-header\">\n\t\t\t\t<button\n\t\t\t\t\tclass=\"btn btn-collapse m-0\"\n\t\t\t\t\ttype=\"button\"\n\t\t\t\t\tdata-mount=\"collapse\"\n\t\t\t\t\tdata-target=\"#collapse-5\"\n\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\taria-controls=\"collapse-5\">\n\t\tStreamgraph\t\t\t\t<\/button>\n\t\t\t<\/h4>\n\t\t\t<div class=\"collapse\" id=\"collapse-5\">\n\t\t\t\t<div class=\"accordion-body\">\n\t\t\t\t\t\t\t\t\t\t<h1>Data Visualization Apps for Office<\/h1>\n<p style=\"text-align: left\" align=\"center\"><span id=\"f3ab822b-b8fb-4701-be25-eccf7718acfc\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagef3ab822b-b8fb-4701-be25-eccf7718acfc\" class=\"alignleft\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-streamgraph_large.png\" alt=\"\" \/><span id=\"ImageCaptionf3ab822b-b8fb-4701-be25-eccf7718acfc\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/p>\n<p>A Streamgraph is a more unusual type of graph. It shows the way that a set of numbers has changed over time by their relative area. (See the sidebar for the history of Streamgraphs).<\/p>\n<p>A streamgraph is based on a rectangle of data: in this example, \u201cComedy\u201d had a volume of 10 in 2008, and of 12 in 2010.<\/p>\n<table width=\"320\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"text-align: left\" width=\"64\"><b>Year<\/b><\/td>\n<td style=\"text-align: left\" width=\"64\"><em>Comedy<\/em><\/td>\n<td width=\"64\"><em>Drama<\/em><\/td>\n<td width=\"64\"><em>Sci-Fi<\/em><\/td>\n<td width=\"64\"><em>Action<\/em><\/td>\n<\/tr>\n<tr>\n<td align=\"right\"><b>2008<\/b><\/td>\n<td align=\"right\"><em>10<\/em><\/td>\n<td align=\"right\"><em>10<\/em><\/td>\n<td align=\"right\"><em>6<\/em><\/td>\n<td align=\"right\"><em>0<\/em><\/td>\n<\/tr>\n<tr>\n<td align=\"right\"><b>2009<\/b><\/td>\n<td align=\"right\"><em>12<\/em><\/td>\n<td align=\"right\"><em>13<\/em><\/td>\n<td align=\"right\"><em>3<\/em><\/td>\n<td align=\"right\"><em>0<\/em><\/td>\n<\/tr>\n<tr>\n<td align=\"right\"><b>2010<\/b><\/td>\n<td align=\"right\"><em>14<\/em><\/td>\n<td align=\"right\"><em>18<\/em><\/td>\n<td align=\"right\"><em>10<\/em><\/td>\n<td align=\"right\"><em>16<\/em><\/td>\n<\/tr>\n<tr>\n<td align=\"right\"><b>2011<\/b><\/td>\n<td align=\"right\"><em>22<\/em><\/td>\n<td align=\"right\"><em>22<\/em><\/td>\n<td align=\"right\"><em>9.3<\/em><\/td>\n<td align=\"right\"><em>55<\/em><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Once you have the app installed, you can\u00a0press \u201cGenerate\u201d to get sample data that is appropriately formatted.<\/p>\n<p>There are two buttons to specify the chart data. Press \u201cSeries Values\u2026\u201d to select the data that represents the values of the dataset, including the column headers. In the table below, those are <em>italicized<\/em>.<\/p>\n<p>Press \u201cHorizontal axis labels\u2026\u201d to select the data that represents the column names. In this example, you would select the <strong>boldfaced<\/strong> years.<\/p>\n<p>All of the values in the table should be numbers greater than zero. If the application sees a number less than zero, it will replace it with a zero.<\/p>\n<p><span id=\"f775f262-18a4-4036-abd1-4dbb52730585\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagef775f262-18a4-4036-abd1-4dbb52730585\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-streamgraph.png\" alt=\"\" \/><span id=\"ImageCaptionf775f262-18a4-4036-abd1-4dbb52730585\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/li>\n\t\t\t\t\t\t<li class=\"m-0\">\n\t\t\t<h4 class=\"accordion-header\">\n\t\t\t\t<button\n\t\t\t\t\tclass=\"btn btn-collapse m-0\"\n\t\t\t\t\ttype=\"button\"\n\t\t\t\t\tdata-mount=\"collapse\"\n\t\t\t\t\tdata-target=\"#collapse-6\"\n\t\t\t\t\taria-expanded=\"false\"\n\t\t\t\t\taria-controls=\"collapse-6\">\n\t\tApps for Access\t\t\t\t<\/button>\n\t\t\t<\/h4>\n\t\t\t<div class=\"collapse\" id=\"collapse-6\">\n\t\t\t\t<div class=\"accordion-body\">\n\t\t\t\t\t\t\t\t\t\t<h1>Apps for Access<\/h1>\n<\/p>\n<p>Our implementations of core visualizations are a testbed to learn about how these tools are used with database tools.<\/p>\n<p>We provide core visualizations, familiar to users of Excel and other popular charting tools:<\/p>\n<p><span id=\"209c153b-8891-449c-b816-1cc14e67a419\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image209c153b-8891-449c-b816-1cc14e67a419\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-barchart.png\" alt=\"\" \/><span id=\"ImageCaption209c153b-8891-449c-b816-1cc14e67a419\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><span id=\"78885211-2664-4f6e-9f16-52053050a41c\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image78885211-2664-4f6e-9f16-52053050a41c\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-columnchart.png\" alt=\"\" \/><span id=\"ImageCaption78885211-2664-4f6e-9f16-52053050a41c\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><span id=\"16026078-8cba-40d3-8044-a53aa1db4d75\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image16026078-8cba-40d3-8044-a53aa1db4d75\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-linechart.png\" alt=\"\" \/><span id=\"ImageCaption16026078-8cba-40d3-8044-a53aa1db4d75\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><span id=\"4acebe71-b599-43ce-8433-800e92cda6dc\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image4acebe71-b599-43ce-8433-800e92cda6dc\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-areachart.png\" alt=\"\" \/><span id=\"ImageCaption4acebe71-b599-43ce-8433-800e92cda6dc\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><span id=\"937d55db-c56a-4469-af13-1d58e3e15c31\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image937d55db-c56a-4469-af13-1d58e3e15c31\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-piechart.png\" alt=\"\" \/><span id=\"ImageCaption937d55db-c56a-4469-af13-1d58e3e15c31\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><span id=\"06cc2187-ed49-4abd-9a54-0c4b3a34e433\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Image06cc2187-ed49-4abd-9a54-0c4b3a34e433\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-scatterplot.png\" alt=\"\" \/><span id=\"ImageCaption06cc2187-ed49-4abd-9a54-0c4b3a34e433\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/p>\n<ul>\n<li>A <strong>bar chart<\/strong> and <strong>column chart<\/strong>. These differ only in the orientation of the bars.<\/li>\n<li>A <strong>line chart<\/strong> and an <strong>area chart<\/strong>; both offer stacked or overlapping areas. An area chart is filled; a line chart only draws the top line.<\/li>\n<li>A <strong>pie chart<\/strong><\/li>\n<li>A <strong>scatter chart, <\/strong>or scatter plot.<\/li>\n<\/ul>\n<p>For each of these apps, the system expects see one column of X axis labels, and several columns of series data. Press \u201cGenerate\u201d to insert sample data on the sheet.<\/p>\n<table class=\"blue tWiz\">\n<tbody>\n<tr class=\"blueTableHeaderRow\">\n<td class=\"blueTableHeaderEvenCol\">Year<\/td>\n<td class=\"blueTableHeaderOddCol\">\u00a0\u00a0 Sales<\/td>\n<td class=\"blueTableHeaderEvenCol\">\u00a0\u00a0 Profit<\/td>\n<\/tr>\n<tr class=\"blueTableOddRow\">\n<td class=\"blueTableEvenCol\">2001<\/td>\n<td class=\"blueTableOddCol\">\u00a0\u00a0 100<\/td>\n<td class=\"blueTableEvenCol\">\u00a0\u00a0 14<\/td>\n<\/tr>\n<tr class=\"blueTableEvenRow\">\n<td class=\"blueTableEvenCol\">2002<\/td>\n<td class=\"blueTableOddCol\">\u00a0\u00a0 122<\/td>\n<td class=\"blueTableEvenCol\">\u00a0\u00a0 12<\/td>\n<\/tr>\n<tr class=\"blueTableOddRow\">\n<td class=\"blueTableEvenCol\">\u2026<\/td>\n<td class=\"blueTableOddCol\">\u00a0\u00a0 \u2026<\/td>\n<td class=\"blueTableEvenCol\">\u00a0\u00a0 \u2026<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Click <strong>[Series Data\u2026]<\/strong> to select the series: <strong>Sales <\/strong>and <strong>Profit.<\/strong><\/p>\n<p>Click <strong>[Label Data\u2026<\/strong>] be used to select the labels: the <strong>Year<\/strong> column.<\/p>\n<p>This image shows a column chart for the sample data above.<\/p>\n<p><span id=\"f72cd7a4-ad32-459b-88c4-334aca3c70d5\" class=\"ImageBlock fn\"><img decoding=\"async\" id=\"Imagef72cd7a4-ad32-459b-88c4-334aca3c70d5\" src=\"https:\/\/www.microsoft.com\/en-us\/research\/wp-content\/uploads\/2016\/02\/msrdatavis-columnchart_screenshot.png\" alt=\"\" \/><span id=\"ImageCaptionf72cd7a4-ad32-459b-88c4-334aca3c70d5\" class=\"ImageCaptionCoreCss ImageCaption\"><\/span><\/span><\/p>\n<h3>Notes<\/h3>\n<p>For the area chart and line chart, the visualization will attempt to interpret the \u2018labels\u2019 column as ascending, numeric X axis values. If that works, then it will render them appropriately spaced; the spacing need not be regular. If any of the values are not numeric, or not ascending, then each label will instead be placed as evenly-spaced categories.<\/p>\n<p>Charts behave inconsistently with negative Y-axis values.<\/p>\n<p>Note that in the current version of the charts, the X and Y axes are automaitcal<\/p>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/li>\n\t\t\t\t\t\t\t\t\t<\/ul>\n\t\t<\/div>\n\t\t\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This project has now been\u00a0concluded, and the apps have been deprecated. Thank you for your feedback! At Microsoft Research, we want to let users play with\u00a0new types of visualizations. We\u2019re doing it with Apps for Office, a new feature for Office 2013 and Office 365. These let users easily add new functionality to Office. You [&hellip;]<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"research-area":[13551,13554],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-171088","msr-project","type-msr-project","status-publish","hentry","msr-research-area-graphics-and-multimedia","msr-research-area-human-computer-interaction","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"2013-02-06","related-publications":[],"related-downloads":[],"related-videos":[],"related-groups":[144794],"related-events":[],"related-opportunities":[],"related-posts":[],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"user_nicename","value":"rfernand","display_name":"Roland Fernandez","author_link":"<a href=\"https:\/\/www.microsoft.com\/en-us\/research\/people\/rfernand\/\" aria-label=\"Visit the profile page for Roland Fernandez\">Roland Fernandez<\/a>","is_active":false,"user_id":33386,"last_first":"Fernandez, Roland","people_section":0,"alias":"rfernand"},{"type":"user_nicename","value":"ricardgu","display_name":"Ricardo Gutierrez","author_link":"<a href=\"https:\/\/www.microsoft.com\/en-us\/research\/people\/ricardgu\/\" aria-label=\"Visit the profile page for Ricardo Gutierrez\">Ricardo Gutierrez<\/a>","is_active":false,"user_id":33392,"last_first":"Gutierrez, Ricardo","people_section":0,"alias":"ricardgu"}],"msr_research_lab":[199565],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/171088"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-project"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/171088\/revisions"}],"predecessor-version":[{"id":288203,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/171088\/revisions\/288203"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=171088"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=171088"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=171088"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=171088"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=171088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}