View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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