Fill Options for 2007 Excell Chart
 

How can I get a bar chart to have lines or hatching? I only see the picture
or texture option. thanks

Fill Options for 2007 Excell Chart
 

You can't do this natively in 2007, but they left in the VBA hooks. Andy
Pope has an add-in that uses those hooks to apply patterns:

http://www.andypope.info/charts/patternfills.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Watson" wrote in message
...
How can I get a bar chart to have lines or hatching? I only see the
picture
or texture option. thanks

Fill Options for 2007 Excell Chart
 

Thanks.
That was a silly move to remove the option - not everyone prints in colour -
the lines/hatching are so much better (and the textures are useless)


"Watson" wrote:

How can I get a bar chart to have lines or hatching? I only see the picture
or texture option. thanks

Fill Options for 2007 Excell Chart
 

I think that most agree that they really screwed up charting with 2007


--


Regards,


Peo Sjoblom


"Watson" wrote in message
...
Thanks.
That was a silly move to remove the option - not everyone prints in
colour -
the lines/hatching are so much better (and the textures are useless)


"Watson" wrote:

How can I get a bar chart to have lines or hatching? I only see the
picture
or texture option. thanks

Fill Options for 2007 Excell Chart
 

I just found this thread and downloaded Andy Pope's "solution". Now how do I
get it to be available for all workbooks, even the one I started with. It is
not saved so I have to keep reinstalling the add-in. Am I doing something
wrong?



"Jon Peltier" wrote:

You can't do this natively in 2007, but they left in the VBA hooks. Andy
Pope has an add-in that uses those hooks to apply patterns:

http://www.andypope.info/charts/patternfills.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Watson" wrote in message
...
How can I get a bar chart to have lines or hatching? I only see the
picture
or texture option. thanks

Fill Options for 2007 Excell Chart
 

Have you actually installed it as an add-in? Once you've done this is should
remain available for all workbooks, across sessions of Excel.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"vtwoods" wrote in message
...
I just found this thread and downloaded Andy Pope's "solution". Now how do
I
get it to be available for all workbooks, even the one I started with. It
is
not saved so I have to keep reinstalling the add-in. Am I doing something
wrong?



"Jon Peltier" wrote:

You can't do this natively in 2007, but they left in the VBA hooks. Andy
Pope has an add-in that uses those hooks to apply patterns:

http://www.andypope.info/charts/patternfills.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Watson" wrote in message
...
How can I get a bar chart to have lines or hatching? I only see the
picture
or texture option. thanks