No, as you stated, ... I am left with a selection of data in a single column
e.g. AC7:AC100

Just change Selection to Datasource1, they are both ranges.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Tommy" wrote in message
...
Whilst this code allows for the setting of the source data, you must
define all source data in a single selection which is not what I wish
to achieve. As I stated before, how do I store the already selected
AC7:AC100 as a range called DataSource1 that I will be able to pass to
SeriesCollection(1).Values?