Mark Points on an Excel Chart with a Vertical Line

“How To Add a Vertical Line to an Excel XY Chart” by The Closet Entrepeneur provides instructions for marking points of interest on an Excel chart with vertical lines.

This tutorial may be particularly interesting to anyone who plots a series of data points over time with Excel. Using these instructions, one can mark “points of interest” along the X axis of an Excel chart in order to give context to the data. The author illustrates this by plotting his RSS subscribers over time, and the inserting a vertical line that shows the point at which is site was featured on a popular blog. The line can help to explain fluctuations in your data, and can be especially helpful when you are putting together a report that will be read by other people.

Quickly Remove Hyperlinks from a Word Document

From time-to-time you may wish to remove the hyperlinks from your Word documents. Those blue underlines are helpful on your computer, but you may not want them showing up on your printouts. Here is a method for removing all hyperlinks from a Word document in no time flat:

1. Select the entire document by holding CTRL and pressing A.
2. While holding down CTRL and Shift, press F9.

Your document is now hyperlink-free. More speedy key combos can be learned from “Keyboard shortcuts for Microsoft Word“.