Hi,

I currently have this data set as an example:

12-3-2011 200 29271
12-3-2011 201 29601
12-3-2011 202 1206149
12-3-2011 203 16149


this data goes on until today's date (1st column), the second column repeats from 200 until 203
the question is, how can I create an excel Chart where 12-3-2011 is in the vertical axis and the 3rd column is the horizontal axis and the 2nd column are displayed as different lines (each one a different color).
until now I only succeed in creating 1 line. I don't know how to add 201 until 203 into the chart.

Thanks for your help,
Adi