MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to add a Series Name to Chart?


Posted by Naeblis on July 03, 2001 12:21 AM

I have a chart with about 50 or so series on it. Each series has a name referencing a cell. The problem is after a while the colors repeat and it is hard to tell which series is which. Is there a way to make the series name appear on the chart next to each line, instead of using a legend?

Thanks...


Posted by Landragoran on July 03, 2001 6:55 AM

I only answered this 'cause I liked your name...

Right-click on the series itself and select "Format Data Series", then click the "Data Labels" tab, and choose the "Show Value" option.

My real name is Cory (You'll see me all over this thing), but I can appreciate a name like Nae'blis considering my screenname is what I posted here...

Help any?
Cory
Landragoran76