Want to print only the graph in your Excel file on a Mac? While Excel doesn't provide a direct print option for just graphs, you can use a workaround to achieve this. Here's a step-by-step guide to help you print only the graph in Excel on your Mac.
Before we start, ensure your graph is inserted in the worksheet and visible. If it's not, select and copy the graph from its original location and paste it into a new worksheet. This will make the printing process more straightforward.
Preparing Your Graph for Printing
First, make sure your graph is the correct size for printing. Excel allows you to adjust the graph size to fit the paper.
To do this, select your graph, go to the 'Design' or 'Format' tab in the ‘Drawing Tools' section, then under 'Size & Properties', select 'Scale to Fit' and choose '100%'. This will ensure your graph prints at its actual size.
Removing Unwanted Data from the Worksheet
Excel prints the entire worksheet by default. To print only the graph, you need to remove or hide all the unwanted data.
First, select and delete any cells or ranges in the worksheet that you don't want to print. Then, hide any empty rows or columns by selecting them, right-clicking, and choosing 'Hide' from the context menu. This will create a blank space around your graph.
Freezing the 'Print Area'
Freezing the 'Print Area' in Excel ensures that only the selected range prints when you open the 'Print' dialog box. This is a more reliable method than simply zooming to 100% and fitting to one page, as it maintains the original graph size.
To freeze the 'Print Area', select the entire range that includes your graph. Then, go to the 'Page Layout' tab, click on the 'Print Area' button in the 'Page Setup' group, and select 'Set Print Area'. This will highlight the selected range in blue, signaling that this is the only area that will print.
Printing the Graph
Now that you've prepared your graph for printing, it's time to print it. Here's how:
Press 'Command + P' on your keyboard to open the 'Print' dialog box. You should now see your graph, along with any hidden rows or columns, selected for printing. If everything looks good, click 'Print'.
Printing from 'File' Menu
If you prefer using the menu instead of the keyboard shortcut, you can also access the 'Print' dialog box from the 'File' menu. Here's how:
Click on 'File' in the menu bar, then select 'Print' from the dropdown menu. This will open the same 'Print' dialog box where you can preview and print your graph.
Adjusting Print Settings
You can adjust the print settings, such as paper size, orientation, and scale, by clicking on the 'Page Setup' button in the 'Print' dialog box. This will open the 'Page Setup' dialog box where you can make these adjustments.
Once you're satisfied with the print settings, click 'Print'. Excel will print only the area you've selected, including your graph.
Now you know how to print only the graph in Excel on your Mac. Practice these steps a few times, and you'll be printing graphs like a pro in no time. Happy printing!