How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Mike Your Own Question

Mike
Mike, Mac Medic
Category: Mac
Satisfied Customers: 8698
Experience:  Over 20 years IT experience with Apple computers in publishing, marketing and design.
25267123
Type Your Mac Question Here...
Mike is online now
A new question is answered every 9 seconds

In Excel for Mac 2008, how can I select a chart for printing? I

Customer Question

In Excel for Mac 2008, how can I select a chart for printing?
I am used to Excel 2004, where selecting a chart for printing is a simple matter of clicking on it, but my 2004 Excel is malfunctioning, and I am opening a previously-created file in Excel 2008.
After clicking on a chart, I cannot make it print alone - always the entire sheet.
Submitted: 4 years ago.
Category: Mac
Expert:  Mike replied 4 years ago.
From within Excel, create a PDF of the worksheet.
Open the PDF in Preview.
Use the Select Tool to draw a box around the chart you'd like to print.
Use Command-C (or Edit > Copy) to put the selection on the clipboard.
Use Command-N (or File > New From Clipboard) to create a new document with your selection from step 3.
Print.
Customer: replied 4 years ago.
This isn't completely satisfactory, as the worksheet is 12 pages long when I look at it in Print Preview, and the chart that I want to print straddles print pages 3 and 7.
I was hoping to be able to find a way to select a chart itself for printing - on one worksheet I want to print a paper copy for desk use, on another worksheet I want to print a different chart to pdf for insertion in report
Expert:  Mike replied 4 years ago.
In Excel 2004 and 2008 you can right-click or control-click on a chart and
choose Save As Picture from the pop-up menu. Then you can open and then
print the picture file.

It appears the feature of being able to Print > Selection seems to be gone
from Excel 2008. Sorry blame Microsoft.
Expert:  Mike replied 4 years ago.
Did you get that?
Expert:  Mike replied 4 years ago.
I answered correclty, good luck.