To overcome this, you can play with the settings in the Print dialog box to get just the pages printed that you need. Second, Excel will also try to print your large data range in the printout.
If you select the chart before printing, Excel will print just the chart and shrink it to fit on a single page. There are two things to remember in this approach: First, you must make sure that you select a workbook cell when printing. When you print the worksheet, Excel splits the chart across multiple pages, as desired. You can then size the chart to be as wide as you want, thereby revealing as much data as you want.
By default these are set to ‘automatic’ but if you click the dropdown arrows here you are able to choose. There are two dropdown boxes one for width and one for height. On the Page Layout tab > Scale to fit group you will see a number of options. This results in a chart that floats over the top of the worksheet. First, open the worksheet the you want to print. Instead of creating the chart as a chart sheet, create it as an object on a worksheet. Step 2: Click File at the top of the screen. Step 1: Open the spreadsheet in Excel 2011. This is likely a better solution if you are going to be printing a large spreadsheet with a high number of rows. For instance, if the data range you want to actually chart is in A1:B2000, you might create 20 charts, with each chart made up of the data from 100 rows.Īnother potential solution involves how you create the chart itself. For example, you could configure an Excel worksheet to print all of the columns on one page, but spread out the rows on additional pages. Thus, the amount of detail on each chart would depend on the amount of data you are assigning to that chart. Fortunately, there are a few things you can do.įirst of all, you could simply break the data range you are charting into smaller "chunks" of data that would be printed on different charts.
Instead you are left to work around the problem. You choose which way by the named setup you saved. You can if you wish (at least on HP Printers) save the setup as Printer template.
#MICROSOFT EXCEL 2011 TWO SIDE PRINTING DRIVER#
the Print Driver (what you see choose duplex printing. It only passes along command to printer to print the file.
#MICROSOFT EXCEL 2011 TWO SIDE PRINTING MAC#
Unfortunately, the answer to what could otherwise be a simple question is complicated by the fact that Excel doesn't easily allow you to print a single chart across multiple pieces of papers. Word (or Excel for that matter) on Mac doesn't control how the printer prints. This leads to a problem when printing the chart: Do you print it so it fits on one piece of paper, thereby losing detail, or do you try to maintain the detail and print the chart on multiple pieces of paper? If you are using Excel to chart very large amounts of data, the charts you create can end up being very large, as well.
0 kommentar(er)
