Striped Box or Shape on Graph?

[kpark91]

Hello,

I've see this in the graph I'm working on right now and there's a striped figure (Black & White) in a graph to show different regions of the graph.
and I am having trouble to recreate that shaded/striped figure on my graph without copy+pasting.

How do I create it in Excel 2007?

Thank you,
Kpark

 

[RoryA]

there's a striped figure (Black & White) in a graph

a zebra?

Not sure but perhaps you mean this?

 

[kpark91]

a zebra?

Yes!! It is exactly like a zebra except it certainly is not shaped like one

The link you gave me was something in similar ideas that it divides it into different regions of the graph but I was looking for more 'free' regions of the graph by just simply right-clicking on the zebra-filled shape and editing points.

The fill looks like this in C. MAKING A BAR GRAPH : http://www.uwlax.edu/biology/communication/ExcelFigures.html
except it's not a bar I want to fill in but a shape.

Thank you for replying back.
Kpark.

 

[RoryA]

Don't suppose you have a picture of what you are talking about?

 

[kpark91]

Ok. I'll try to put it up :P

 

[kpark91]

Something like this!
http://s1124.photobucket.com/albums/l579/kpark91/?action=view&current=abcd.jpg

Thank you so much once again :D

 

[RoryA]

Yikes. I think you'd have to draw that as a Freeform shape, unless perhaps you could plot it as an area chart.

 

[kpark91]

Thanks for taking a look at it.
Oh! I drew a freeform shape now!
Now, how do I fill it as zebra as you've said? xD

 

[RoryA]

Sadly, they removed that from the UI in 2007, although the code interface remains. Something like:

activesheet.shapes(1).fill.patterned msoPatternDarkDownwardDiagonal

for example.

 

[kpark91]

NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO~~~~~~~~~~~~~~~~~~~~~~~
Why did they remove it;;; I used it all the time because I only have B&W printer in my residence... NOOOOOOOO~~~

and yes... I JUST read that it was removed in excel 2007 and was about to post it here.

At least there's macro for it (thank god).

Thank you very much for your help rorya as always :P