How to Mix Chart Types in Excel

1. Open the Excel worksheet.
2. Click and drag to select the categories and data values for the charts.
3. Click the “Insert” tab on the command ribbon.
4. Click one preferred chart type in the “Charts” group. The data converts to one chart type. The “Chart Tools” ribbon appears.
5. Right-click one data series in the plot area. This selected series will display a different chart type. A list of options appears.
6. Click “Change Series Chart Type” in the list. The “Change Chart Type” dialog window opens with a gallery of chart thumbnails.
7. Click the preferred chart type.
8. Click “OK.” The data series converts to a new chart type.

Read more ►

How to Unhide Columns in MS Excel 2007

Using the Ribbon
1. Highlight at least one cell on each side of the column you want to redisplay. For example, if you are trying to unhide column E, highlight a cell in both column D and F.
2. Select the 'Home' tab from the Office Ribbon near the top of the window and then locate the 'Cells' section of the Ribbon.
3. Click the 'Format' button, select 'Hide Unhide' and then click the 'Unhide Columns' option.
Using the Right-click Menu
4. Look to the column ID row at the very top of your spreadsheet.
5. Hold your cursor over the left edge of the column ID located immediately to the right of the hidden column you want to reveal. For example, if you are trying to unhide column A, hold your cursor over the left edge of column B in the column ID row. A double-sided arrow will appear when your cursor is in the proper position.
6. Right-click and select the 'Unhide' option.

Read more ►

How to Make a Project Milestones Chart

Making a Chart in Microsoft Project
1. In the Microsoft Project software program, open a new document that shows two window panes--one for tasks and one for the chart.
2. In the task column, enter each of the tasks for the project and the duration to complete each of the tasks in the duration column.
3. For the first task, enter the date that you would like to start the task.
4. For each of the tasks, identify which of the other tasks are predecessors or must be completed before the start of the next task. The number associated with the task that must be completed first should be entered into the predecessor column.
5. The system will then automatically schedule an end date based upon the start date and the duration of each task, and the system will generate a Gantt chart displaying the duration for each task.
Making a Chart in Microsoft Excel
6. Open a new Excel worksheet.
7. Enter the name of each task in the first column. In the second column, enter the expected start date. Enter the number of days completed for the task in the third column and enter the number of days remaining to complete the task in the fourth column.
8. Select the spreadsheet area you want to graph and open the chart wizard. Select the 'Stacked Bar Graph' as the type of graph you want to generate and select 'finish.'
9. Select the start date column. Go to Patterns and select Format Data Series. Once the box has opened, choose to have 'none' for both the area and border tabs. Select the y-axis of the chart and select the scale tab. Enter a value of 60 for the major unit, which represents approximately two months, and a minor unit of 1, which represents a day. The minimum and maximum values should correspond to the dates you want to capture with your chart. Be sure the box for 'Category axis crosses at maximum value' is checked.

Read more ►

How to Create an Anchor Formula in Excel

1.
Decide which cells in your formula need to be anchored and which do not. Single cells that are used by every iteration of the formula need to be anchored. Cell references that are different for each iteration of the formula do not need to be anchored.
Example: A1 B1 should update to A1 B2. A1 will be the cell reference that will be anchored.
2.
Insert a '$' sign before the letter and the number of the cell reference to be anchored. Example: Replace 'A1' with '$A$1'.
3.
Select the cell with the formula in it. Drag the black square in the lower-right corner of the cell over the cells for the formula to be copied to.
4.
Verify that each cell has the intended formula and result.

Read more ►

How to Use AutoComplete in Word

1. Start Microsoft Word and open an existing file or start a new blank document.
2. Type within your Word document, being sure to watch the screen for a yellow box that will appear above your typing. AutoComplete will try to finish any common words, including your name, the current date, day, month, year and any other AutoText entries that you have established.
3. Spot the yellow box that appears while you are in the middle of typing a word. Press the 'Enter' key on your keyboard to enter the word that is suggested by the Word AutoComplete tool. If Word suggests a word that you are not typing, then simply ignore the suggestion. It will go away after you have finished typing the word.
4. Repeat this process to enter any other additional AutoComplete selections into your document.

Read more ►

How to Sort Multiple Rows Columns in Excel

