Sep
13

Someone Think of the Colorless

Published: Tuesday, September 13, 2005, at 12:40AM

In high school they had "Computers" classes where they taught you how to use things like Word and Excel. I never took those classes. I did "independent study computers" and built the school web site.

But tonight some of that might have come in useful. I've been trying to make some charts in gnumeric, to lay out financial info for tomorrow's DLANC meeting. I've successfully figured out how to make the charts, but it would appear that gnumeric has zero support for choosing sensible colors that will show up in grayscale. Does Excel handle that better? How hard can it be to have a "I'm printing in grayscale option" in the properties that alters the behaviour of the code that picks colors?

I was able to manually set bar elements to different gray levels, but pie charts appear to only let you say "Automatic", in which case half of what it picks just shows up as white when run through my laser printer.

I refuse to touch Open Office's oocalc app. I've messed with it before and despise its UI much as I do that of OO's word processor. I also installed kchart (can't find a working website for that one) and couldn't handle (or understand) the UI. gnumeric feels very nice, but pie charts where half the elements come out white aren't very useful to me.

Comments

1
pcg writes:

Excel definitely handles it better (or has in the (distant?) past). Heck, even Lotus 1-2-3, on which I cut my teeth, handles that better. They employ fill patterns - left-to-right diagonal, right-to-left diagonal, crosshatch, solid 100%, solid 50%, dotted, etc. - to distinguish the different parts. This works great in grayscale.

# on Sep.14.2005 AT 03:40 PM
2
e; writes:

Hmmm... Perhaps older programs handle it better because, well, they had to. These new-fangled applications have never seen a day where most people didn't have color printers.

For the bar graphs I was making gnumeric did give the option of different fill patterns (that I had to choose manually... no setting to say "Differentiate via automatic patterns rather than colors"), but some of them came out really ugly. I ended up just using six different shades of grey, which actually worked out. The pie chart I just filled in partway with a pen. -e;

# on Sep.14.2005 AT 04:06 PM

Your Comment:

YOUR INFORMATION:
Name:
Email:
URL:
  • Comments should be on the topic of the post or they will be removed.
  • Use the live preview below to see how your comment will look before posting.
  • Keep it civil. If you're attacking people instead of arguments, or being overly profane, expect your comment to get deleted.

FORMATTING BASICS:

eWorld uses Markdown formatting.

_Italics_
__Bold__
<http://url.to.link>
[link text](http://url)

COMMENT:

Preview

Start typing...