In Excel, printing only a graph, and not the rest of the worksheet data, can save ink and prevent clutter in reports. This is particularly useful when you want to present only the visual representation of your data. Here's a step-by-step guide on how to achieve this:
Before we dive into the steps, ensure you have your graph already inserted within your worksheet. Let's get started with printing just the graph.
Selecting the Graph
First, you need to select the graph you want to print. This might seem obvious, but Excel allows multiple graphs, so making sure the correct one is selected is crucial.
To select the graph, simply click on it. A border will appear around your selected graph, indicating that it's ready for printing. If you want to print multiple graphs, you can select them by holding down the Ctrl key (or Cmd on a Mac) and clicking on each graph.
Printing the Selected Graph
Once your graph is selected, it's time to initiate the printing process. Here's how you can do it:
1. Press Ctrl + P (or Cmd + P on a Mac) to open the Print dialog box. Alternatively, you can go to the 'File' menu and select 'Print'.
Adjusting Print Settings
In the Print dialog box, you'll see several options. The key ones to adjust for printing only a graph are:
- Print what: Make sure 'Selection' is selected instead of 'Active sheet(s)'. This ensures only the selected graph will be printed.
- Scale to fit paper: Uncheck this box to maintain the size of your graph and fit it to the printer paper width.
- Fit to: From the drop-down menu, choose '1 page wide'. This ensures your entire graph is printed, even if it's wider than the paper.
After adjusting these settings, click on 'Print' to send your graph to the printer.
Printing to a High-Resolution PDF
If you're not printing directly, but instead saving your graph as a PDF, here's how to do it:
1. Follow the same steps as above to select your graph and open the Print dialog box.
Saving as a PDF
Instead of clicking 'Print', click on the 'Change printer settings' button (the tiny printer icon with a downward arrow).
2. From the available printers, select 'Save as PDF'.
3. Give your PDF a name, choose a location to save it, then click 'Save'.
Your graph will now be saved as a high-resolution PDF, perfect for large-scale print jobs or digital presentations.
And there you have it! Now you know how to print just a graph in Excel, making your reports easier to read and more visually appealing. Happy printing!