Camera Operator / Editor

For most Mac users, I would recommend using iWork for your “office” tools. With Number’s ’08, making a graph is just a matter of clicking a button. On the other hand, with Microsoft Excel, there is a little more clicking involved, making it a bit less user-friendly. Since most jobs these days require that you use Microsoft Office, I figured this would help out many individuals.

  1. First open up Microsoft Excel.
  2. Type in the “X-Axis” values into the first column.
  3. In the second column, type in the “Y-Axis” values. Feel free to use more columns depending on your data.
  4. Once you’ve finished that up, select all of your “Y-Axis” values.
  5. From the menubar, choose Insert > Chart…
  6. You’ll be prompted with the “Chart Type” window. Choose a type that suits your needs.
  7. After clicking the “Next” button, you should see a preview of your graph showing the data ranges.
  8. After confirming the data ranges, click on the “Series” tab at the top of the window.
  9. To name the data, click on “Series1” (or any “Series#”) and type in the title you want in the “Name:” field.
  10. When you’ve named all of your series, click on the triangle icon in the “Category (x) axis labels:” field towards the bottom of the window.
  11. Select all of your “X-Axis” values from your sheet. In the small pop-up for the X-Axis values, click on the upside down triangle icon to save those values.
  12. Click the “Next” button when the “Series” window reappears.
  13. In the “Titles” section, enter the main title for the graph and for the X and Y-Axis.
  14. You do not usually need to change the settings in the other tabs (i.e. Axes, Gridlines ,etc.), but feel free to.
  15. After clicking the “Next” button, the “Chart Location” window appears.
  16. Check off “As object in” or “As new sheet” depending on where you want the graph to be inserted.
  17. After clicking “Finish”, select your graph and go to File > Print… from the menubar.

screenshots: 2-4 5 6-7 8 9 10 11-12 13 15-16 17

One problem many Mac users have been noticing lately is the bug Mac OS X 10.5 that does not include attachments when you save Mail messages as RTF. Thanks to Andreas Amann, this bug can be easily remedied with his AppleScript package for Mac OS X Mail. Here is how to export a message to RTF and include attachments:

  1. First download the AppleScripts from Amann’s site.
  2. To install it, just double click on “MailScripts Installer” in the MailScripts.dmg.
  3. Next, go to Mac OS X Mail and locate the messages you want to export.
  4. If you want to export specific messages instead of all of them, make a mailbox called “RTF”
  5. Right-click on the messages you want to export and choose “Copy To” > RTF.
  6. In the menubar look for the AppleScript icon next to the Volume icon.
  7. In list of AppleScripts that appear, all we care about is “Mail Scripts”.
  8. Inside of “Mail Scripts”, choose “Archive Messages…”.
  9. Now, select the mailbox RTF.
  10. In the “Selection Criteria” window, make sure you pick “Rich Text Format” and “Include Attachments” under “Export Format”.
  11. After making any other changes, click OK and the mail message will appear on your Desktop (or elsewhere depending on where you chose to export it) in RTF format with all attachments included.
  12. Once you’re finished exporting, you may want to remove the messages (which are copies of the originals, so they’re safe to delete) from the RTF mailbox so they won’t get exported again for the next time.

screenshots: 2 4 5 6-8 9 10