MSGraph.Chart.8 In Access 2003

[Guest]

My bar chart is working nicely in the report that I created. However, I
would like a little more detail on the Y axis. Currently, the labels show a
supplier name but I would like to be able to have both the supplier name and
contract number show for each spot on the Y axis. My underlying query has
the fields "SupplierName" and "LegalContractNumb". Is there anyway to have
both show up on the Y axis such as "Starbucks-C12345678" and then the next
one would be "Sears-C98765432"?, etc.
Thank you...

 

[Guest]

Additional question: How do I get the bars to be all the same width? Some
report pages have 10 bars, others 3 bars. So the bars are of varying widths
depending upon the number of items on the report page. Is there a way to
standardize them so each page has the same width for the bars?

 

[Guest]

The "detail on the Y axis" generally comes from a column in your chart's row
source. Modify this to combine the values you want displayed.

I am not aware of a way to turn off the automatic re-widthing of the bars.