Hide Column, but Still Chart

  • Thread starter Thread starter beeawwb
  • Start date Start date
B

beeawwb

Good afternoon all,

Just working with a chart I have that increments itself as I add ne
weeks, by formula. The problem is, All my columns have to be visibl
for the chart to work correctly, and I want to keep print size down t
5 pages (1 for the data, 4 for the charts) (If the data spills ont
another page, then I get 10 pages. 2 for data, 4 for charts, and
blank pages as overflow from the charts / data size). So, what I'v
been doing, is 'hiding' columns by sizing them down to 0.06, which i
the minimum slidable size.

So, what I'm wondering is, can I fully hide these columns, but stil
have them appear in my chart?

Thanks for your assistance on this one,

-Bo
 
Hi Bob,

Select the chart and then on the Chart tab of the Tools > Options dialog
uncheck the "Plot visible cells only" option.

Cheers
Andy
 
Back
Top