Quote Originally Posted by Admin View Post
Hi Rafal,

Welcome to ExcelFox!!

PLease use code tags. This time I added for you.

Try

Code:
ActiveChart.SetSourceData Source:=Union(MyDataSource1, MyDataSource2)
It works, thank you so much.

Also, I have noticed that updating the data source changes axis lables to default values (1,2,3,4...)
I had to implement additional piece of code:

Code:
DestBook.Worksheets(4).ChartObjects("Chart 61").Chart.SeriesCollection(1).XValues = MyDataSource3