adding data to chart

I

Ian

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?
 
J

Jon Peltier

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
 
I

Ian

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))?
 
J

Jon Peltier

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
 
Top