I have searched high and low and only able to come up with answers pertaining to excel. I would like to know if there is a way to control different properties of a chart from VBA such as the scale of the axis.
Thanks,
Matthew
Someone earlier pointed out that the Access chart is the same as the Excel chart with one major exception.
The Acces chart wizard is dumber than a sack of rocks. And its true.
If you know how to do graphs in Excel, only use the Access wizard to create the actual graph. Then manually fine tune the graph using the same commands you would use in Excel.
Its the best way of approaching a very difficult subject.