dhaskins43
New member
- Local time
- Today, 05:56
- Joined
- Jul 9, 2002
- Messages
- 2
Has anyone used the ErrorBar method to add custom error bars to an Access chart? I can get it to work to using the generic options (ie. standard error) but what I want to do is have the error bars based on a third column in my query. Excel has a custom option that will allow you to do this.
The ErrorBar method has the option to set the type to xlCustom, but I haven't had any luck getting it to work or find a working example online.
My other (ugh) option is to try and create the chart in Excel but have it display in my Access form and update dynamically as you change records. I've had even worse luck finding help for this; any useful references no longer seem to exist.
Any ideas to try or places to look greatly appreciated!
The ErrorBar method has the option to set the type to xlCustom, but I haven't had any luck getting it to work or find a working example online.
My other (ugh) option is to try and create the chart in Excel but have it display in my Access form and update dynamically as you change records. I've had even worse luck finding help for this; any useful references no longer seem to exist.
Any ideas to try or places to look greatly appreciated!
