Show Series Name
€œI would just like to have, on the chart next to each series something
showing the series name.€
In EXCEL 2007 for the above take the following actions:-
Click the series on the Chart itself. This will highlight the series.
CharTools / Layout / Data Labels / More Data Label Options / Label Options
at the top on the left hand side should be highlighted in orange / on the
right hand side, under Label Contains, place a tick in the Series Name box
and make sure that there are no ticks in the Category Name or Value boxes /
Close
Your chart will now have the Series Names placed onto the chart itself.
If my comments have helped please hit Yes.
Thanks.
"Rupster" wrote:
Hi
I have a line graph showing 24 months of data. As the colours begin to
repeat themselves it is difficult to tell which series is which. I would just
like to have, on the chart next to each series something showing the series
name. I am using Excel 2007 and the option to show series on the more data
labels option shows series name on every data point. given that I have over
30 data points and 24 series the chart looks messy. is there a simple waty to
show series name next to each line/
Thankyou
Rup
|