vba: arrange axis in a graph

[waldymar]

Dear All,

I have a macro which copies, pastes and delink graph from the original source.

For Each chtCopy In ws.ChartObjects
For Each objSeries In chtCopy.Chart.SeriesCollection
objSeries.XValues=objSeries.XValues
objSeries.Values=objSeries.Values
objSeries.Name=objSeries.Name
Next
Next

The problem appears that it changes the x axis values. For example, I have dates like 8th, 9th, 12th, 13th, 14th and 15th of September. As you can see there is a gap (weekend) of dates. When my macro delink it puts sequencial dates from 8th to 13th. Does anyone knows how to fix it?
Thanks in advance