Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do you control the color/pattern of a pie chart?

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveX control with chart Tanihera Charts and Charting in Excel 1 April 11th 06 05:36 PM
How to control chart properties from worksheet Marko Pinteric Excel Discussion (Misc queries) 3 April 5th 06 12:38 PM
How to control chart properties from worksheet Marko Pinteric Charts and Charting in Excel 1 April 5th 06 12:38 PM
API for MS Chart Control bill Charts and Charting in Excel 1 September 12th 05 07:00 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"