P
Penguin
I am trying to set the interior color to a pattern or custom pattern.
I can identify the series collection by a number but the help file
says I can identify it by its name. My code looks like this:
Dim MyChart As Object
Set MyChart = Me!Graph0
' This line does not work
MyChart.SeriesCollection("Carpet").Interior.Color = RGB(255, 0, 0)
' This line does work
MyChart.SeriesCollection(1).Interior.Color = RGB(255, 0, 0)
Now the above code uses a color for the interior but I would like to
use the patterns or a custom pattern. The reason is that the series
changes each time I view the graph.
Any help??
I can identify the series collection by a number but the help file
says I can identify it by its name. My code looks like this:
Dim MyChart As Object
Set MyChart = Me!Graph0
' This line does not work
MyChart.SeriesCollection("Carpet").Interior.Color = RGB(255, 0, 0)
' This line does work
MyChart.SeriesCollection(1).Interior.Color = RGB(255, 0, 0)
Now the above code uses a color for the interior but I would like to
use the patterns or a custom pattern. The reason is that the series
changes each time I view the graph.
Any help??