Charts in a Report

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I am trying to create a simplistic bar chart from a query
that I created in my database. The query contains a list
of employees in the y-axis and a number amount down the X-
axis. The problem I'm having is I have 20 employees and
only 3 are showing up. I am very new to chart creations,
so how do I adjust the y-axis to show everyones name.
Even more, how do I change the increments of the numerical
values in the x-axis.

Cheers,

Cornish Teeth
 
Frank:

The chart object has a columns property that is displayed when you click on
it and open Access' standard property sheet. You can set this value higher
number to display all the employees or you can add code like this to the On
Print event of the section of the report that contains the chart.

Dim objChart as Object
Set objChart = Me!Name of Your Chart Control
objChart.Refresh
Set objChart = Nothing
 
Back
Top