I just downloaded the zip file from my site. There is no password on the
zip file.
The UI to Pattern fills have been reinstated in 2010.
Cheers
Andy
NonTechie wrote:
Thanks, John. Pardon this lengthy reply. I have Excel 2007. Sorry I forgot to
say that.
Anyway, the procedure did not work. I followed the instructions in Excel's
help for "Load or unload add-in programs." I clicked Office ButtonExcel
OptionsAdd-Ins. Then selected Excel Add-Ins under the Manage box and clicked
Go. I got a little Add-Ins window with a list of add-ins (Analysis toolPak
and Analysis ToolPak - VBA were there and already checked) and Pattern Fills
was listed. I checked it and then clicked OK.
But then when I go to a chart and get the format data series menu for a bar
on a histogram and select Fill (or any other option) there is no option for a
pattern.
So then I started over and downloaded Andy Pope's Pattern Fills add-in. When
I went to extract the zip file, it asked for a password. Evidently I never
really unzipped it in the first place. So, I don't know what the password is
to unzip the file and I am still stuck.
It is important to me to be able to have a pattern fill as I print charts in
black and white and want to distinguish easily between series on a histogram.
I don't understand why pattern fill was deleted from 2003 for the 2007
version. Maybe you could tell the Excel designers to put it back in.
Anyway, any help you could give me would be much appreciated. Thanks in
advance.
"John Mansfield" wrote:
When you open the zip file you should see the Excel add-in file. Copy it and
paste it to a directory location of your choice.
At this point it's time to install the add-in. To do so and assuming Excel
2003, go to Tools - Add-Ins - Browse. Find the file that you just saved
and click on it. It should now appear in the Add-ins dialog box.
For more information on installing an add-in, search Excel's help for "Load
or unload add-in programs".
--
John Mansfield
http://www.cellmatrix.net
"NonTechie" wrote:
Thanks, John. I downloaded the zip file and opened it. But when I looked at
the add-ins list, it wasn't there. In what folder should the add ins file be
located? Maybe I put it in the wrong place. There were no directions on what
to do with the file.
"John Mansfield" wrote:
Hello,
Below is a link to Andy Pope's Pattern Fills add-in:
http://www.andypope.info/charts/patternfills.htm
--
John Mansfield
http://www.cellmatrix.net
"NonTechie" wrote:
I want to add in Pattern Fill, but it is not in the Add-In list. How do I get
it?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info