I did a line and clustered column chart to show sales from 2011 to 2016. But I need to know how to show all sales of the current year and the previous years (2011-2015). The problem is that I don’t have the intact sales of 2016, so I want to compare sales YTD of 2016 and sales YTD of 2015 comparing 2016 in the same chart.
Someone suggested to use forecasting, but I’m ruling it out in this case. Anyone here have another suggestion?
Thanks in advance!