Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 26th 13, 05:28 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2013
Posts: 1
Default Pie chart with hatch marks (black and white)

Can someone tell me how I can create a pie chart in Excel 2007 with hatch marks? I know they removed the functionality of this from previous versions, I've tried some of the add-ins for "Pattern fills" that people had posted but they do not seem functional any longer.

Please help!

  #2   Report Post  
Old September 27th 13, 10:13 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2013
Posts: 6
Default Pie chart with hatch marks (black and white)

Here's a not very satisfactory method.

Go to Word. Draw a box. Fill the box with the pattern you want from Format Auto Shapes. Copy the box (to the clipboard). Back to Excel and format the slice. Fill from the clipboard. The actual size of the hatching depends on the size of the Word box and the size of the pie slice but it may give you what you need.

Why do "enhancements" to Excel just make life harder?
  #3   Report Post  
Old December 24th 14, 02:00 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2014
Posts: 1
Default Pie chart with hatch marks (black and white)

On Friday, September 27, 2013 12:28:49 AM UTC+8, infogirl wrote:
Can someone tell me how I can create a pie chart in Excel 2007 with
hatch marks? I know they removed the functionality of this from previous
versions, I've tried some of the add-ins for "Pattern fills" that people
had posted but they do not seem functional any longer.

Please help!




--
infogirl


Hey, I got the solution but i am sure it is useless since this is an old post. In Excel 2010, you will need to do it seperately for every portion of the pie. Double click on any of them, choose fill pattern. When done, click close. Do the same for the rest of the pie.

Wish it will be helpful for anyone having same problem in the future.
  #4   Report Post  
Old May 4th 18, 10:40 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2018
Posts: 1
Default Pie chart with hatch marks (black and white)

On Wednesday, December 24, 2014 at 4:00:26 AM UTC+2, wrote:
On Friday, September 27, 2013 12:28:49 AM UTC+8, infogirl wrote:
Can someone tell me how I can create a pie chart in Excel 2007 with
hatch marks? I know they removed the functionality of this from previous
versions, I've tried some of the add-ins for "Pattern fills" that people
had posted but they do not seem functional any longer.

Please help!




--
infogirl


Hey, I got the solution but i am sure it is useless since this is an old post. In Excel 2010, you will need to do it seperately for every portion of the pie. Double click on any of them, choose fill pattern. When done, click close. Do the same for the rest of the pie.

Wish it will be helpful for anyone having same problem in the future.


Thanks david! helped someone in 2018!
  #5   Report Post  
Old July 17th 18, 01:19 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2018
Posts: 1
Default Pie chart with hatch marks (black and white)

Bom dia, gostaria de saber se alguém sabe como fazer a legenda do gráfico de pizza permanecer conectada através de linhas ao gráfico. Tentei usar a opção legend.posicion: 'marked', mas não funciona.


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
How do I change text from Black on white to white on black? Joe G. New Users to Excel 1 December 19th 08 09:43 PM
Black and white printing jerminski73 Excel Worksheet Functions 2 December 7th 07 08:58 PM
Printing in Black and White Corey Excel Programming 1 April 27th 07 12:53 AM
black and white display jaidencam Excel Worksheet Functions 1 January 4th 07 02:57 AM
How do I change all chart colors to black and white? deedee3 Charts and Charting in Excel 1 March 17th 05 04:53 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017