I know Excel normally ignores chart data that is in hidden rows/columns, and
I know there's the option for it NOT to ignore it (i.e. have Excel built the
chart even if the data is in a hidden row/column).

I have a spreadsheet in which data which lies in the hidden columns is
practically meaningless, but hidden rows contain numerical data which I'd
like to create graphs from, but which I'd also like to remain out of sight.
My question is, therefore: is it possible for Excel to only ignore data in
hidden *columns*, but take into account data from hidden *rows*?

Anticipated thanks for your help.

All or nothing. Could you make the rows 1 pixel high, so they're not really
hidden?

Alternatively, perhaps all the chart source data could reside on a backup
worksheet, so you could show what you want and plot what you want, without
one dictating the other.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"wildetudor" <(E-Mail Removed)> wrote in message
news:5AF43E3E-C5B7-4D92-84E2-(E-Mail Removed)...
>I know Excel normally ignores chart data that is in hidden rows/columns,
>and
> I know there's the option for it NOT to ignore it (i.e. have Excel built
> the
> chart even if the data is in a hidden row/column).
>
> I have a spreadsheet in which data which lies in the hidden columns is
> practically meaningless, but hidden rows contain numerical data which I'd
> like to create graphs from, but which I'd also like to remain out of
> sight.
> My question is, therefore: is it possible for Excel to only ignore data in
> hidden *columns*, but take into account data from hidden *rows*?
>
> Anticipated thanks for your help.