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.
Last edited by vinodh18; 02-29-2016 at 02:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Bookmarks