I have a chart where the dimension is day and the expression is total sales. The Max number visible is 30 so if the user wants to see the most recent days, they have to scroll all the way over to the right. The users don't like this - when they go to the page where the chart is, they want the chart to be already scrolled so they can see the most recent sales on the right. I could make the days descending so the most recent days are on the left but the users don't want this. They want the days to read from left to right ascending, they just don't want to scroll. Is there a way to do this? I looked at triggers, but I don't see anything that works.
Consider having a 10 or 15 day view chart on a seperate sheet with the latest 10 or 15 days of data so the latest day is always displayed on the right.
