D
Dave Stone
Is it possible to set custom error bars on a XY scatter graph in Access
where the size of the bars is different for each point in the series (and
contained in a column of the table that the chart is based on)? It's
straightforward in Excel, but the Access chart interface specifically omits
the facility. I can't see how to do it in VBA, the syntax of the ErrorBar
method seems to allow an Amount parameter like "=Sheet1!R2C8:R12C8" which
isn't much use in Access!
Dave
--
************************************************************************
Dave Stone e-mail: (e-mail address removed)
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************************************
where the size of the bars is different for each point in the series (and
contained in a column of the table that the chart is based on)? It's
straightforward in Excel, but the Access chart interface specifically omits
the facility. I can't see how to do it in VBA, the syntax of the ErrorBar
method seems to allow an Amount parameter like "=Sheet1!R2C8:R12C8" which
isn't much use in Access!
Dave
--
************************************************************************
Dave Stone e-mail: (e-mail address removed)
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************************************