E
exceluser
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
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