Hello all,

I am trying to get data from 2 different sheet in 1 line stacked line chart.
It is working with the following code:

.SeriesCollection.NewSeries
'Value
.SeriesCollection(1).Values = wsWaarde.Range(wsWaarde.Cells(W + 1, j + 1), wsWaarde.Cells(LaatsteCellWaarde, j + 1))
'Date
.SeriesCollection(1).XValues = wsWaarde.Range(wsWaarde.Cells(W + 1, j), wsWaarde.Cells(LaatsteCellWaarde, j))
.SeriesCollection.NewSeries
'Value
.SeriesCollection(2).Values = wsGemiddelde.Range(wsGemiddelde.Cells(Z + 1, l + 9), wsGemiddelde.Cells(LaatsteCellGemiddelde, l + 9))
'Date
.SeriesCollection(2).XValues = wsGemiddelde.Range(wsGemiddelde.Cells(Z + 1, l), wsGemiddelde.Cells(LaatsteCellGemiddelde, l))

The given data are values over time, in the first series every day there is a new value but in the second series there is just a new value once every couple of weeks/months.
I wont to compare those data in 1 chart. Now i got both data in 1 chart, but second series does follow the time schedule on the horizotal axis.
Can someone help me get the second series on the same time schedule?

Thanks in advance