Kpatel
03-15-2005, 04:32 AM
Hi,
I am facing difficulty in hiding a series collection. I am using Ms Access 2002, MDAC 2.8 and Windows XP Professional. Currently use the following code to color them, this works:
oChart.SeriesCollection(1).Interior.Color = ?Red?
I have tried the following code with no success:
oChart.SeriesCollection(1).Interior.Color = ?None?
oChart.SeriesCollection(1).Interior.Color = ?xlNone?
oChart.SeriesCollection(1).Interior.Color = ?false?
oChart.SeriesCollection(1).Interior.Color = ?0?
I can change the seriescollection color so that it matches the background thus camouflaging it, but this method does not hide it efficiently.
Is there are method, function or color attribute equivalent to that of when you manually set the color to ?None??
Any comments you have on this will be appreciated.
Thanks
Keyur
I am facing difficulty in hiding a series collection. I am using Ms Access 2002, MDAC 2.8 and Windows XP Professional. Currently use the following code to color them, this works:
oChart.SeriesCollection(1).Interior.Color = ?Red?
I have tried the following code with no success:
oChart.SeriesCollection(1).Interior.Color = ?None?
oChart.SeriesCollection(1).Interior.Color = ?xlNone?
oChart.SeriesCollection(1).Interior.Color = ?false?
oChart.SeriesCollection(1).Interior.Color = ?0?
I can change the seriescollection color so that it matches the background thus camouflaging it, but this method does not hide it efficiently.
Is there are method, function or color attribute equivalent to that of when you manually set the color to ?None??
Any comments you have on this will be appreciated.
Thanks
Keyur