I have created a graph with a dynamic X-axis. Basically to see to see how much sales we obtain x days in advance until a random date.
The X-axis adaptation works perfectly. I am using a =INDEX():INDEX() formula to find the dates I am looking for and create a range for the graph to use. Unfortunately, when I change my x axis, the data itself does not change along with it.
Due to confidentiality I am a bit bound by what I can share but I added two pictures that show my issue.
Key is to not that the graph uses 4 data sources all based on the same date range!