View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peter
 
Posts: n/a
Default Hiding Rows Leaves Labels Blank

There is a similar problem with plotting charts. If you create a graph of
data in a range of cells, some of which are hidden, the hidden data points
don't appear on the chart. Consequently, if you have anything but the
smallest spreadsheet, and hide rows to make the spreadsheet more manageable,
the graph doesn't work. So it sounds like it might be a "feature". But who
on Earth thought it was a sensible idea?

"Laura" wrote:

I have an Excel address list of 400 contacts. I'm using mail merge to get
these into Word for label printing. When I edit the Excel chart by hiding
rows 20 to 45, Word will leave those labels blank. In otherwords, I'm seeing
populated labels 1 thru 19....then a bunch of blank labels....then populated
labels 46 to 400.

I made sure the setting "if a blank row exists do not print a blank label"
(or something to that effect) is checkmarked.

Any ideas???? Thanks.