Stucked in creating dinamic chart. Excel2007

Hello!

Please help me!

I have area from L2 to N273 that contains info`s from another area and records will still be added further.

Records entered in the table from L2 to N273 are bringed with this formula:

=IFERROR(INDEX($C$2:$E$273,$H2,COLUMNS($L$2:L2)),"")

In column M and N is the same thing, only changed is L to M or N.

So:

L column contains date(ex: 12-Mar-2012)

M= Recorded info 1(ex: 3.5%)

N=Record info 2(ex: 1.2%)

I created a dropdown list that does next: when a option(Year 2012/Year 2013/Year 2014/….) is selected the table change his containing info. So, there are blank cells in L2:N273 area

Now I want to create a chart to change automatically with this table from L2 to N273, but not to show me blank spaces on the chart. For example when I select year 2012(where I have only 7 records L2:N8) the chart is showing a lot of unused space(from L8 to N273). When I select year 2013(where I have 100 records L2:N102) the graph is rescaling but there is still a lot of unused space(from L103 to N273).

As far as I can tell the chart is displaying the full period from 09-Dec-2012 to 10-Feb-2016(L column) but I want it to be active only on selected period from the list.

Thanks!