Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 09, 02:59 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
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?

  #2   Report Post  
Old April 27th 09, 05:45 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default How do I display latest value in chart in the legend w formula?

The formula has to go into the worksheet. If the data is contiguous (no
blanks) and starts in B2 and may extend downward an indeterminate number of
rows, put this formula into B1:

=OFFSET(B1,COUNTA(B2:B10000))

Then use cell B1 as the name of the series.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Zukoski" wrote in message
...
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I would like to display the % of a pie chart on the legend erock Charts and Charting in Excel 1 September 11th 08 07:23 PM
Display every 3rd category name but still display latest month maryj Charts and Charting in Excel 1 September 24th 06 09:05 PM
Display latest arrival date Annabelle Excel Discussion (Misc queries) 3 February 21st 06 01:34 PM
Display latest date in a column khuggart Excel Worksheet Functions 4 July 13th 05 10:36 PM
Stack Chart Legend Display John Charts and Charting in Excel 1 May 15th 05 03:44 AM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017