Need help w/ macro creating a chart

[web1000]

Folks,

I have a macro which a programmer wrote but I have to make some
changes...

essentially there is time data in column A and temperature data in
column B. The macro opens a box and queries start data and end data
and then determines min and max temp and such.

Now I need the macro to also creat a chart for that range. I have the
start and end date isolated in fields but dont know how the macro could
select the data in between for the chart...

I am not a programmer and havent figured out the R1C1 adress system ...
I havent figured out if it can address through variables, which may
solve the problem

any help appreciated!

Matt

 

[Matt]

anybody? Is it even possible?

I have the cells for the applicable date range copied into a new column
which only containes data that needs to be charted but the amount of
data, start and end is different each time so the macro needs/vba
needs to pick the first and last cell with data and then build a chart
from it.

Is that possible?

Thanks,

Matt

 

[JE McGimpsey]

You may want to use a named dynamic range instead.

Check out

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

 

[Matt]

thanks, they are interesting .. but they seem to only work if your
first cell is fixed and only tha last varies .. I have first and last
varying