I am trying to create a line chart with multiple column values displayed on the same line.

For example:

Column A has date. Columns B, C and D have three values for that date.

What I want is a single line chart with column A as the X-axis, and the three values from B, C and D shown consecutively on the same line – I do not want three separate lines.

So the line of the chart would be showing : date1colB, date1colC, date1colD, date2colB, date2colbC, date 3colD, date3colB, date3colC, date3colD etc. etc.

Any help would be much appreciated !