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.

What Are Effects of Choosing a Large Chart End Limit
 

Make a dynamic chart, which grows its source data range as data is added:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

SidBord wrote:

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.