Hi,
I'm trying to find a way to use VBA to set the data source range in a scatter chart.
At the moment the scatter chart uses the range A2:B18 which has been named "chart_range".
When I try and add "chart_range" to the source data field it fails with the following error message "Object doesn't support this property or method".
There are limitations in Excel with using dynamic data source range in a scatter chart but was wondering if anyone might have an alternative solution.

Many thanks for any help