How to use an Access data field to create an automatic bar graph 2

[Sherman6789]

Is there a way to create automatic bar graphs with data taken directly from an Access data field?

We have about 12 projects in various stages of completion. We would like to add input the percentage of completion (0-100)% in a field and have a bar graph chart automatically created. This can be in Access or using PowerPoint or Word.

Any assistance will be appreciated.

WRS

 

[dhookom]

There is a chart control that you can drop onto an Access form or report. The chart control has a row source property which is the query of your data you wish to chart.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Sherman6789]

Thanks dhookom,

I am somewhat new to this part of Access. How do I get to the chart control to enter the "row source"?

 

[mhartman1]

Hello:

Here you go.....

http://msdn2.microsoft.com/en-us/library/aa141505(office.10).aspx

http://msdn2.microsoft.com/en-us/library/aa141474(office.10).aspx

http://www.aspfree.com/c/a/Code-Exa...g-Data-from-a-Database-with-MS-Chart-Control/

'
Regards
Mark

 

[dhookom]

Mark's links seem to be good information but possibly not real relevant to a new use in Access.

Prior to creating your graph you should create a query that contains the exact records and values you want to graph. Then drop a chart control on your form or report and step through the wizard selecting your query. You can always modify chart properties after you are done.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]