inserting a pattern fill in a chart in excel2007
 

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

inserting a pattern fill in a chart in excel2007
 

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

"~Mandy~" wrote in message
...
how do u insert a pattern fill into a chart with the new excel 2007?

inserting a pattern fill in a chart in excel2007
 

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


"~Mandy~" wrote:

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

inserting a pattern fill in a chart in excel2007
 

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

inserting a pattern fill in a chart in excel2007
 

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

~Mandy~ wrote:
how do u insert a pattern fill into a chart with the new excel 2007?