Caution: In Excel 2007, if your data includes dates as labels, the upper-left cell of the data range should be blank. Clear out the “Region" heading before using this trick. In Excel 2010, the problem is fixed.
Gotcha: This trick is awesome if you need to create clustered column charts with the legend on the right. The odds says that you have to create something else. Use the next topic to change the chart that you get with Alt+F1.