1. Highlight the rows and columns you wish to sort by clicking and dragging. Alternatively, place the cursor in one of the corners of the area of the spreadsheet you want to sort, hold down the 'Shift' key, and use the arrow keys to highlight the area to sort. The area must be contiguous and rectangular; you cannot sort areas that are not connected.
2. Click on the 'Data' command at the top of the window, then choose 'Sort.'
3. Click on the option you want at the bottom of the pop-up window labeled 'My list has.' If you choose 'Header row,' Excel will use the top row as the header and not sort it; if you choose 'No header row,' it will sort the top row with the other data.
4. Choose the column you wish to begin your sort with from the drop down menu under the 'Sort by' heading in the pop-up window. If you are using a header row, the drop down menu will show you the contents of the top cell of each column, if not, you will see 'Column A,' 'Column B,' etc.
5. Make further choices for the order you want the data sorted into by using the 'Then by' selections in the pop-up window. This allows you to sort, for instance, by last name followed by first name.
6. Click 'OK' at the bottom of the pop-up window to sort the data.

Read more ►

How to Auto Number in Excel 2007

Functions
1. Click the first cell in the row or column you want to number.
2. Type '=TEXT(ROW(A1), '000')' to number the rows beginning with '1' and with the format 001, 002, etc. Replace 'A1' with a different cell reference to begin at a different number; use 'A2' to begin with 002, for example. In this formula, the cell reference returns the row number of the cell. You can use any cell reference in the formula, not just the reference for the cell the formula is in. Replace '000' with '$0.00' for dollar format, '0%' for percent format or use your own format.Only type '=ROW(A1)' if you want numbers in standard format -- 1, 2 and so on.
3. Press 'Enter' on your keyboard and Excel will calculate the formula. Select the same cell again and hover your pointer over the bottom right corner of the cell until a black cross appears. Click and drag down to cover as many cells as you want to number.
Fill Handle
4. Click to select the cell where you want to begin numbering and type your first number.
5. Select the next cell in the row or column you are numbering and type the second number in your series. For standard numbering, type '1' in the first cell and '2' in the second. Use '2' and '4' to number by twos, '10' and '20' to number by tens, and so forth.
6. Click the first cell and hold the left mouse button down. Drag down or right to the second cell so both are selected at once.
7. Hover the pointer over the bottom right corner of the second cell until you see a black cross. Click and drag down to number rows or to the right to number columns. Let go of the mouse button when you reach the cell where you want the numbering to end.

Read more ►

How to Stop Word From Making a Black Line Across the Page

Turn Off the Automatic Border Setting
1. Double-click the Microsoft Word application or choose it from your Start menu to run it.
2. Type some text in the blank document window.
3. Press the 'Enter/Return' key to start a new paragraph and type either '***,' '###' or '---' and press the 'Enter/Return' key again to move to the next line. A border will appear on the page.
4. Click the 'File' button (Word 2010) or the 'Office' button (Word 2007) in the upper left corner of the screen and select 'Options' (Word 2010) or 'Word Options' (Word 2007).
5. Click the 'Proofing' category in the options window and then select 'AutoCorrect Options.'
6. Click the tab at the top of the AutoCorrect options window that says 'AutoFormat As You Type.'
7. Uncheck the box next to 'Border Lines' to stop Word from replacing the symbols ###, *** and --- with a border if you prefer the black line not to appear again automatically.
8. Click the 'OK' button to return to your document window.
Remove the Automatic Border Line
9. Click on the line above the border on the page, hold down the mouse button and drag to the line below the border line to highlight all the paragraphs near the border.
10. Click the 'Home' tab at the top of the screen, then click the 'Border' button on the 'Paragraph' panel. A drop-down menu will appear.
11. Choose 'No Border' from this menu and the border line on your page will disappear.

Read more ►

How to Insert a Button in Excel 2007

1. Open Excel and check that the 'Developer' tab is available on the ribbon. If it is not, click the Windows button, and then click the 'Excel Options' button. In the 'Popular' options, click the check box next to 'Show Developer tab in the Ribbon.' Click 'OK.'
2. Click the 'Developer' tab and click 'Insert.'
3. Click the first icon in the upper left corner of 'Form Controls' for inserting a form control button, or click the first icon under 'ActiveX Controls' for an ActiveX button.
4. Left-click on the portion of the Excel sheet where you want to create the button and drag to create a box.
5. Assign a macro to the button in the 'Assign Macro' window that pops up for the form button. You can create a new macro by clicking the 'New' button or record one by clicking the 'Record' button. 'New' opens Visual Basic so you can enter your code. To record a macro, press the 'Record' button and give the macro a name. Assign a shortcut key and description if desired and click 'OK.' Then perform the actions the macro should perform. When finished, click the 'Stop Recording' button in the ribbon and the macro is saved. To add code to the ActiveX button, double-click the button and then add in your code. Press 'F1' for help and press 'Alt' 'Q' to save and return to Excel.

