Thanks, Andy! I really like your site and just played your sudoko
game. I am sorry that they removed this functionality, and am glad
that I now have your addin. It works well, but is there a mode where
it can automatically generate each chart element in different fill
patterns rather than having to go in and have each element filled
explicitly? Thanks for sharing your wisdom and Excel resources!

Dilip

On Feb 27, 3:42*am, "Andy Pope" wrote:
Hi,

They removed the UI for pattern fills in 2007.
Fortunately the functionality is still available via code. I have an add-in
that allows you to use pattern fills.http://www.andypope.info/charts/patternfills.htm

There is a blog post by Eric Patterson, a program manager on the Excel team,
on the subject.http://blogs.msdn.com/excel/archive/...ern-fills.aspx

Cheers
Andy

--

Andy Pope, Microsoft MVP - wrote in message

...



I can't seem to figure out (it was easy in earlier versions!) how to
take pie charts (or other types of charts) and make them independent
of color. I don't mind if the chart uses color, but I don't want to
rely on color to make sure that people of varying sensitivities to
color or a black and white photocopy doesn't put the user of the chart
at a disadvantage. How can I have my different pie slices not just a
different color, but in a different cross-hatch or other fill? Thanks,
and sorry if this is obvious!- Hide quoted text -

- Show quoted text -