I have a chart tracking weekly status; I was wondering how I can have the chart automatically default on the latest date without having to scroll to the right to see the latest status? I realize I can set the number of weeks that appear on the chart, but I was wondering if there was any other way to accomplish this while keeping all the data  Example below... Thank you.
Yes, I suggested that... the people I made the chart for don't want it to display that way though (unfortunately); they'd like to have the date display (ascending), but they always want the latest date(s) to display on the right of the chart. Thank you for your suggestion.