View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How do you control the color/pattern of a pie chart?

Hi,

To format a slice you need to select it first. Click the pie once to
select all slices. Click again to select individual slice.
You can use the Fill Effects Patterns to fill with b/w patterns.

Also in print preview the Setup dialog has a Print Black & White option
on the Chart Tab. Note this is only visible if you have a chart sheet or
select the chartobject before print preview.
If you are printing chartobjects on a worksheet the B/W option is on the
Sheet tab within print preview setup.

Cheers
Andy

Pie chart wrote:
I need help with my pie charts. I need to create pie charts that are easily
understood in B&W. How do I set the color or pattern for each portion of my
pie chart?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info