Přeskočit na hlavní obsah

Timeline Chart

Garden City Consultants

1.0 (1)

A visualization tool that can be used to show the course/classes schedule, portfolio holding period

Description:

Time-line Chart Excel Add-in is a visualization tool that can be used to show the course/class schedule; Securities holding period in a portfolio, etc.

The data has 4 columns:

  • The first column is the row label/categories in the chart.

  • The second column is a string column. It is the timeline legends/series in the chart.

  • The 3rd and 4th columns are the date time columns with the period start and end.

Two sample data in the add-in help user to understand the data structures.

  • Class Schedule Timeline sample data: It shows the classrooms and course schedule.

  • Portfolio Holdings Timeline sample: It shows an example of the securities holding period in a portfolio.

Features:

  • Easy to use and user friendly. Sample data can be the template to build your own data.

  • Change the title by clicking the title area and enter the text as needed.

  • Mouse over the bubbles to view the duration detail in the tool-tips.

  • Interactive Chart: the chart is binding to the data table in the sheet. The chart is updating when the data is entered.

Instruction:

  • Download this add in and start Excel 2013 SP1 or later.

  • Select a sample data type in the sample data drop-down in the setting window and Click Insert Sample Data button to view the chart.

  • Clean the sample data and set the focus to the first cell.

  • Select a different sample data in the setting window and view the chart.

  • Repeat step 2, 3, 4 to view all the 4 different sample data.

  • Build own data and paste into sample data table and click binding existing data button to draw the chart.

Version 1.0.0.1 Release Notes:

  • Requested by the user to add the detail date in the tool-tip. However, this only works for the timeline cross multiple days. For the time only chart, please uncheck the "Show Detail Date in tool-tip" check-box.

  • Update the setting window layout.

Version 1.0.0.2 Release Notes:

  • Add resizing function (dragging the add-in window) and remove height setting.

  • Standardize the UI of setting window.
Schopnosti doplňku
Když se tento doplněk použije, může
  • Číst a měnit váš dokument
  • Posílat data přes internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680049/Asset_bb658022-5155-495a-920f-29dea8c0d77f/TimelineChartScreen1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680049/Asset_bb658022-5155-495a-920f-29dea8c0d77f/TimelineChartScreen1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680049/Asset_dcce56e8-5ded-40e2-85b0-8eb853cf0db8/TimelineChartScreen0.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680049/Asset_ed421b98-a001-452c-900f-e23d3980a93c/TimelineChartScreen2.png