{"id":2236,"date":"2013-10-05T10:00:21","date_gmt":"2013-10-05T08:00:21","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2236"},"modified":"2020-09-04T09:46:31","modified_gmt":"2020-09-04T07:46:31","slug":"casova-osa-kontingencni-tabulka-excel-2013","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/casova-osa-kontingencni-tabulka-excel-2013\/","title":{"rendered":"Timeline in a PivotTable"},"content":{"rendered":"

<\/p>\n

One of the new features\u00a0introduced by the developers of Microsoft Excel version 2013 is the timeline<\/strong>. In the 2010 version had preceded the tool Slicer\u00a0of Pivot tables, of which you will learn more in the video<\/a>. The pivot table is a general summary tool used for analyzing data. It can display effectively and comprehensively summary of\u00a0selected values in\u00a0a two-dimensional model and\u00a0a chart. In this tutorial we will focus on this\u00a0new option for filtering results based on\u00a0selection of dates – days, months, quarters and years out of dates. The\u00a0option is the timeline, so that in addition to conventional filtering techniques this is an entertaining and enriching to work with the PivotTable. When combining Slicer\u00a0and a Timeline we can achieve a nice interactive data analysis for management. Before we begin with the tutorial, note\u00a0that this new tool\u00a0is available\u00a0since\u00a0version 2013 in XLSX files<\/p>\n

\"\u010casov\u00e1<\/a>
Excel\u00a0Timeline<\/figcaption><\/figure>\n

If you create a PivotTable in Excel, activation the\u00a0timeline will issue one click.<\/p>\n

    \n
  1. Go to\u00a0Analysis<\/strong> tab > Insert timeline.<\/li>\n
  2. Then select the field with the dates that you want to use for the timeline.<\/li>\n
  3. Timeline\u00a0is inserted into the worksheet.<\/li>\n
  4. Once the timeline is selected\u00a0you can use\u00a0the Options tab to modify its appearance and other properties.<\/li>\n<\/ol>\n
    \"Mo\u017enosti<\/a>
    Time line Options tab<\/figcaption><\/figure>\n

    From the Options tab worth trying to change the color design, off some of screen elements and especially the connection of reports (PivotTables).\u00a0We\u00a0met this when using\u00a0the previously mentioned Slicers. Here, we have also\u00a0the ability to set up multiple PivotTables (based on the same data table), which will be filter using\u00a0timelime at the same time.<\/p>\n

    To control the actual timeline intuitively we use the mouse. Click and\u00a0simply by holding the mouse, drag the selected direction is performed a\u00a0given date filter. We change the\u00a0date group\u00a0by clicking the top right corner (we choose between days, months, quarters and years). To cancel filtering conditions use the icon with cross in the upper right corner of the timeline.<\/p>\n

    \"Datumov\u00e9
    Date filters<\/figcaption><\/figure>\n

    Source file can be downloaded here<\/a>.<\/p>\n

    If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    One of the new features\u00a0introduced by the developers of Microsoft Excel version 2013 is the timeline. In the 2010 version had preceded the tool Slicer\u00a0of Pivot tables, of which you will learn more in the video. The pivot table is a general summary tool used for analyzing data. It can display effectively and comprehensively summary […]<\/p>\n","protected":false},"author":1,"featured_media":2242,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2236"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=2236"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2236\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2242"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}