Graph question...

[elsanto]

Hullo folks,

I have a call times log set up.
TimeIn, TimeOut, Duration.

I want to set up a graph that looks like this:

X-Axis = TimeIn per hour
Y-Axis = Count of Calls (TimeIn will suffice) per hour

This is the first time I've seen Graph in Access, and I'm rather lost.
Thanks.

 

[Len Boorman]

The wizard is pretty rough at times but it does work. BUT

Absolutely recommend that you create such queries that are necessary so that you have all the data you want in the format that you want it before using the wizard

The graph source in then one query and the wizard is okay. If you try to do too much in the wizard it can get confusing. It does it okay but I have seen easier wizards.

Tip
If you also want the graph in a report do the form first and then when it is as you want it copy and paste the graph when in form design onto the report design.

Len B

 

[elsanto]

Thanks Len, I'll give it a go.

 

[ray147]

is it possible to paste to a report design view programatically in VBA?

i have created an automated chart process in Excel and now i'd like to copy and paste it to a report (detail section). is this possible ?