Add a secondary vertical axis

You can plot data on a secondary vertical axis one data series at a time. To plot more than one data series on the secondary vertical axis, repeat this procedure for each data series that you want to display on the secondary vertical axis.

1. In a chart, click the data series that you want to plot on a secondary vertical axis, or do the following to select the data series from a list of chart elements:

1. Click the chart.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis.

2. On the Format tab, in the Current Selection group, click Format Selection.

The Format Data Series dialog box is displayed.

 NOTE   If a different dialog box is displayed, repeat step 1 and make sure that you select a data series in the chart.

3. On the Series Options tab, under Plot Series On, click Secondary Axisand then click Close.

A secondary vertical axis is displayed in the chart.

4. To change the display of the secondary vertical axis, do the following:

1. On the Layout tab, in the Axes group, click Axes.
2. Click Secondary Vertical Axis, and then click the display option that you want.

5. To change the axis options of the secondary vertical axis, do the following:

1. Right-click the secondary vertical axis, and then click Format Axis.
2. Under Axis Options, select the options that you want to use.

 TIP   To help distinguish the secondary axis, you can change the chart type for just one data series. For example, you can change one data series to a line chart. For more information, see Present your data in a combination chart.

(Read the whole passage: http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx)

DownThemAll alternative in Chrome: Download All

Download All David Vavra (Destil) Free

Allows to download multiple files linked to any webpage at once.

Description

If you have multiple links to files at any webpage, this extension can help you. You specify file-type and the extension downloads all occurrences of this file-type. It's easier than 'Right click -> Save as' to all the files. 

NOTE:
Extension downloads just files which are not opened in Chrome by default (left click to file). So for example:

WORKS: zip, doc, xls, ppt, avi, tgz, java, rar, docx, ...
DOESN'T WORK: mp3, pdf (unless Adobe Reader is uninstalled), txt, jpg, png, ...
(these files are opened in new tabs instead of downloading, can be customized in settings)

(Read the original page: https://chrome.google.com/webstore/detail/dichiooocmfaijgfjjohpjdbelmficee)

MS Excel: Transpose Function

In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.
The syntax for the Transpose function is:

Transpose( range )

range is the range of cells that you want to transpose.

Note:

• The range value in the Transpose function must be entered as an array. To enter an array, enter the value and then press Ctrl-Shift-Enter. This will place {} brackets around the formula, indicating that it is an array.

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:
We've placed values in cells A1, A2, and A3, and we'd like to view these values in cells C1, D1, and E1 (transposed). To do this, you highlight cells C1, D1, and E1, then enter the following formula:

=TRANSPOSE(A1:A3)

Then press Ctrl-Shift-Enter to create an array formula. You will notice that {} brackets will appear around the formula and the values in cells A1, A2, and A3 should now appear in cells C1, D1, and E1.

Frequently Asked Questions

---

Question:  In Excel, isn't it easier to use the Paste Special transpose option to do the same?
Answer: Yes, if you ONLY want to perform a one-time paste of the values, you can do the following:

Highlight the cells that you want to copy. In this example, we've highlighted cells A1:A3. Then right-click and select Copy from the popup menu.


Then right-click on the cell where you'd like to paste the values and select Paste Special from the popup menu.


Then select the Transpose checkbox and click on the OK button.


Now when you return to your spreadsheet, you'll see that the values have been copied and transposed.


(Read the whole passage: http://www.techonthenet.com/excel/formulas/transpose.php)

MS Excel: Cell Function

In Excel, the Cell function can be used to retrieve information about a cell. This can include contents, formatting, size, etc.
The syntax for the Cell function is:

Cell( type, range )

type is the type of information that you'd like to retrieve for the cell. type can be one of the following values:

Value	Explanation
"address"	Address of the cell. If the cell refers to a range, it is the first cell in the range.

(Read the whole passage: http://www.techonthenet.com/excel/formulas/cell.php)

Option Explicit

Q. How to avoid incorrectly typing the name of an existing variable?

A. Use Option Explicit statement at file level to force explicit declaration of all variables in the script:

Option Explicit

Option Explicit statement must appear in a script before any procedures.

When you use the Option Explicit statement, you must explicitly declare all variables using the Dim, Private, Public, or ReDim statements. If you attempt to use an undeclared variable name, an error occurs:

Dim myVar
myVar = 1
myNewVar = 0 ' ERROR: Variable not defined.

(Read the whole passage: http://www.excely.com/excel-vba/option-explicit-statement.shtml)

可以highlight重點的PDF reader

一個不錯的軟體：PDF XChcange viewer，可以highlight重點，比 Foxit Reader及Adobe Reader好用。


PDF XChange viewer… 多國語系版, 免安裝版
http://www.portablefreeware.com/?id=1436


(Read the original webpage: http://bigfool.wordpress.com/2010/01/09/%E5%8F%AF%E4%BB%A5highlight%E9%87%8D%E9%BB%9E%E7%9A%84pdf-reader/)
(Original software webpage: http://www.tracker-software.com/product/pdf-xchange-viewer)

"in accordance with" VS "pursuant to" VS "according to"

"pursuant to" must follow some other action. "Pursuant to the new regulations recently passed regarding bubble gum-blowing, no bubbles may be blown that exceed 3 inches in diameter."

"according to" is citing a reference. "According to the Bible, in the beginning was the Word."

"in accordance with" is "in line with", "in agreement with" -- "in accordance with your wishes, I will no longer quote the Bible while blowing bubbles."

(Read the whole passage: http://forum.wordreference.com/showthread.php?t=233835)