I have a dynamic set of data that is filtered in from a table, with different arrays of data assigned to potentially overlapping dates, shown here Data Input from Filter Formula (the dates and data are both filtered in from another sheet as rows). I would like to display these in a single line chart as shown here Chart Ideal Output without having to manually paste the data into a single chart. The ranges for dates dynamically update (i.e. they can be different lengths). I have tried to superimpose the dates across, but each row is from a unique filter match I haven’t been able to find a solution.
Ideally I was trying to layout something like Overlayed Data and Dates as this allows me to plot it as a single graph, however I have not been able to find a solution to overlay the dates. Once the dates are overlayed I can just use an index match function to align the data to their respective dates accordingly.
Is there a more elegant method to do this automatically/ is there a VBA/formula solution to this?
Thanks in advance
