Once again I come to the talented pool for help. I have a report that I want to place a bar chart in. The report is based on a query. I can't seem to get the chart wizard to provide the info correctly. More than that, i can't get rid of the default North, South axes etc. What is the best way to produce a chart on a report. The report itself works fine. But the boss want a "graphical depiction" to match. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Bar chart based on query in a report 1
- Thread starter Emario
- Start date
-
1
- #2
I ran into the same frustrating problem myself...
There may be better ways to do this, but what I did was to clear the contents of the data table in MS Graph. I then ran the Access query so that it came up in a datasheet view.
I highlighted all the columns in the query, copied and then pasted into the MS Graph datasheet. This seems to work and maintain a dynamic link so that as data changes, the chart changes.
By doing this, you can also include far more fields of data than the Access chart wizard will allow. I needed approx 20 fields whereas the wizard will allow only 6.
There may be better ways to do this, but what I did was to clear the contents of the data table in MS Graph. I then ran the Access query so that it came up in a datasheet view.
I highlighted all the columns in the query, copied and then pasted into the MS Graph datasheet. This seems to work and maintain a dynamic link so that as data changes, the chart changes.
By doing this, you can also include far more fields of data than the Access chart wizard will allow. I needed approx 20 fields whereas the wizard will allow only 6.
- Status
Similar threads
- Locked
- Question
- Locked
- Question