google sheets
I have a couple of column charts in Google Sheets that have several columns of data. I would like to print them out in just black and white, since they are part of a larger report that doesn't need color at all. But when I choose the style for the columns, I can only specify different colors, which are tough to tell apart when printed in black and white.
Is there any way of specifying a pattern or something for the different columns, such that they will be easy to tell apart?
I've shared a sheet for you to play with here. There is a fourth sheet to help write the second solution
The simple solution (with only numeric ids) is quite straightforward:
=MAX(Sheet1!A2:A,Sheet2!A2:A, Sheet3!A2:A)
(This assumes each column has a title)
The situation with a prefix works like this:
="R" & MAX(
ARRAYFORMULA(IF(ISBLANK(Sheet1!B2:B), 0,
VALUE(RIGHT(Sheet1!B2:B, LEN(Sheet1!B2:B)-1)))),
ARRAYFORMULA(IF(ISBLANK(Sheet2!B2:B), 0,
VALUE(RIGHT(Sheet2!B2:B, LEN(Sheet2!B2:B)-1)))),
ARRAYFORMULA(IF(ISBLANK(Sheet3!B2:B), 0,
VALUE(RIGHT(Sheet3!B2:B, LEN(Sheet3!B2:B)-1))))
)
What I'm doing here is:
This assumes the prefix is constant and only one character.
If you would like that Google change this behaviour send your feedback to Google. To do that click on Help > Report a problem
An alternative workaround is to add a second column to Order by that uniquely makes unique pairs, i.e.
=query(Handler!A3:E999,"Select A,B,C Where A > -1 and A < 54 Order by B,C")
Best Answer
Currently there are 8 grayscale options for column colors, ranging from black to white. I suppose the distinguishability of those grays will depend upon print quality. I don't see any way to specify patterns that would be more clearly visible in black and white.