Graphs: Can I do it with my data?

[AWright]

Hi, <br><br>I'm attempting to make a graph from data in a table,<br>it's realated to personel data, The data contained in the table is the start date of an absence (from work) the number of days absent (I have extrapolated the end date from this)and data such as unique identifiers for each employee, but I need to make a graph with Date on the x axis and number of people absent on the Y.<br><br>Basically the problem is I don't know how to get the data neccisary to construct the graph from the data I have. One way I considdered was to write a VBA statement that adds a record for each day of absence using increments the date from the start to the end date.<br><br>Do I need to do this in VBA or is there another way?<br><br>Thanx in advance<br><br>