This article will cover the steps required to create the chart.
In the table the blank cells are as important as the value cells in terms of getting the layout correct. You need to set out the data to create the layout you want to achieve in the chart. Rows 1 and 2 are helper cells that allow us to create the headings in row 3 in columns E to J.Įxcel doesn’t provide a lot of flexibility in moving the data on a chart. Since we are including three separate charts on one chart we need to separate those three parts to control their position. This appears different to most chart tables. This chart works because of the layout of the data. I have used colours to help identify which chart is related to which axis. 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.
