Excel 2013 Milestone Timeline Chart
This visual basic (VB) enhanced spreadsheet is designed to be presented to end-users. Users hyperlink through the content to view details of topics covered by speakers at CITPG Meetings.
Click here to open the spreadsheet in Excel online
This is a macro-enabled spreadsheet. Macros do not function in online version of Excel.
The charts were developed from a template located online. Visual Basic script is used to control the hyperlink of two buttons. A third button has a unique, simple, code that controls the location of the button as the mouse is moved to a new cell in the sheet. The button 'floats'. The workbook contains one hidden worksheet. The worksheets are locked, but not password protected.
I considered altering the timeline to display topics at daily intervals, but the even spacing of the data points lent to the readability and did not detract from the message.
1) The template used for the chart is located at https://alesandrab.wordpress.com/2013/03/13/create-a-milestone-timeline-using-excel/
2) The script for the floating button at http://www.vbforums.com/showthread.php?458200-Floating-commandbutton-on-sheet
Macros and VB Buttons do not work in Excel Online. Excel will prompt with a security warning when this spreadsheet is opened.