I have three columns

column 1 is date,

column 2 has values I'd like to call gross

column 3 has values I'd liek to call net.

I charted column 2 and 3 on the Y axis against column 1 on the X-axis -
using the area style (net is always smaller than gross) but the legend
just says 'series 1' and 'series 2' for the two colors.

Is there a way for the legend to say 'gross' and 'net' ?

Thanks.

Click on the Chart to select it and then from the Chart menu click on Source
Data. Select the Series tab and click on series 1 in the series box on the
left. Type your label into the Name box.
--
Hope this helps,
MarkN


" wrote:

I have three columns

column 1 is date,

column 2 has values I'd like to call gross

column 3 has values I'd liek to call net.

I charted column 2 and 3 on the Y axis against column 1 on the X-axis -
using the area style (net is always smaller than gross) but the legend
just says 'series 1' and 'series 2' for the two colors.

Is there a way for the legend to say 'gross' and 'net' ?

Thanks.