Hello everybody,
I have an annoying problems with Excel versions. I have Excel 2007 on my workstation, but I'm editing an old Ms Access Database who are calling an old version of Excel. I want to select the colors from my SeriesCollection, but the code I have seen for newer version isn't working for me in my old database. It's working well in Excel 2007 :
How can I do the same thigs as the following code in Excel 2002 ?
I've seen other examples, but so far none are working. I'll continue to search a solution.![]()
ActiveChart.SeriesCollection(1).Points(1).Interior.Color = RGB(200, 0, 0) ActiveChart.SeriesCollection(1).Points(2).Interior.Color = RGB(0, 200, 0) ActiveChart.SeriesCollection(1).Points(3).Interior.Color = RGB(0, 0, 200) ActiveChart.SeriesCollection(1).Points(4).Interior.Color = RGB(200, 20, 34) ActiveChart.SeriesCollection(1).Points(5).Interior.Color = RGB(54, 54, 200) ActiveChart.SeriesCollection(1).Points(6).Interior.Color = RGB(34, 255, 200) ActiveChart.SeriesCollection(1).Points(7).Interior.Color = RGB(200, 34, 0) ActiveChart.SeriesCollection(1).Points(8).Interior.Color = RGB(1, 200, 1)
Thank you !











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks