ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do you control the color/pattern of a pie chart? (https://www.excelbanter.com/charts-charting-excel/99436-how-do-you-control-color-pattern-pie-chart.html)

Pie chart

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?

Andy Pope

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


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com