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.
Bookmarks