Excel 2007 texture fill of chart data series columns

Thanks much for posting this UI. The patterns are indispensable when I have
to make charts meant to be printed in black and white. I was puzzled why this
functionality was removed from Excel 2007.

With much appreciation,

Eric

"Andy Pope" wrote:

> Thanks for the update. Glad you was able to get it sorted.
>
> Cheers
> Andy
>
> Leland wrote:
> > Hi Again Andy Pope,
> >
> > Some other users in the "General Questions" group under Excel helped me find
> > a solution to my problem. I saved the Add-in to the following folder
> >
> > C:\Program Files\Microsoft Office\Office12\Library
> >
> > And now it shows up just like you said it would. I cannot thank you enough
> > for your help. I am truly grateful.
> >
> > -Leland
> >
> >
> > "Leland" wrote:
> >
> >
> >>Andy Pope-
> >>
> >>Your advice is terrific, but I guess I need a bit more. When I download
> >>your add-in, it works great and the chart looks exactly like I want.
> >>Wonderful!
> >>
> >>Then I follow your instructions about how to install the add-in, I am not
> >>able to do it. I click the Office button, the Excel options button, and the
> >>Add-ins button, but there is only one active application add-in available
> >>(“Send to Bluetooth”?) and when I click the “Go…” button the add-in option
> >>that I want (I am assuming that would be “Pattern Fills”) is not available.
> >>
> >>How to I make your Pattern Fills Add-in appear in the “Active Application
> >>Add-ins” Window?
> >>
> >>Thank you so much. -Leland
> >>
> >>
> >>
> >>
> >>"Andy Pope" wrote:
> >>
> >>
> >>>Hi,
> >>>
> >>>The UI for that feature was removed in xl2007 but this addin provides a
> >>>method of doing pattern fills.
> >>>http://www.andypope.info/charts/patternfills.htm
> >>>
> >>>And this is how you install add-ins.
> >>>http://www.andypope.info/tips/tip010.htm
> >>>http://peltiertech.com/WordPress/2008/08/20/installing-an-add-in-in-excel-2007/
> >>>
> >>>Cheers
> >>>Andy
> >>>--
> >>>
> >>>Andy Pope, Microsoft MVP - Excel
> >>>http://www.andypope.info
> >>>"Leland" <Leland.RemoveThis@discussions.microsoft.com> wrote in message
> >>>news:AEA57FF9-844A-4743-81B7-5B7BB7448DF3@microsoft.com...
> >>>
> >>>>I need a way to use fill type to distinguish columns in a column chart for
> >>>>a
> >>>>black and white publication. Ideally, this would be the traditional
> >>>>horizontal, vertical or diagonal stripes or dots or checks. The only fill
> >>>>options I seem to get in 2007 Excel are shading, colors, or "textures",
> >>>>none
> >>>>of which really fulfill my needs. Is there any way to access the
> >>>>traditional
> >>>>stripes or dots from previous versions of Excel?
> >>>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

The feature has been reinstated in Office 2010
Andy's change at making a fortune just left <gr>
But lots of us appreciate what is add-in has done for us meanwhile
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Eric" <Eric.TakeThisOut@discussions.microsoft.com> wrote in message
news:56B3A54B-9AA1-4B93-9AD6-AFC06F3018C5@microsoft.com...
> Thanks much for posting this UI. The patterns are indispensable when I
> have
> to make charts meant to be printed in black and white. I was puzzled why
> this
> functionality was removed from Excel 2007.
>
> With much appreciation,
>
> Eric
>
> "Andy Pope" wrote:
>
>> Thanks for the update. Glad you was able to get it sorted.
>>
>> Cheers
>> Andy
>>
>> Leland wrote:
>> > Hi Again Andy Pope,
>> >
>> > Some other users in the "General Questions" group under Excel helped me
>> > find
>> > a solution to my problem. I saved the Add-in to the following folder
>> >
>> > C:\Program Files\Microsoft Office\Office12\Library
>> >
>> > And now it shows up just like you said it would. I cannot thank you
>> > enough
>> > for your help. I am truly grateful.
>> >
>> > -Leland
>> >
>> >
>> > "Leland" wrote:
>> >
>> >
>> >>Andy Pope-
>> >>
>> >>Your advice is terrific, but I guess I need a bit more. When I
>> >>download
>> >>your add-in, it works great and the chart looks exactly like I want.
>> >>Wonderful!
>> >>
>> >>Then I follow your instructions about how to install the add-in, I am
>> >>not
>> >>able to do it. I click the Office button, the Excel options button,
>> >>and the
>> >>Add-ins button, but there is only one active application add-in
>> >>available
>> >>("Send to Bluetooth"?) and when I click the "Go." button the add-in
>> >>option
>> >>that I want (I am assuming that would be "Pattern Fills") is not
>> >>available.
>> >>
>> >>How to I make your Pattern Fills Add-in appear in the "Active
>> >>Application
>> >>Add-ins" Window?
>> >>
>> >>Thank you so much. -Leland
>> >>
>> >>
>> >>
>> >>
>> >>"Andy Pope" wrote:
>> >>
>> >>
>> >>>Hi,
>> >>>
>> >>>The UI for that feature was removed in xl2007 but this addin provides
>> >>>a
>> >>>method of doing pattern fills.
>> >>>http://www.andypope.info/charts/patternfills.htm
>> >>>
>> >>>And this is how you install add-ins.
>> >>>http://www.andypope.info/tips/tip010.htm
>> >>>http://peltiertech.com/WordPress/2008/08/20/installing-an-add-in-in-excel-2007/
>> >>>
>> >>>Cheers
>> >>>Andy
>> >>>--
>> >>>
>> >>>Andy Pope, Microsoft MVP - Excel
>> >>>http://www.andypope.info
>> >>>"Leland" <Leland.TakeThisOut@discussions.microsoft.com> wrote in message
>> >>>news:AEA57FF9-844A-4743-81B7-5B7BB7448DF3@microsoft.com...
>> >>>
>> >>>>I need a way to use fill type to distinguish columns in a column
>> >>>>chart for
>> >>>>a
>> >>>>black and white publication. Ideally, this would be the traditional
>> >>>>horizontal, vertical or diagonal stripes or dots or checks. The only
>> >>>>fill
>> >>>>options I seem to get in 2007 Excel are shading, colors, or
>> >>>>"textures",
>> >>>>none
>> >>>>of which really fulfill my needs. Is there any way to access the
>> >>>>traditional
>> >>>>stripes or dots from previous versions of Excel?
>> >>>
>>
>> --
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info
>>