How do you replace the 'Average' text with the actual average number on a 'Reference Line'
I have a line chart spanning across a year's worth of data with these default values. When I click on Edit Reference Line, I see this. now, I believe I need to change 'Label' to 'Custom'. But what formula do I use to replace 'Average' with 'Average: <Average>'
4 answers