Since it is getting to be that time of comparing budget to actual and doing forecasting for 2009, I thought I would show you a couple of different ways to create some charts.
This one is called a Side by Side Comparison and is simple to create. The trick is in setting up your data.
In this example, Column A is the months. Column B is the whole year budget by month and Column C is the actual by month. Notice that the Column C data does not begin until row 15 (This was so that I could have a space on the chart between the two series). Once your data is set up like this, just select it all and create a chart as you normally would.
If you don't think the the column chart showed the trend differences very well, consider a line chart. Below is an example, using the same data.
Tomorrow, I will talk about combination charts.