Show Series Name


R

Rupster

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
 
Ad

Advertisements

T

trip_to_tokyo

“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.
 
T

trip_to_tokyo

Sorry, ignore my previous posting as I have now realized it was what you have
already done.

I have posted a chart to:-

http://www.pierrefondes.com/

Item number 48 towards the top of my home page.

This is pulled directly from MS documentation.

I hope that this might help you.

If it does please click Yes.

Thanks.
 
R

Rupster

The chart you show just has a legend. I do not want a legend as I have too
many series and the colours begin to repeat. want the series name on the
chart next to the series - perhaps by the first data point.
 
H

Hasan Dudu

Just select the data point at the end of each data series. Then go to "More Data Label Options" and select "Series Name" as described above. In that way, excel will only write the series name for the last data point in the series. You need to do this for each series. You can select any data point in the series to show the Series name anywhere on the series.
 
Ad

Advertisements

Joined
Feb 28, 2014
Messages
1
Reaction score
0
I have a similar problem.

Please see attached file or imgur.com/A28mP1t (sorry: New user, and hence not allowed to post URL or images :confused:) for details.

I want to create a scatter (X/Y-diagram).
The data label for each point should be the name in column A, while the coordinates should be {column B; column C}.

I hope the attached excel spreadsheet explains a little better.

Any ideas?

Thanks in advance

R
 

Attachments

  • DataLabels.zip
    22 bytes · Views: 301
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top