I need a bar chart that displays last year's quarterly sales dollars and I need this year's quarterly sales dollars next to last years. Then I need a line graph on top of this that takes the previous years (quarterly) sales dollars, add 10% to that amount, and display it 1 year in advanced (so Q1 2016 + 10% displayed over Q1 2017) . I would also like for the line graph to "push" 3 months in advanced.
Is this possible?
I have included an image of what I want. This is fake but should help in understanding.