i have a sheet with dates in column A and various bits of data in columns
B-F. I want to chart it but have the chart also go down to the last row
entered. I could make a little db for it but don't want to (easier to copy
data within the sheet). how do I describe the last row of the chart so that
it always goes to the last row that's filled in?

If you're using Excel 2003, you can define a List using the table. As the
data expands or contracts, the list also changes, and any formulas or charts
based on the defined list will change to accommodate the entire list.

Otherwise you could define dynamic ranges and make a dynamic chart:

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

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


"Ian" wrote in message
...
i have a sheet with dates in column A and various bits of data in columns
B-F. I want to chart it but have the chart also go down to the last row
entered. I could make a little db for it but don't want to (easier to
copy
data within the sheet). how do I describe the last row of the chart so
that
it always goes to the last row that's filled in?

can I put the counta function right into the source data dialog box without
defining the list? e.g. something like Values:
=sheet1!$B$2:$b$(counta($a$2:$a$60000))?


"Jon Peltier" wrote:

If you're using Excel 2003, you can define a List using the table. As the
data expands or contracts, the list also changes, and any formulas or charts
based on the defined list will change to accommodate the entire list.

Otherwise you could define dynamic ranges and make a dynamic chart:

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

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


"Ian" wrote in message
...
i have a sheet with dates in column A and various bits of data in columns
B-F. I want to chart it but have the chart also go down to the last row
entered. I could make a little db for it but don't want to (easier to
copy
data within the sheet). how do I describe the last row of the chart so
that
it always goes to the last row that's filled in?

No, you have to define a dynamic range, and reference this range in the
source data dialog. A chart's source data can only contain a formula which
is a link, not a formula which does any calculations.

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


"Ian" wrote in message
...
can I put the counta function right into the source data dialog box
without
defining the list? e.g. something like Values:
=sheet1!$B$2:$b$(counta($a$2:$a$60000))?


"Jon Peltier" wrote:

If you're using Excel 2003, you can define a List using the table. As the
data expands or contracts, the list also changes, and any formulas or
charts
based on the defined list will change to accommodate the entire list.

Otherwise you could define dynamic ranges and make a dynamic chart:

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

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


"Ian" wrote in message
...
i have a sheet with dates in column A and various bits of data in
columns
B-F. I want to chart it but have the chart also go down to the last
row
entered. I could make a little db for it but don't want to (easier to
copy
data within the sheet). how do I describe the last row of the chart so
that
it always goes to the last row that's filled in?