Timeline Charts on Steroids
October 11, 2008 7:33 AM Subscribe
I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template.
posted by Inkoate to Computers & Internet (1 answer total) 1 user marked this as a favorite
The final product will look similar to a gantt chart, with the primary difference being that milestones need to be shown as text, not progress bars. The top horizontal axis needs to display dates, the left vertical axis needs to display 5 different categories of milestones (for example, "events" are in the top section, "deliverables" in the second section, etc). I have over a hundred milestones (all associated with a date) to display.
If it were only this requirement, I would just build it by hand in Excel or Powerpoint or something. However, the timeline needs to be filterable by another set of categories (not the same as the ones on the left vertical axis), so that I can tailor the end product to different audiences--this ability to filter on a third set of variables makes me think a database approach is going to be easier than just using Excel.
Does anyone know if someone has done this sort of thing in Access before? Is there a template somewhere that I can rip off? Failing that, does anyone have any advice regarding the sort of structure that might make sense to represent this data, if I have to build this from the ground up?