LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 10
Default Dynamic Charts

Can anyone explain the following formula to me:

=Data!$A$5:INDEX(Data!$A:$A,MATCH(9.99999E+307,Dat a!$A:$A))

I am setting up a dynamic chart and found help on a website, I have used the
formula (displayed below) as a dynamic range formula for AllDates that
expands when more data is added to the column. The insructions stated that in
the Define Names dialog box, type AllDates in the Name Box, and enter this
formula in the Refers To box:

=Data!$A$5:INDEX(Data!$A:$A,MATCH(9.99999E+307,Dat a!$A:$A))

The formula does work but I don't understand it, can anyone explain the
formula to me?
--
Many Thanks
Cath
 
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
Dynamic Charts Clark Charts and Charting in Excel 0 August 24th 07 09:16 PM
Dynamic Charts bjw Charts and Charting in Excel 3 July 27th 06 07:15 PM
Make dynamic charts more dynamic Milo Charts and Charting in Excel 1 April 12th 06 09:01 AM
dynamic charts Kirk Charts and Charting in Excel 2 March 10th 06 09:32 PM
Dynamic Charts vrk1 Charts and Charting in Excel 4 September 1st 05 03:16 PM


All times are GMT +1. The time now is 10:03 AM.

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

About Us

"It's about Microsoft Excel"