limited date range on X axis with Y axis scaled to that period
Hi,
I am currently using a line chart to display some data, ranging from 2018 to now. Preferably, what I want is to view the most recent period of time (possibly predefined) on the X axis and have the Y axis automatically scale to the data range in that period of time. Currently, I can choose to use or not use the continuous scale on the X axis:
- If I dont use the continuous scale on the X axis, I get a data overview of the last 22 weeks. This is fine, but the Y axis still scales to all the data (also previous to the displayed data range). So the Y scale is off in this option.
- If I do use the continuous scale on the X axis, the scaling is correct but I see all the data over the entire time range, and which I cannot seem to define anywhere.
Is there anyone that knows how I can get a short time range on the X axis with a Y range scaled to the data in this period?
