23
Working with Charts
Leaving the Top-Left Cell Blank
In the past, Excel tipsters would tell you to always leave the top-left cell of your dataset
blank before creating a chart. This requirement has eased up a bit with Excel 2007.
The old guideline was that if your series or category labels contained either dates or
numeric labels, you should leave the top-left cell blank. Excel 2007 has been tweaked a bit.
Now, if your labels contain values formatted as dates, there is no need to leave the top-left
cell blank. In addition, if your data has been converted to a table, using the Format as Table
icon on the Home ribbon, it is impossible to leave the top-left ...