Can you input multiple series names and values with a single definedname ?

In Excel 2007, is it possible to create a dynamic chart with defined
names without having to enter each individual series ?

For example, the Horizontal (Category) Axis Labels can be input with a
single defined name.

A defined name could be used to specify B11.

However, it appears that if you want to enter in the Legend Entries
(Series), you have to do them one at a time.

Series Name = A2 and Series values = B22 (this part could be a
defined name).

Is there an easier way to enter multiple series at once ?

A B C D
1 May 1 May 2 May 3
2 Apple 1 3 6
3 Orange 2 6 18
4 Peach 3 9 27




Exceluser