I'm looking to plot the revenue of 3 annual conferences on 1 excel chart/graph (2016,2017 and 2018). I have the date of registration and the price paid.
y axis - total revenue
x axis - days to conference
I wish to compare the performance of each year against each other.
To make this work on one X-axis it might be best to have conference date as "x" and work backwards x-1, x-2, x-3.