Multiple Lines/Series in One Graph

Hi,

I want to create a graph which contains multiple lines (each line represents 200 untill 204) from the data below.
The dates are as the horizontal axis and the values in column 3 are the vertical axis.

I have tried to create the graph but I only get the first line (which represents 200) in it and I don't know how to add the other ones.

13-3-2012 200 4046
13-3-2012 201 8
13-3-2012 202 3701
13-3-2012 203 16
13-3-2012 204 60
14-3-2012 200 5000
14-3-2012 201 20
14-3-2012 202 3000
14-3-2012 203 20
14-3-2012 204 55

Could you please help me?


Thanks and best regards,
Adi

test.xlsHi
note sure what you want here - do any of these three fit what you're after?

Hi,
May be a variant with pivot table and pivot chart if you have a lot of data
Transform your data in table
Insert a pivot chart and format vertical axis to logarithmic base 10 as proposed by Andy Pope
Refresh pivot table when adding or inserting data in your table
Hope this helps
Best regards