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.
Bookmarks