PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting last n positions

Reply

last n positions

 
Thread Tools Rate Thread
Old 20-11-2003, 06:32 PM   #1
Mike Harris
Guest
 
Posts: n/a
Default last n positions


i have an ever growing column - earliest at top, growing on bottom -
how can i pick off the "last" n positions to chart

thanks

mike
  Reply With Quote
Old 20-11-2003, 08:39 PM   #2
Debra Dalgleish
Guest
 
Posts: n/a
Default Re: last n positions

On his web site, Tushar Mehta has instructions for creating dynamic
charts, including one for graphing the last x entries in a data series:

http://www.tushar-mehta.com/

Mike Harris wrote:
> i have an ever growing column - earliest at top, growing on bottom -
> how can i pick off the "last" n positions to chart


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  Reply With Quote
Old 22-11-2003, 04:54 AM   #3
Mike Harris
Guest
 
Posts: n/a
Default Re: last n positions

Thanks a lot for the help!

Mike

Debra Dalgleish <dsd@contexturesXSPAM.com> wrote in message news:<3FBD2696.4090602@contexturesXSPAM.com>...
> On his web site, Tushar Mehta has instructions for creating dynamic
> charts, including one for graphing the last x entries in a data series:
>
> http://www.tushar-mehta.com/
>
> Mike Harris wrote:
> > i have an ever growing column - earliest at top, growing on bottom -
> > how can i pick off the "last" n positions to chart

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off