Thread: Dynamic Charts Partial Range of Dates?

I am trying to build a dynamic chart but am stuck on how to get it to properly display a partial range of dates.

Worksheet name: WEATHER
Column headings:
B89 - DATE
C89 - This Year
D89 - Last Year

B90:B453 dates
C90:C453 Temps this year
D90:D453 Temps last year

User enters a starting date in P1
User enters an ending date in P2

For only the range of dates entered I need my line graph to show the dates on the x-axis and the corresponding TY and LY temps on the Y-axis.

I tried following the examples detailed in #3 at http://www.tushar-mehta.com/excel/ne...l#PartialRange but my chart would not repopulate with the ending date, maybe because my chart has two Y-axis series? So it seems I close but not quite there.

Any assistance is appreciated.