Using Hidden data for a chart
with your chart selected, go into Tools=Options, Chart tab and unclick Plot
Visible Cells Only.
--
Regards,
Tom Ogilvy
"Rick" wrote in message
news:iSRgc.27920$0b4.36798@attbi_s51...
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
|