related to PIE charts N BAR charts
 

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

related to PIE charts N BAR charts
 

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

related to PIE charts N BAR charts
 

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