The Line chart shows the total monthly sales budget, also measured on the right-hand vertical axis. These are measured against the right-hand vertical axis. The remaining six Stacked Column charts measure the monthly actual and forecast sales. Related: Use this spreadsheet to practice these techniques These are measured on the left-hand vertical axis.
The first three Stacked Column charts measure the last full financial year (FY15) the approved budget and the current full-year forecast. We are charting Sales data that is split between three revenue types: Contract, Non-Contract and Other.
