PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Old-fashioned cross-hatching in bar chart (X-post)

Reply

Old-fashioned cross-hatching in bar chart (X-post)

 
Thread Tools Rate Thread
Old 10-07-2008, 07:06 PM   #1
Posterizer
Guest
 
Posts: n/a
Default 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 Format>Data
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
  Reply With Quote
Old 10-07-2008, 07:32 PM   #2
Posterizer
Guest
 
Posts: n/a
Default Re: 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
  Reply With Quote
Old 10-07-2008, 07:34 PM   #3
Bernard Liengme
Guest
 
Posts: n/a
Default Re: 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" <askme@ifyouneedit.com> wrote in message
news:askme-EC73DF.11063510072008@gondor.sdsu.edu...
> 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 Format>Data
> 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


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off