I have a data set with a rolling 12 months of data. Current data set has data from Mar 2022 to Feb 2023.
When I try to plot this using the Stacked Area chart the X axis always starts with Jan. So I get Jan 2023, Feb 2023, Mar 2022, April 2022 etc.
Obviously this isn’t so useful for visualising trend information. How do I make the chart start at Mar 2022 and run through until Feb 2023?
In the dataset I have one data point per month per dimension. Each data point has a date of the last day of the relevant month. The dataset is super simple: