hotshotiguana
New Member
- Joined
- Sep 20, 2005
- Messages
- 2
I am trying to fill a selected data series with one picture from my desktop if one value is selected and another picture if another value is selected, but I cannot for the life of me figure out how to do this in VBA. I am just missing the correct object member for the fill property and cannot find this online or in help. Any help would be greatly appreciated.
Thanks,
If crop = "Corn" Then
With ChartObjects("Chart 7")
With .SeriesCollection("Selected Area")
With .Fill
End With
End With
End With
Else
[insert other picture as fill]
End If
Thanks,
If crop = "Corn" Then
With ChartObjects("Chart 7")
With .SeriesCollection("Selected Area")
With .Fill
End With
End With
End With
Else
[insert other picture as fill]
End If