ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Old-fashioned cross-hatching in bar chart (X-post) (https://www.excelbanter.com/charts-charting-excel/194444-old-fashioned-cross-hatching-bar-chart-x-post.html)

Posterizer

Old-fashioned cross-hatching in bar chart (X-post)
 
Gang,
Just reposting this with a cross to the charting group. Sorry for the
dupe in the Mac group...

I need to format a black & white bar chart for a journal that strongly
discourages use of grayscale shading, and recommends cross-hatching for
any shading. I cannot find this "old-fashioned" format in either the
Formatting Palette (Colors, Weights and Fills) or in the FormatData
Series dialog. All I can find are colors, grayscales, gradients,
pictures...

I'm using Excel v 12.1.1 on Mac (OS 10.4.11, if it makes a difference)

TIA,
Dennis

Posterizer

Old-fashioned cross-hatching in bar chart (X-post)
 
Oops, I guess the correct term is column chart, not bar chart. Not sure
that makes a difference for this formatting, but just in case it does...

Dennis

Bernard Liengme

Old-fashioned cross-hatching in bar chart (X-post)
 
In XL2007 (Windows) the cross-hatching was deprecated (very sad)
However, it only the interface that has gone so Andy Pope has an add-in to
give us access
http://www.andypope.info

But I recall that the Mac is VBA-less, so this will not work for you.
I suggest you post to the mac.excel group for help
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Posterizer" wrote in message
...
Gang,
Just reposting this with a cross to the charting group. Sorry for the
dupe in the Mac group...

I need to format a black & white bar chart for a journal that strongly
discourages use of grayscale shading, and recommends cross-hatching for
any shading. I cannot find this "old-fashioned" format in either the
Formatting Palette (Colors, Weights and Fills) or in the FormatData
Series dialog. All I can find are colors, grayscales, gradients,
pictures...

I'm using Excel v 12.1.1 on Mac (OS 10.4.11, if it makes a difference)

TIA,
Dennis




All times are GMT +1. The time now is 03:07 PM.

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