You'll need to use a dummy table for this, or write a more elaborate macro which codes the series based on the visible range of cells.

This http://www.excelfox.com/forum/f2/cha...own-list-1197/