Charts in a excel sheet gets hidden when data is added from series collection.

Charts in a excel sheet gets hidden when data is added from series collection and has values from different cells in excel.

Sample Code :

.Chart.SeriesCollection.NewSeries
.Chart.SeriesCollection(1).Values = "='Comparison Report - Version'!E10,'Comparison Report - Version'!H10,'Comparison Report - Version'!K10,'Comparison Report - Version'!N10"

After generating the chart with the above code, when i save my worksheet the chart gets hidden.

Any one can help me.

Thanks in Advance.

~Vinodh.