I am useless at Excel, PLEASE can someone do me a quick graph? - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

I am useless at Excel, PLEASE can someone do me a quick graph?

£0.00 @
I have some very simple information that I want to put in a line graph but it just ain't working right for me I would appreciate it SOOOO much if someone could knock it up quickly for me - I know… Read More
Mrs.Z Avatar
6y, 11m agoPosted 6 years, 11 months ago
I have some very simple information that I want to put in a line graph but it just ain't working right for me

I would appreciate it SOOOO much if someone could knock it up quickly for me - I know it must be quick if you know what you are doing LOL!
Mrs.Z Avatar
6y, 11m agoPosted 6 years, 11 months ago
Options

All Comments

(15) Jump to unreadPost a comment
Comments/page:
#1
Are you talking about one that you can print off before adding the info?
#2
This is my data:
pH Units of enzyme activity
0 0
4.5 3.1
5.5 9.6
6.5 14.5
7.5 10.1

I need the pH on the x/horizontal axis and the reaction on the y/vertical axis and I want it titled 'The affect of pH levels on the rate of enzyme reaction'

Thank yous x
1 Like #3
Highlight the information you want to be put into a graph and click the Graph symbol :)
#4
pH ----------Units of enzyme activity
0 ------------------0
4.5 ---------------3.1
5.5 ---------------9.6
6.5 ---------------14.5
7.5 ----------------10.1
#5
burstlikeabubble
Highlight the information you want to be put into a graph and click the Graph symbol :)


I keep doing that but i keep getting 2 lines instead and it won't start from the 0-point (BTW Parappa the rapper rule :))
1 Like #6
are you using excel 2003 0r 2007 ?
1 Like #7
if 2007,
go to insert
select line tab
2D graph
when the graph appears,
use the select data to choose what information goes on what axis

hth
1 Like #8
if 2003, right click on the graph and change chart options as required
1 Like #9
I see what you mean it plots 2 lines instead of the 1 that you need. Hmm...
1 Like #10
I can get it to work if you use an XY scatter graph and then click on the graphic icon which has the dots joined.
#11
babimama09
if 2007,
go to insert
select line tab
2D graph
when the graph appears,
use the select data to choose what information goes on what axis

hth


I keep doing that but each time I choose one, it plots for just one lot of info :(
#12
burstlikeabubble
I see what you mean it plots 2 lines instead of the 1 that you need. Hmm...

I know, I feel really silly because I am usually okay with computers but have wasted so much time on this :(
1 Like #13
Mrs.Z
I keep doing that but each time I choose one, it plots for just one lot of info :(

in select data tab,
remove series 1 and rename series 2 by selecting the named cell and for series values enter your pH values
For horizontal axis, select your enzyme activity data

You should now end up with one line and both axis correctly done
#14
babimama09
Mrs.Z
I keep doing that but each time I choose one, it plots for just one lot of info :(


in select data tab,
remove series 1 and rename series 2 by selecting the named cell and for series values enter your pH values
For horizontal axis, select your enzyme activity data

You should now end up with one line and both axis correctly done


Thanks, I have been trying that since you replied and still no joy :(
1 Like #15
I can email you the spreadsheet as mentioned in the PM if you like.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!