Creating an active timeline of data from cell input

K

kcip

Not sure if this is possible.

I am attempting to create a timeline from data gathered in cells that are
input manually and from dropdown menus.

I'll try to explain:

Project activity timeline

Data input A: manually insert today's date
Data input B: from dropdown menu, select type of activity (phone call,
email, meeting, etc)
Data input C: from dropdown menu, select activity subject (Request for
info, project scope change, schedule change, etc)


From this data, where I assume each of the dropdown items has an identifier,
or something, for the formula, I need a "running graph/timeline" that tracks
the project activity from start to finish.

Is there a way?

I'm using Excel 2003

Thank you.
cell C:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create active timeline graph 0
Conditional Formating based on method of input 2
tabulate output data from different combination of input. 0
To leave a cell blank following an "IF" function 9
Excel 2003 3
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
select data from dropdown menu 3
How to fill cell references from several worksheets in one? 2

Top