November 12th, 2013, 1:45 pm
QuoteOriginally posted by: edouardIs there a straight way to dynamically change chart legends?Say may data are in A2:A20.I want the legend to read "My data Sum is [sum]"I made several attempts such as: ="My data Sum is "&sum(A2:A20).I searched a bit on the internet, but the solutions proposed rely on a cell containing (in my case) the sum of the data.I'm not sure what I'm writing is clear. Please, tell me.Click on your title and write "="link cell adress""For exemple, you can write "=sheet1!$a$1" and on the cell a1 you can write what you want to see on your title.
Last edited by cemil on November 11th, 2013, 11:00 pm, edited 1 time in total.