Auto update in a graph which reads from a column which includes a small function

Hello guys,

I'm trying to create an auto updated graph in excel 2007.
The problem is that in the total range of the column the included function returns a result making the line of the graph horizontal.

Is there a way to overcome this difficulty ?

In the attached workbook you can find the example.

Thanks in advance for any help!

hi spiros63, welcome to ExcelFroum, as an option

Hello guys again,

Firstly I would like to thank you for the time & effort you put to answer on my problem.
Both the solution work under some annoying conditions.

Raoul's solution, work perfectly if you have a specific, standard and small period of time (lets say a month).
Because it returns the total range of time, it can't work dynamically (you must rearrange continuously the magnitute of time).

Watersev's solution is what I was looking for, but doesn't work in excel 2007.
The file that Watersev uploaded if would saved in excel 2007 works fine, but can't be reproduced.

Is there any idea how can I create what Watersev has created in excel 2003 in excel 2007 ?

The attached file has both the solutions for reference

the file uses two dynamic named ranges:

1) GraphDate - formula:

Please Login or Register  to view this content.

2) GraphRange - formula:

Please Login or Register  to view this content.

and formula from D4 and down:

Please Login or Register  to view this content.

Those ranges are used in chart plotting. There is nothing specific to Excel 2003 that would not work in Excel 2007

Dear Watersev,

You are officialy in my range of gods !!!
I did what you show me and it works perfectly.