Hi all:

I have a database about the Stock Market, three columns basically: Date,
Price and Volume.

What I´d like to do is that when I introduce in the spreadsheet the initial
date and the final date I want to see in a graph, this graph will update
automatically and will show only the data between the two dates I wrote.

Any ideas about how to achive that?

Thanks in advance.

Mnilo,

Actualy yes, I´ve been there...

see he
http://pubs.logicalexpressions.com/P...cle.asp?ID=246

rgd
Mika

Use a defined name such as this (dateseries) to match the dates in column A
ONE line in the refers to box

=OFFSET(Sheet24!$A$5,MATCH(Sheet24!$B$4,Sheet24!$A :$A)-5,0,MATCH(Sheet24!$B$5,Sheet24!$A:$A)-MATCH(Sheet24!$B$4,Sheet24!$A:$A)+1,1)

then use that defined name in your series. =worksheetname!dateseries
Now when you change b4 as your start date and b5 as your end date your chart
will auto create

--
Don Guillett
SalesAid Software

"Mnilo" wrote in message
...
Hi all:

I have a database about the Stock Market, three columns basically: Date,
Price and Volume.

What I´d like to do is that when I introduce in the spreadsheet the
initial date and the final date I want to see in a graph, this graph will
update automatically and will show only the data between the two dates I
wrote.

Any ideas about how to achive that?

Thanks in advance.

OOPS
I meant to say
=workBOOKname!dateseries

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Use a defined name such as this (dateseries) to match the dates in column
A ONE line in the refers to box

=OFFSET(Sheet24!$A$5,MATCH(Sheet24!$B$4,Sheet24!$A :$A)-5,0,MATCH(Sheet24!$B$5,Sheet24!$A:$A)-MATCH(Sheet24!$B$4,Sheet24!$A:$A)+1,1)

then use that defined name in your series. =worksheetname!dateseries
Now when you change b4 as your start date and b5 as your end date your
chart will auto create

--
Don Guillett
SalesAid Software

"Mnilo" wrote in message
...
Hi all:

I have a database about the Stock Market, three columns basically: Date,
Price and Volume.

What I´d like to do is that when I introduce in the spreadsheet the
initial date and the final date I want to see in a graph, this graph will
update automatically and will show only the data between the two dates I
wrote.

Any ideas about how to achive that?

Thanks in advance.

Thanks both for your answers, It really works at last.


"Mnilo" escribió en el mensaje
...
Hi all:

I have a database about the Stock Market, three columns basically: Date,
Price and Volume.

What I´d like to do is that when I introduce in the spreadsheet the
initial date and the final date I want to see in a graph, this graph will
update automatically and will show only the data between the two dates I
wrote.

Any ideas about how to achive that?

Thanks in advance.