Using Hidden data for a chart

[Rick]

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]

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

 

[Tom Ogilvy]

with your chart selected, go into Tools=>Options, Chart tab and unclick Plot
Visible Cells Only.

--
Regards,
Tom Ogilvy

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

 

[Leo Heuser]

Hi Rick

In Tools > Options and the tab "Chart" (or similar)
uncheck the field "Only display visible cells" (or similar).

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

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