bar graph day view

[Misiek]

Dear All,

I have a table for tasks.
Fields: ID, TaskOwner, Task, Date(with time) Execution time, and couple more

Is it possible to create a bar graph view of a day. or part of a day?

similar to this:

http://s3.amazonaws.com/groovehq/up...p1zn1fik43pqzs9m4dcegp49qaib39we1g?1437679416

Thanks

 

[Ranman256]

Make a form with params to pick,2 textboxes...
TxtStartDate,txtEndDate.
Make the chart query read off this form,
Select * from table where [date] between forms!myForm!txtStartDate and forms!myForm!txtEndDate

The chart reads this query.

You can also Make some radio buttons to quick set these dates,
Daily sets both text boxes to today.
Monthly sets to the start and end o the month

 

[Misiek]

I already have section that filter data for specific day. I just need to know how to create the bar chart and make it look like one from the link (in previous post).

 

[Ranman256]

if you already have the query, run the query, copy the data,
open the chart, open the data source grid, paste the data,
save.
modify the points, axis',etc.

 

[Misiek]

modify the points, axis',etc.

can you be more specific, how to do it?

 

[JHB]

Post some sample data in a MS-Access database or an Excel sheet.