Help please with simple chart

J

jimsunz

I used to Excel, but am a newbie with charts. Am using Excel version
5.0a
In connection with a Process, I am recording liquid levels in mls at
various times during the day.
As a spreadsheet sample, column A, day. column b, time. column c
quantity in mls.

a1 Day b1 Time c1 mls
a2 Mon b2 8:00 c2 225
b3 10:30 c3 100
b4 11:45 c4 100
b5 13:30 c5 120
b6 16:30 c6 200
a7 Tues etc etc

Using Chart Wizard I have managed to create the bar chart, but I am
stumped on how to get it to show the results.
On the vertical left hand side I want mls in vertical bars, and along
the bottom the day/time for each sample. (I can never remember which
is X and Y )
Generally between 5 to 10 samples per day, and would like to record at
least a weeks worth of data. I am happy to change the spreadsheet
layout to suit.
Very many thanks for your help.
Jim.
 
J

JulieD

Hi Jim

not sure what Excel version 5.0a is .. .so i hope this will work for you:

with your current layout copy Mon down in cells A3 to A6 do the same for Tue
etc
so you now have
Day Time Mls
Mon 8:00 225
Mon 10:30 100

etc

now select from A1 to the end of your data (A1:C26 according to my
reckoning) ... and then press the F11 key - this should autogenerate a chart
(assuming this feature works in excel 5.0a) which will give you what i think
you're after.

Let me know how you go
Cheers
JulieD
 
J

jimsunz

JulieD said:
Hi Jim

not sure what Excel version 5.0a is .. .so i hope this will work for you:

with your current layout copy Mon down in cells A3 to A6 do the same for Tue
etc
so you now have
Day Time Mls
Mon 8:00 225
Mon 10:30 100

etc

now select from A1 to the end of your data (A1:C26 according to my
reckoning) ... and then press the F11 key - this should autogenerate a chart
(assuming this feature works in excel 5.0a) which will give you what i think
you're after.
Click to expand...
Well done and grateful thanks - it works - here's a lovely relaxing
back massage for you, or perhaps a massage to those helpful busy hands
of yours. Regards Jim.
 
J

JulieD

Hi Jim

glad it worked, i'ld kill for a back massage just at the moment .. today has
been a touch on the "stressful" side :)

Cheers
JulieD
 
Top