Includeing Data as Part of a Legend

**dnamertz** · 10-14-2011, 10:30 AM

I have a line graph, and one of the lines is a straight line that represents the average. In the Legend I want to include the amount of that average as part of the line's description. For example, in the legend I want it to say "Average 75%" and then the next week if the percentage changes to 77% I want the legend to say "Average 77%". How do I get data that is constantly changing to be part of a legend name?

I could put the percentage amount on the line in the graph, but it often overlaps with other data if I do that.

**Andy Pope** · 10-14-2011, 10:34 AM

Does the legend currently get its text from a cell? If so use a formula in that cell to build the text and average value, something like this.

="My Line Series Average is " & TEXT(AVERAGE(B2:B10),"0")

If the legend text is static use the Source Data dialog to link series name to a cell.

**dnamertz** · 10-15-2011, 07:39 PM

Originally Posted by Andy Pope

Does the legend currently get its text from a cell? If so use a formula in that cell to build the text and average value, something like this.

="My Line Series Average is " & TEXT(AVERAGE(B2:B10),"0")

If the legend text is static use the Source Data dialog to link series name to a cell.

The text can come from a cell, but the percentage is always changing. I tried the following formula:

="Average " & TEXT(AVERAGE(I41),"0")

where the vaule in cell i41 is 74.5%, but the result is "Average 1" It's rounding the percentage into a whole number. If it wasn't for that, this would give me what I need.