Excel 2007 : Create Multiple line charts from one table

Hello.

Is it possible to create multiple line charts from one table ? With vba, of course

I have a table with data for X axis in first row (1). In every next row is the data for the chart (there are 56 of them).
In the "A" column are names that will be in the chart legend (below the chart).
It goes something like this:

A B C D....
1 day 1 day 2 day 3 ...
2 NY 54 32 21......
3 LA 77 88 99 .....
4 SA 13 45 86 ....
.
.
Regards, eriol

Hi eriol,
You could use the PivotChart wizard to create the charts.