Hi,

I need to figure out some VBA code that will allow me to put an end date in cell H38, and have the chart graph to that end date.

C8 to BV8 is my date range (Jan 13 to Dec 18) - In this range I use end of month dates, so 12/31/16 is in cell AX8

C9 to BV11 is my data range.

In cell H38 I have the value 12/31/16. I want to be able to change this value to anything, ie 10/31/15 and then have the chart adjust.

Please let me know if you need anymore info!


Thanks for all the help!