Hi
I have a layout of three columns like this: (Column A is the date and time, and the subsequent values in B and C apply to that day.
18.01.2013 13:32:55269 one323 two125 three811 four359 five778 six18.01.2013 13:38:00
289 one280 two108 three821 four296 five740 six18.01.2013 13:43:06
284 one302 two125 three810 four244 five770 sixThis continues for 1940 rows. I want to creat a chart with time on the x-axis (Column A), Column B on the Y-axis, and six lines on a line chart, one, two, three, four, five and six.
I'm really struggling to work out how to do it. I've tried transposing into columns but I'm limited by 255 columns in excel 2002.
Any pointers would be appreciated.
Bookmarks