riessbeck
02-23-2012, 02:45 AM
I am trying to achieve reports based on a user and what qualification they have and draw a timeline for it.
Simply put:
name / qualification name / Date attained
----------------------------------------------
joe bloggs / Digging Holes / 01/01/12
joe bloggs / Filling Holes / 31/12/11
jim jones / Helping Fill / 01/01/12
So a side bar graph. Joe bloggs will have 2 lines with different points on the graph to show when acheived. i need this timeline to stretch from 01/01/11 - 31/12/13.
So we can track what quals each person has and what they need to attain over that time 2 year period....
I have tried quite a few times with excel 2010..... ms access sort of can do it... but my goal is for excel being a lighter interface to use.
thanks for your help in advance.
cheers:banghead:
Simply put:
name / qualification name / Date attained
----------------------------------------------
joe bloggs / Digging Holes / 01/01/12
joe bloggs / Filling Holes / 31/12/11
jim jones / Helping Fill / 01/01/12
So a side bar graph. Joe bloggs will have 2 lines with different points on the graph to show when acheived. i need this timeline to stretch from 01/01/11 - 31/12/13.
So we can track what quals each person has and what they need to attain over that time 2 year period....
I have tried quite a few times with excel 2010..... ms access sort of can do it... but my goal is for excel being a lighter interface to use.
thanks for your help in advance.
cheers:banghead: