Multiple column values on single line chart

[Loneswimmer]

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 !

[Andy Pope]

You would need to alter the layout of the data so all the information is in a single column.
You would also need to ensure the x axis treated the dates as Text Categories rather than Date/Time series