G
Guest
how do u insert a pattern fill into a chart with the new excel 2007?
B
Bob Umlas
AFAIK, you can't -- the feature has been "deprecated", as they say.
G
Guest
in the background of the chart or in the data bars/lines?
E
Ed Ferrero
Hi Mandy,
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
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
A
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
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