I'm getting error on the following
dim ochart as object
set ochart = frm.fieldnameforchart
ochart.charttype = xlColumnClustered
ochart.hastitle = True
it fails on the .hastitle line with
error 1004 - unable to set the HasTitle property of the Chart Class
I also get failure on
ochart.axes(xlValue).ticklables.numberformat = "0%"
any thoughts - ?
thanks in advance.
(please don't tell me to do this in excel, I'm stuck with doing all of this charting directly in Access Forms. - thanks)