tracking occurances

  • Thread starter Thread starter Psych Tech
  • Start date Start date
P

Psych Tech

I hope some body can help me.
I am tracking occurances on a certain behavior. I was able
to create a series for every day of the week in a month. I
don't want to count the total. I just want to know on what
day the behavior occurred and be able to present on a
graph.
I have been able to create the graph, but haven't been
able to get the right formula to track the occurance.

The trick is that data is gathered on one folder (per
shift and day of the month. then linked to to another
folder for annual tracking. I have this all in place
already. Its just this one graph that is different to be
able to state the day an occurance occurs.
 
Are the data in a single worksheet? If not, can they be consolidated?
Then, what will be the layout of the data? Given the specific layout,
what do you want graphed? How?

It won't hurt to provide an example -- or two.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top