Hiding Rows Leaves Labels Blank

[Laura]

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.

[Peter]

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.

[BrianH]

With your chart or chart sheet selected, select Tools Options Chart.
There are a number of plotting control options here

BrianH

"Peter" wrote:

> 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.

[Laura]

Hi Brian,
Yes, I saw the "chart options" that you mentioned but unfortunately, the
option "Plot visible cells only" is greyed out. I also tried looking at the
options in Word after mail merge is complete....I can't find anything that
would remove the unpopulated labels. At this point, it sounds as though I'm
forced to copy my Excel contact chart, remove the contacts I don't want to
print on labels and save as a new name.

Thanks for your time - Laura

"BrianH" wrote:

> With your chart or chart sheet selected, select Tools Options Chart.
> There are a number of plotting control options here
>
> BrianH
>
> "Peter" wrote:
>
> > 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.