software

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 quot;if a blank row exists do not print a blank labelquot;
(or something to that effect) is checkmarked.

Any ideas???? Thanks.

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 quot;featurequot;. But who
on Earth thought it was a sensible idea?

quot;Lauraquot; wrote:

gt; I have an Excel address list of 400 contacts. I'm using mail merge to get
gt; these into Word for label printing. When I edit the Excel chart by hiding
gt; rows 20 to 45, Word will leave those labels blank. In otherwords, I'm seeing
gt; populated labels 1 thru 19....then a bunch of blank labels....then populated
gt; labels 46 to 400.
gt;
gt; I made sure the setting quot;if a blank row exists do not print a blank labelquot;
gt; (or something to that effect) is checkmarked.
gt;
gt; Any ideas???? Thanks.

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

BrianH

quot;Peterquot; wrote:

gt; There is a similar problem with plotting charts. If you create a graph of
gt; data in a range of cells, some of which are hidden, the hidden data points
gt; don't appear on the chart. Consequently, if you have anything but the
gt; smallest spreadsheet, and hide rows to make the spreadsheet more manageable,
gt; the graph doesn't work. So it sounds like it might be a quot;featurequot;. But who
gt; on Earth thought it was a sensible idea?
gt;
gt; quot;Lauraquot; wrote:
gt;
gt; gt; I have an Excel address list of 400 contacts. I'm using mail merge to get
gt; gt; these into Word for label printing. When I edit the Excel chart by hiding
gt; gt; rows 20 to 45, Word will leave those labels blank. In otherwords, I'm seeing
gt; gt; populated labels 1 thru 19....then a bunch of blank labels....then populated
gt; gt; labels 46 to 400.
gt; gt;
gt; gt; I made sure the setting quot;if a blank row exists do not print a blank labelquot;
gt; gt; (or something to that effect) is checkmarked.
gt; gt;
gt; gt; Any ideas???? Thanks.

Hi Brian,
Yes, I saw the quot;chart optionsquot; that you mentioned but unfortunately, the
option quot;Plot visible cells onlyquot; 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

quot;BrianHquot; wrote:

gt; With your chart or chart sheet selected, select Tools Options Chart.
gt; There are a number of plotting control options here
gt;
gt; BrianH
gt;
gt; quot;Peterquot; wrote:
gt;
gt; gt; There is a similar problem with plotting charts. If you create a graph of
gt; gt; data in a range of cells, some of which are hidden, the hidden data points
gt; gt; don't appear on the chart. Consequently, if you have anything but the
gt; gt; smallest spreadsheet, and hide rows to make the spreadsheet more manageable,
gt; gt; the graph doesn't work. So it sounds like it might be a quot;featurequot;. But who
gt; gt; on Earth thought it was a sensible idea?
gt; gt;
gt; gt; quot;Lauraquot; wrote:
gt; gt;
gt; gt; gt; I have an Excel address list of 400 contacts. I'm using mail merge to get
gt; gt; gt; these into Word for label printing. When I edit the Excel chart by hiding
gt; gt; gt; rows 20 to 45, Word will leave those labels blank. In otherwords, I'm seeing
gt; gt; gt; populated labels 1 thru 19....then a bunch of blank labels....then populated
gt; gt; gt; labels 46 to 400.
gt; gt; gt;
gt; gt; gt; I made sure the setting quot;if a blank row exists do not print a blank labelquot;
gt; gt; gt; (or something to that effect) is checkmarked.
gt; gt; gt;
gt; gt; gt; Any ideas???? Thanks.