The easy way:

Duplicate A2:A12 in A13:A23 and A24:A34. Copy E2:E12 to D13:D23 and F2:F12
to D24:D34 and make your chart from columns A and D.

Hard way:

Make the chart using A2:A12 and D2:D12. Go to Chart menu Source Data
Series. Select the series, change X values from

=Sheet1!$A$2:$A$12

to

=Sheet1!$A$2:$A$12,Sheet1!$A$2:$A$12,Sheet1!$A$2:$ A$12

and change Y values from

=Sheet1!$D$2:$D$12

to

=Sheet1!$D$2:$D$12,Sheet1!$E$2:$E$12,Sheet1!$F$2:$ F$12

and click OK.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Novice" wrote in message
...
Hi, I would like to create a single chart using multiple columns as one
series

error message states that title, values, sizes must be single cell, row or
column...

x axis A2:A12 y axis D2:F12 (legend name)

Thanking you in advance.