how do i change chart legend entry in Excel?

B

basmail

Now it says "series 1" or similar and I can't figure out how to change it to
the description that exists in a particular cell.
 
J

John Mansfield

Click once on the chart (activate it). The standard toolbar should show an
option called "Chart". Click on "Chart" -> "Source Data". In the "Source
Data" dialog box go to the "Series" tab. You can reference the cell that you
want for the legend description via the "Name" input area. Or, you can type
the name into that area to manually input it.
 

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

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Change symbols in a Network Diagram legend. 0
How do I find the series associated with a given legend entry. 4
chart legend changing when I use Select data 1
changing the name in the legend 2
Interval in legends in surface charts 8
Dynamic chart legends 1
I can get line chart to ignore zeros but the legend still contains 3

Top