View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Zukoski Zukoski is offline
external usenet poster
 
Posts: 1
Default How do I display latest value in chart in the legend w formula?

I want the latest value in my chart to be in the legend. Currently, I have to
manually update it each month in the "Name" section of the series.Can I type
in a formula to display the latest value from the sheet?