hard times with seriescollection.xvalues problem

[phn]

hello,

I am programming chart of some time series and all the needed data is in excel sheets. Everything works fine except one thing: when I am taking event dates of time series (it is every last day of the month starting from 2008 01 31) from sheets I do not know how to rewrite them in different format, because it sheets it is given as:

310108, what would be as 2008.01.31 in my desiring format.

So my question would be:

imagine you have 3 data points, which occured on 310308, 300408 and 310508. Is it possible to copy these dates and somehow rewrite them in format of 2008.03.31, 2008.04.30 and 2008.05.31 into chart?


I would appreciate any help.

Regards,
Edgaras

 

[m.k.johnson86]

Hey,

cant you use something like

="20"&RIGHT(S1,2)&"."&MID(S1,3,2)&"."&LEFT(S1,2)

does this get it into the format you require?

 

[phn]

Yeah, but is it possible to write like this?

For i = j To total_number_of_data
ActiveSheet.SeriesCollection(1).XValues.Items(i).Values = "20" & "." & Right(ActiveSheet.Cells(2, i).Values, 2) & "." & Mid(ActiveSheet.Cells(2, i).Values, 3, 2) & "." & Left(ActiveSheet.Cells(2, i).Values, 2)
Next i


Because I get an error in this part:

ActiveSheet.SeriesCollection(1).XValues.Items(i).Values = "20" & "."....

How to edit that?

p.s. thanks for a reply!!