Timeline Chart Excel Add-In

Screenshots:

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:

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

Features:

Instruction:

  1. Download this add in and start Excel 2013 SP1 or later.
  2. 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.
  3. Clean the sample data and set the focus to the first cell.
  4. Select a different sample data in the setting window and view the chart.
  5. Repeat step 2, 3, 4 to view all the 4 different sample data.
  6. 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:

  1. 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.
  2. Update the setting window layout.

Version 1.0.0.2 Release Notes:

  1. Add resizing function (dragging the add-in window) and remove height setting.
  2. Standardize the UI of setting window.