Graphing in Access 2007

[Mark]

I'm looking to create a graph (in a report or form?) in Access 2007.

The source of the data is a simple query that will emulate a calendar with
months across the top, and resources down the first column. I want a bar
graph that shows the resources across the months where they are working.

Thanks....

 

[Duane Hookom]

You might want to try this without using a graph control. There are some
sample calendar reports at http://www.access.hookom.net/Samples.htm. The
gantt type report does require some code.

 

[Arvin Meyer [MVP]]

You can do this directly in Access 2007, or using automation with Excel. In
earlier versions I would suggest using automation, but I think Access 2007
now has a better implementation.

If I remember correctly, there is a chart wizard to walk you through the
process. Create a query to use as a data source for your chart and open the
wizard.

 

[xiaozhou]

I'm looking to create a graph (in a report or form?) in Access 2007.

The source of the data is a simple query that will emulate a calendar with
months across the top, and resources down the first column. I want a bar
graph that shows the resources across the months where they are working.

Thanks....