Fill pattern in columns

We have a collection of charts, some of which we use the gray scale for the palette (users only have B&W printers). We need to use the same patterns in other charts for consistency. The only option I see in Edit Chart Value-->Appearance-->Series Style-->Fill is Gradient. Is there any way to pick a fill pattern?

The pattern is the diagonal lines slanting down from left to right. It is the third column in the gray scale, so I have tried to add a dummy column as the first column, so that my column would have this pattern. However, the chart allows for space width wise for the first column, so there is a blank space on the chart. I have the Data Output checked to No.

Any other ideas, I would appreciate it!

Is there an expression I can write so that if the value of that bar is equal to zero or less than one, etc. then

the visibility would equal false?

|||

You could use a switch statement, and maybe set the fill to transparent when the value is 0.

Example:

=Switch(Value1 = Value2,"Black", Value1 > Value2, "Green",Value1 < Value2, "red")