I'm making graphs.
Specifically, peak flow graphs.

It seems to be alright for that, but I need to get my head around them. Is there a way to make it include zeros where there isn't any data?
( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:28, 1 reply, 12 years ago)

If(E5='',"0",E5)
will replace any blanks with a zero, if you're looking at cell E5 obviously.
just copy that down in a new column
(PsychoChomp, Thu 2 Aug 2012, 11:29, Reply)

Aren't you missing a " in that equation?

( Ken Oath, Thu 2 Aug 2012, 11:32, Reply)

single pip for the first bit double for the second... not sure why but it works.

(PsychoChomp, Thu 2 Aug 2012, 11:34, Reply)

Oh, there you go...jolly good!
...never knew that. Also works with double "pips" too.

I like Excel....useful for working out 7 parameter transformations to convert raw GPS data to Transverse Mercator Map Grid co-ordinates.

Also like wood, not metal.
( Ken Oath, Thu 2 Aug 2012, 11:38, Reply)

So, a racist ruiner AND a dullard, eh?
Good Lord Oathsy, you just get better and better.
( Monty Boyce, My cheese game is strong, Thu 2 Aug 2012, 11:42, Reply)

May open-minded bisexual supermodels play in your dreams.

( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:33, Reply)