Chart legends question
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. |
Chart legends question
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. |
All times are GMT +1. The time now is 09:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com