Access hidden data

Hi

Is there any way to access data from hidden columns ? I have a chart that's referring to column A and when i hide it the chart goes blank.

Thanks

Hi vismbr,

You dont need VBA Programming to do what you are asking... So this post may need to be moved...

However Try This...


In Excel 2003, try this...

1. Select your chart, then click Tools - Options
2. On the "Chart" tab, un-check "Plot visible cells only"
3. Click OK.
4. Hide your data...

Mike,