Excel line graph

  The Teacher 09:22 22 Feb 2008

I want to be able to show the results of an experiment as a line graph in Excel.

I can do it on paper but as I have an interactive whiteboard I want to be able to show the class what they should have without actually wasting paper.

When I use the chart wizard in Excel I can only get charts showing two lines, and this is not what I want.

I want the mass of CaCO3 on the x axis and the mass of CAO on the y axis, with only one line.

Mass of CACO3 Mass of CAO

5 3
10 5.5
15 8.5
20 13.5
25 14

Can anyone help please.


The Teacher

  MAJ 09:53 22 Feb 2008

Try this:

5 10 15 20 25
mass of CaO 3 5.5 8.5 13.5 14

The formatting of the forum doesn't allow it to paste properly, but you get the idea.

  MAJ 09:57 22 Feb 2008

This looks better.

mass of CaO
5 3
10 5.5
15 8.5
20 13.5
25 14

  MAJ 09:58 22 Feb 2008

Just leave the first column's heading blank.

  MAJ 10:01 22 Feb 2008

like this. click here

  VoG II 10:56 22 Feb 2008

Select both columns of data. Click the Chart Wizard button, select Scatter chart, Select the sub-type with points and lines.

Voila click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?