Access 2007 Graphs

[Jessica]

I am trying to create a graph that has two colums for two types of data.
Basically I want:

Column 1 Column 2 Column 3 Column 4
Row Heading Column Heading Value Value

I am wanting a line graph with two lines (one for column 3 and one for
column 4), but Access does not want to do the graph the way I want. Any
suggestions?

 

[Bob Barnes]

If you know "automation", send the data to Excel, and use an Excel Chart.

HTH - Bob

 

[roccogrand]

Jessica,

Although Access uses the same graphics engine as Excel, creating charts in
Access is not very intuitive. To learn how to use the charting tool, check
out one of the online tutorials. Here is the URL for one on the Database
Journal website:
http://www.databasejournal.com/feat...reating-Charts-in-an-Access-2007-Database.htm

There is a sample database on the site that has a pre-built chart. The
steps may be out of order but with a little trial and error you will get it
to work. In Design View, you can easily EDIT the chart data, e.g., delete
columns and rows.

Unfortunately the database developers at Microsoft haven't embraced graphics
fully yet. And most database people don't chart either - you may have to
look through several Access books to find one that explains how to chart.

So as Bob suggested, you may want to use Excel but Access theoretically can
do everything that Excel can. But by the time you create the chart you want,
you would have forgotten why you wanted it or you can't remember how to do it
again.

Good luck.

 

[Duane Hookom]

Apparently this is a crosstab? Can you share the SQL view? Access charts can
display multiple datasets.

Duane Hookom
MS Access MVP

 

[a a r o n . k e m p f]

I use either OWC reports, or SQL Server Reporting Services

sorry.. but Access for Reporting is stuck in the 16th century

 

[Jessica]

Sorry it took me a while to get back. I have figured out that I can have
more than one value if I do not use the crosstab feature and was able to
build a chart. My new problem is that I am pretty (99.9%) sure that my chart
is about as complex as Access goes with graphing. I have been doing my
homework and have been reading that I may be able to do more complex graph in
Access reports using VB. Do you know if this is true? I do not want to
spend a large amount of time trying to build something that will not work.

Just an FYI - I need these charts to run on Access reports, not to export
and use Excel as has been suggested due to Access's limited charting
capability.

Thank you so much for your help.

 

[Duane Hookom]

You have total control over the graph object in Access. I typically create a
similar chart in Excel. I then turn on the macro recorder and make changes
to the chart. After finished making the changes, I copy the recorded code
and paste it into the Access form or report and change the code a little to
reference the current graph/chart in Access.

--
Duane Hookom
MS Access MVP

Sorry it took me a while to get back. I have figured out that I can have
more than one value if I do not use the crosstab feature and was able to
build a chart. My new problem is that I am pretty (99.9%) sure that my
chart
is about as complex as Access goes with graphing. I have been doing my
homework and have been reading that I may be able to do more complex graph
in
Access reports using VB. Do you know if this is true? I do not want to
spend a large amount of time trying to build something that will not work.

Just an FYI - I need these charts to run on Access reports, not to export
and use Excel as has been suggested due to Access's limited charting
capability.

Thank you so much for your help.