Stretch Print Area...

In theory there should be no problem if you have set up your plotter as a printer with the correct driver, when the data should fill the page as in Print Preview. Such as with A4 and A3 paper sizes.

You should then be able to go into Page Setup or Print/Properties and select the required paper size.

Suggest you visit the plotter manufacturer website or drivers.co or search Google.com for info using your plotter make/model.

You suggest that you have already tried the "Adjust to xx% normal size" print option. Of course the page size would need to be correct.

ozdemir said:

I have data that I want to plot to our Color Plotter. The size of the sheet is 22x34 and of course the data does not fit the entire sheet. How do I stretch/scale the data automatically to make it all fit on one page (scaled up accordingly)? I have tried the fit to page option and some other common sense solutions, but to no avail. Thanks.

oz

Click to expand...

Unfortunately, when you select the Fit to Page option, Excel only scales down as necessary. It does not scale up above 100% (as Lotus 123 did). So you will need to set the Adjust to value manually by trial and error until you get the desired result in Print Preview.