Create a simple timeline in google spreadsheet / charts

  • Posted:
  • Proposals: 1
  • Remote
  • #677700
  • Expired
Md.Alamgir H. has already sent a proposal.
  • 0

Description

Experience Level: Entry
Estimated Job duration: 1 day or less
I am looking for a spreadsheet/form system very similar to this one that was already produced: http://www.peopleperhour.com/job/create-a-simple-timeline-in-google-spreadsheet-charts-525797

This should be a simple scrollable timeline in a google spreadsheet/chart. I have dates, I have three different event themes, even description, and three yes/no conditions for each row. The spreadsheet is fed by a google form. I would like to visualise this dynamic information in a time line view. This needs to be dynamic since we are adding events as we go along, so not a static chart, but a dynamic view that populates over time.

I have a google spreadsheet with the following data:

Event date (events occur generally on one day only)
Event name
Event theme (one of three) - the output here should be color coded for each theme
Event Location (from a fixed selection of 1 of 26 possible choices on the form)
Custom field 1 (yes/no response only)
Custom field 2 (yes/no response only)
Custom field 3 (yes/no response only)

I want a scrollable dynamic time line chart to show this visually, like a gantt chart.

If possible I would like to be able to filter the visual according to location, event theme, and/or other criteria.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.