Using Hidden data for a chart
 

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

Using Hidden data for a chart
 

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

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

Using Hidden data for a chart
 

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" skrev i en meddelelse
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