I'm working on a spreadsheet that will have some columns of data, and some
charts to illustrate the data graphically. There are certain rows that I want
to use (as essentially column headers) for the charts, which I don't want to
show in the spreadsheet when printed. There's nothing secret about them,
they're just not needed and would clutter up the printed spreadsheet to have
them shown.
I know I can keep the contents of the rows from printing, and in fact I did
that, but the way things were laying out on the sheet, it would be desirable to
hide the entire row (not have a blank row printed).
So I went to to Format > Row > Hide, and the row was properly hidden. What I
DIDN'T expect, and what was very undesirable, is that the hidden row was no
longer used by the chart. I checked the data range, and it said that this row
was still included in the data range. But once it was hidden, the chart acted
like there were no contents to this row.
A less desirable work-around was to make the rows very short (a height of
0.05" (about 1 mm) for example). Then they don't take up much space in the
printout, and the chart still recognizes that they are there.
It does not seem to me that hiding rows should make them invisible to a chart.
It certainly doesn't make them invisible to formulas and functions, which is
good.
Does anyone know if this is intentional behavior (and if so, why?), or if it
is a bug, or something else?
________________________________________________________________________
Check out the new AOL. Most comprehensive set of free safety and security
tools, free access to millions of high-quality videos from across the web, free
AOL Mail and more.