Do you want to have duplicate/copy of datasource 1. If yes, you can just simply duplicate it as below snapshot.
Is this so simple
No not that simple. As mentioned I already have 2 datasources.
I can easily duplicate the worksheet but how can I repoint all fields to datasource 2?
I don't think this is possible. If already you have same data as datsource then there is no point to re-point. If you want to double your value then we have union.
Thanks but this doesn't solve my problem.
Please correct me if iam wrong,
You have two data souce(Both data source are same) where you created charts with two data sources.Now you want to marge the two data source into one data source.
You can merge two data source into once by simple click on Data>Replace data source
Hope dis might help you....
If you copy the worksheet to a new workbook altogether, replace datasource 1 with datasource 2. Copy sheet back into the original version of the workbook.
Ben, done the trick, now need to re produce all.
If you have multiple sheets you want to duplicate, then do all of the sheets at the same time. If you don't, you will end up with multiple versions of datasource 2 in your workbook.
So do ctrl + select all sheets you want to duplicate --> copy --> paste to new workbook --> replace datasource 1 to datasource 2 --> copy all worksheets back to original workbook.