Bar Chart Width

[Dwight]

I have a bar graph that displays between 1 and 5 categories depending on the underlying data.

My problem is that Access scales the width of the bars according to how many categories are graphed. Thus, for 1 category one big fat bar shows up. And when there are 5 they are much slimmer.

Does anyone know the VBA code that will allow me to fix the width?

Thanks in advance,

Dwight

 

[Dwight]

I have not been able to solve this yet.

I have had no luck searching the Chart Options or the VBA Help files.

I'm sure it is some simple setting I am missing.

Any ideas?