Excel Graphing: How to Edit Legend Text?

In My Humble Opinion
1

Yup, that’s the size of it. How can I edit the text labels in the legend? FYI: I have two sets of “Y” values graphed against one set of “X” values on a scatter graph with the dots connected. I need to label each set of “Y” values so it is clear what is what.

Please give me a crash course as Excel is changed so much. Thanks!

2

Just change the text labels? You can right click on the graph, click Select Data, click Edit, change it there, then OK, then click the second Series and do the same.

I think that is basically similar to 2003 and before?

3

Assume you want to graph the populations of two kinds of bugs over yearly measurements. You have your data laid out like this, starting at A11:



       A      B     C     ...
...
11    Year  Ants  Bees
12    1994   200   250
13    1995   210   390
14    1996   220   370
15    1997   302   370
...

(It’s more convenient to have your data labels just above the data columns.)

You insert your line chart from the Insert section of the Ribbon. Your chart appears as just a blank rectangle. Then you right-click on it and choose Select Data.

You highlight from B11 to C15 (so just the two population columns, titles included). This will appear on the left side of the “Select Data Source” box, under “Legend Entries (Series)”. Your chart will already have a legend showing which line is for ants and which line is for bees.

Then you need to label the X axis. On the right side of the “Select Data Source” dialog box, under “Horizontal (Category) Axis Labels”, click on Edit. Highlight from A12 to A15 and click OK. The years will appear along the X axis.