Read more ►

How to Convert Excel to a Visio Organization Chart

1. Create a table in Excel listing all of the names and titles you want to use in the organization chart. Enter the headings 'Title,' 'Name' and 'Reports To' in the first row of the worksheet. Enter each person's title, name and to whom they report. For the CEO or anyone else who does not report to anyone, leave that cell blank. Save the worksheet and close Excel.
2. Open Visio. Go to the 'File' menu or tab and select 'New.' Select 'Business' as the template category and then click on 'Organization Chart Wizard.' The wizard will open.
3. Select 'Information That's Already Stored in a File or Database' and click 'Next.' Choose 'A Text, Org Plus or Excel File' and click 'Next' again. Click 'Browse' and locate the Excel worksheet you created. Select this file and click 'Next' to import it.
4. Select the appropriate headings that correspond to those in your Excel worksheet, such as 'Name' and 'Reports To.' Click 'Next.' Add the columns from which you want to display data in the organization chart and click 'Next.' Click 'Next' again and then click 'Finish.' A basic organization chart will appear.
5. Make changes to the organization chart as desired. Right-click a shape and select 'Format' to fill it with color or change the line. Select text in a shape, right-click and select 'Font' to change the font, size or color. Save the organization chart when you are finished.

Read more ►

How to Add 12 Weeks to a Date in Excel

1. Open Microsoft Excel.
2. Write the start date in cell A1 using the familiar format month/day/year and press 'Enter.' As an example, to enter January 1, 2010, you would enter '1/1/2010' in cell A1. Alternatively, enter the function '=today()' to enter the current date.
3. Type '=A1 84' in cell B1 and press 'Enter' to calculate the date exactly 12 weeks from the start date. Alternatively, enter '=A1 (7*12)' to break up the number of days in the week times the number of weeks. This allows you to easily change the number of weeks. You can even reference the number of weeks entered in another cell, such as A2, by changing the formula to '=A1 (7*A2).'

Read more ►

How to Name a Chart Object in Excel

1. Right-click your Excel spreadsheet file and select 'Open With.' Click 'Microsoft Excel' in the list of programs.
2. Click the chart you want to edit in the spreadsheet. Click the 'Layout' tab or ribbon if you have Excel 2007.
3. Click the 'Properties' button. Type a new name for the chart in the 'Chart Name' text box. Click 'OK' to save the changes.

Read more ►

How to Protect Individual Cells in Excel 2003

1. Launch 'Excel 2003' and open the file that contains the individual cell that you want to protect. Click once on the cell that you want to protect. This action will display a border around the cell to indicate that it is selected.
2. Click the 'Format' drop-down menu, and select the 'Cells' option. Select the 'Protection' tab. Click the check box next to the 'Locked' listing.
3. Click the 'Tools' menu and highlight 'Protection' to display a list of available options. Click the 'Protect Sheet' listing, and click 'OK.'

Read more ►

How to Convert a Number to a Date in Excel 2003 When the Format Is yyyymmdd

1. Create a grid with your numbers in Excel, if you haven't already done so. Open a new spreadsheet and type your numbers into column A. Leave column B blank – it will be used momentarily for the data calculation.
2. Type the following formula into column B:=DATEVALUE(MID(A2,5,2)'/'RIGHT(A2,2)'/'LEFT(A2,4))This sets up the formula to convert your numbers in column A to a date format, and the result will be displayed in column B. The output won't actually look like a date until you format the cell. Continue this formula for as many rows as you have data. You do this by moving your mouse to the corner until the cursor changes to a cross; then, click and drag down the number of rows required.
3. Highlight the cells in column B that you want to convert to a date. Select 'Format' and then 'Cells.' Select 'Date' in the Format Cells box. Choose any date format desired. Readable dates instantly populate in column B of your spreadsheet.

Read more ►

How to Unprotect a Word Doc

1. Click the 'Review' tab at the top of the screen.
2. Click 'Restrict Editing' in the Protect group.
3. Click the 'Stop Protection' button that appears within the Restrict Formatting and Editing window.
4. Enter the password in the blank field in the Unprotect Document dialog box that opens. Click 'OK.'

Read more ►