Below there is a correspondence between Jon and myself as I couldn't show
exactely what I need. Jon helped anyway and here are his answers so others
can possibly benefit it future (I hope you don't mind Jon:))):

Piotr -

You have defined Period_Invoiced as

=OFFSET(table!$H$9,0,0,COUNTA(table!$H$9:$H$17),1)

What if you define it as

=OFFSET(table!$H$9,0,0,COUNTA(table!$H$9:$H$20),1)

This will enable the range to include the last three months.

- Jon


Hi Jon,

Thank you for this hint. I have amended the range to row 20
and hey presto!! it works:) However, what I don't like or
rather my boss are these 2 empty months visible on the chart
(Nov and Dec) after I added Oct. Is there anyway to get away
with it? If I could hide those months without the data that
would be fantastic. Though, I need this chart to look as it
looked before the amendment in a form you originally
received. Let's say some slide bar or something ( I have seen
some examples but I will lose my secondary axis I am affraid).

What could you suggest?

Kind regards,

Piotr



Yes, my first suggestion counts any cell with any content, including a
formula that returns "". This should do it finally:

=OFFSET(table!$H$9,0,0,SUM(IF(LEN(table!H9:H20)0, 1,0)),1)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______