The process of creating this combination chart involves a few steps during which the chart
looks completely wrong. You need to overlook the chart in those steps and keep progress-
ing through the steps, as follows:
1. Set up your data with months in column A, old-store sales for this year in column B,
new-store sales for this year in column C, and last year’s sales in column D.
2. Select cells A1:D13 and create a stacked column chart. Initially, Excel stacks prior-year
sales on top of the other sales, and you have a chart that is not remotely close to the
expected outcome.
3. Click the top bar to select the third series. Choose Design, Change Chart ...