hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the black n
white printout .. which is not giving the clear on the percentage in graphs..
is there any way to feed the PATTERNS in graphs for black n white picture..
like in books we have seen those things..

Hi,

If what you are asking is can you apply Patterns to charts as in 2003 and
earlier, the answer is no - that feature has been removed.

I suggest that you TRY a gradient fill instead and see if that meets your
needs.

I haven't tested this but - maybe you can create the chart in 2003 and move
it to 2007?

--
Cheers,
Shane Devenshire


"manish" wrote:

hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the black n
white printout .. which is not giving the clear on the percentage in graphs..
is there any way to feed the PATTERNS in graphs for black n white picture..
like in books we have seen those things..

Hi,

As Shane points out the feature has been deprecated.
But here is a post I made in the newusers group.

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"manish" wrote in message
...
hello everyone,
i am using office 2007...
actually i have drawn some PIE charts and BAR charts with almost seven
variable each.. they are looking good in colors.. however i want the black
n
white printout .. which is not giving the clear on the percentage in
graphs..
is there any way to feed the PATTERNS in graphs for black n white
picture..
like in books we have seen those things..