I am having trouble plotting visible cells only within a worksheet. I created a chart that has source data in 3 columns of a list where each row contains daily data from 2006-2008. The list is not filtered, however I have hidden columns prior to 2007.

When selecting the chart I have gone into Tools->Options and have checked the box "Plot visible cells only", but the chart still plots 2006-2008 data. Does Excel have issues with correctly plotting data contained in a list when this box is selected?