Dynamic range based on entry in D21 that limits the number of days (Rows) to display.
Chart populates extra dates on front and back and weekend/holiday dates which are not part of the values presented in A3:A17.
I've tried UDF, Named Ranges, Direct and indirect Cell References with no success. Also tried to change the Type to Text but not available in Excel 2016 that I can find.
Axis Boundaries Min/Max only take values or auto and no formula, cell reference or named reference are accepted.
In the attached I'm commented out the UDF lines and the two cell references in F18 and F19. None of them worked in the desired manner and are included to demonstrate how far I've taken this.
Sheet is presently loaded with just one set of values from column B, and the reference date range in A but still populates extraneous/unlisted date values.
Goal is to reduce the clutter and just present the contents (dates and percentages) from the cells in the sheet each time D21 is changed.
Bookmarks