Graph between two dates
 

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.

Graph between two dates
 

Mnilo,

Actualy yes, I´ve been there...

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

rgd
Mika

Graph between two dates
 

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.

Graph between two dates
 

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.

Graph between two dates
 

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.