View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SidBord SidBord is offline
external usenet poster
 
Posts: 49
Default What Are Effects of Choosing a Large Chart End Limit

In Excel 2003, suppose I have a chart "Series" formula like:

=Series(,ShtNm!$A$1:$A$300,ShtNm!$B$1:$B$300,1)

Suppose that there are dates in column A which are going to
increase forever (stock mkt data). Also assume, that as of
today, the last date posted is in row 50. After 250 more
stock mkt days, I will have to increase the upper limit in
my Series formula from 300 to something like 600.

Question, what is the down side of choosiing a REALLY large
limit of, say, 5000 for the upper limit, even though there
is currently no data in rows beyond row 50? Will it use
considerably more memory? Will it take more time to draw
the chart? I've wondered about this for years.