• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Want to use stripes as 'texture fill' in stacked bar chart

R

rmm405

New Member
I'm running Excel 2007 on Win 7. I've got a chart with stacked bars, and for some of them it's appropriate to do a plain striping of one color with white, or one color with black (not gradient). (The older versions of Excel seemed to allow this easily, but perhaps it was all black and white and I just don't remember that detail well.)


Does anyone know how to implement this easily? I've tried looking for clip art to overlay to get the striping I want, but couldn't find that. I don't want the texturing that is available as I feel it won't print well; I'd like to implement a plain white or black stripe on stop of a plain solid color.


Any ideas?
 
Easiest way would probably be to just draw/build the shape you want. Drawing some rectangles, and use the cells to help align things (Holding Alt will "snap" the drawing object to align"). I'd recommend choosing appropriate colors and no border. Then, group the 3 rectangles and copy the shape. Select the chart series and paste.
 
Thanks Luke M.


Are you suggesting I draw my own shape, say a small checkerboard of rectangles, in either Excel or PPT, and then using that as the 'custom' shape I wish to use in Texture Fill?


I'm wondering if I made the rectangles black and what; then had the underlying color I wanted for that part of the stack, I could get away with one 'texture' since the underlying color would show through the white (or perhaps 'no fill'). Then, I could have one texture to overlay multiple data series, but still see a different underlying color for each data series. Would this work?
 
I am working with the initial impression that you want a single color with 1 stripe. Using this "crude" drawing, you'd draw 3 rectangles (adjusting heght as necessary) stacked like so:

[]<- white rectangle, aka "background color"

[]<- black rectangle, aka "the stripe"

[]<- white rectangle


Group the shapes together. Then copy the shape, select the chart series, and paste. XL will automatically use the shape as the texture fill. This would make the series look like a white column with a black stripe.
 
Hey, I was dealing with the same problem until I read this:


http://blogs.office.com/b/microsoft-excel/archive/2007/11/16/chart-pattern-fills.aspx


It was very helpful. I finished my graph in a minute. You only need to enter the simple code in order to get the stripes or dots.
 
You must log in or register to reply here.
Back
Top