Using Hidden data for a chart

R

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
 
A

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
 
T

Tom Ogilvy

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

--
Regards,
Tom Ogilvy


Rick said:
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
Click to expand...
dispappears? Is there a way to
 
L

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.

Rick said:
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
Click to expand...
dispappears? Is there a way to
 
Top