[FONT=Verdana, Arial, Helvetica]Hi
I have a several graphs each showing 24 series of data. As the colours begin to repeat themselves it is difficult to tell which series is which. I would like to have the series name on the chart itself - perhaps by the first data point. I have tried adding text boxes but this is tedious and if the data changes the text boxes do not move with the data i.e. they are static. I am using Excel 2007. The option to show series name with the 'more data labels option' is not helpful as it adds series name to each data point and this clutters the chart. Is there a simple method to show series name next to each series so that the text is linked to the data?
Thank you
Rup
[/FONT]
I have a several graphs each showing 24 series of data. As the colours begin to repeat themselves it is difficult to tell which series is which. I would like to have the series name on the chart itself - perhaps by the first data point. I have tried adding text boxes but this is tedious and if the data changes the text boxes do not move with the data i.e. they are static. I am using Excel 2007. The option to show series name with the 'more data labels option' is not helpful as it adds series name to each data point and this clutters the chart. Is there a simple method to show series name next to each series so that the text is linked to the data?
Thank you
Rup
[/FONT]
