Variable size boxes in Reports

[jonobugs]

I'm trying to create a simple chart in Access but I can't seem to do it. I can create it very easily in Excel. It's just a simple posting of values that I want to give a report on with every record. I'm including an example of what I would like to do...(but with ACCESS, not Excel)

It's basically a set of scores for students. I remember reading somewhere how someone created a chart using VBA with boxes, and not the charting system in ACCESS but I can't seem to find that again.

Also, I want to be able to report on each student separately. That is, they are doing 6 tests and I want to show how they did on those tests with a simple bar graph. (I'm also open to other ideas though)

If the solution is already listed on this site somewhere, I would love it if someone could point me in the right direction. I've been looking for ages, but I can't seem to find what I'm looking for.

Thanks for any help!

 

[Geotch]

Graphs aren't easy to learn in Access, but once you get the one as a template, they are easy to change. I've uploaded a sample for you to use.

Couple of things to remember. I always create graphs in a form. For some reason you can actually see a what it will look like in design view of the form. Design view of the report doesn't show what the graph will actually look like.

So make any changes in the form in this database, then copy and paste to the report and you should be good.

Mike Alexander has a neat trick for creating bargraphs with a Char block. I'll have to see if I can find the database with that example.

Good luck with this one.

 

[jonobugs]

Thanks Geotch. I'm just looking at it now to try and figure it out. BTW, I'm using Access 2007.

 

[JHB]

Design view of the report doesn't show what the graph will actually look like.

It is not correct, show the report in "Print Preview" and save it, sometimes you have to save/close the report et pair of times before the changes take effect.

 

[jonobugs]

Thanks JHB. I understood what he meant though. With the graph in the Form, you can see what it looks like without having to preview, but you have to go to print preview if you use it in reports.

 

[JHB]

Only for clarifying, if you do as described in post #4, (and the change has taken effect), you can see what it looks like in the report's design view.