inserting a pattern fill in a chart in excel2007

[Guest]

how do u insert a pattern fill into a chart with the new excel 2007?

 

[Bob Umlas]

AFAIK, you can't -- the feature has been "deprecated", as they say.

 

[Guest]

in the background of the chart or in the data bars/lines?

 

[Ed Ferrero]

Hi Mandy,

how do u insert a pattern fill into a chart with the new excel 2007?

Try this as a workaround.

Select a range of cells
Format with a pattern of your choice
Copy
Select the chart series (or a single column)
Paste as Picture

Ed Ferrero
www.edferrero.com

 

[Andy Pope]

Hi,

The UI to patterns has gone but a little VBA goes a long way

No idea how long this will remain a work around.


With ActiveSheet.ChartObjects(1).Chart.SeriesCollection(1).Fill
.Patterned Pattern:=msoPatternLargeConfetti
.ForeColor.SchemeColor = 17
.BackColor.SchemeColor = 2
End With

Cheers
Andy