Hi Rick,

Yes there is, Select the chart and then use the menu Tools Options.
On the chart tab is a checkbox 'Plot Visible Cells Only', uncheck this
to get your chart working.

Cheers
Andy

Rick wrote:

Hi everyone,

I am using source data from a column that I want to be "hidden" on a
worksheet. The chart is fine until I hide the column then the chart is
blank and the source data dispappears? Is there a way to use "hidden"
ranges as source data?

TIA,

Rick

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info