How to Graph Multiple Series Using Excel

1. Type your data that will go on your x-axis in column A. Use row 1 as the title for your data and then a separate cell for each piece of data.
2. Type your first series of data in column B. Use row 1 as the title for your data and then a separate cell for each piece of data.
3. Type your next series of data in column C. Use row 1 as the title for your data and then a separate cell for each piece of data. Continue this pattern for each series.
4. Highlight every cell with a title or data in it. Highlight by going to cell A1, then press and hold shift while moving the cursor with your arrow keys.
5. Click 'Insert.'
6. Select 'Line' or 'Scatter.' The chart will then display on the spreadsheet.

Read more ►

How to Stop Running on Open in Excel Spreadsheets

Disable Macros in Microsoft Excel 2007
1. Click the round Microsoft Office button at the top-left corner of the Excel screen and then select 'Excel Options' from the very bottom of the drop-down menu.
2. Select 'Trust Center' from the menu on the left-hand side of the screen and then click the 'Trust Center Settings' button.
3. Select 'Macro Settings' from the left-hand menu.
4. Select one of two options: 'Disable all macros without notification' or 'Disable all macros with notification.'
5. Click 'OK' on each of the next two screens to close the dialog boxes and save your changes.
Disable Macros in Microsoft Excel 2003 and Earlier
6. Click 'Tools' in the top menu bar, select 'Macro,' then choose 'Security' from the resulting sub-menu.
7. Select 'Medium' or 'High' from the list of options presented within the 'Security Level' tab.
8. Click 'OK' to confirm your changes.

Read more ►

How to Create a Simple Timeline with Excel

1. Open a Web browser. Go to Microsoft.com and conduct a search for 'Excel timeline template.' From the resulting list, find the template titled 'Timeline' for Excel 97 or later.
2. Download the template. Select the template link, which will take you to the template's Web page. Click 'Download Now,' accepting any Web browser prompts regarding downloading a file. Excel should open with the template selected.
3. Modify the template. Select the years along the timeline and change them to relevant dates. Make sure that your dates make sense for the timeline. Copy and paste text boxes to create new events, and modify existing text boxes as necessary. Move them by left-clicking and dragging to the right location. Copy and paste the lines that connect the events to the timeline, and move them as required.
4. Delete the instructions. Once you are familiar with how to manipulate the template, delete the instructions by selecting the text box and hitting 'DEL.'
5. Save the file. Select 'File,' and then 'Save As...', and give the file a name and location. In Excel 2007, select the Office Button and then 'Save As.'

Read more ►

How to Align the Header in Excel 2007

1. Open Excel 2007 and click the 'Insert' tab. Select 'Header And Footer.'
2. Click the 'Go To Header' button. (If you cannot see the 'Go To Header' button, click 'Header Footer Tools' to display the appropriate options.) Notice the three sections provided in the header section.If you type header text in the first section, it will be left aligned. Text in the second section will be centered. Text in the right section will be right-aligned.
3. Navigate to each section by pressing the 'Tab' key on the keyboard. For example, if you want your header text to be centered, press the 'Tab' key once and type your header in the second section. To navigate back to a previous section, press Shift Tab.

Read more ►

How to Make a Column Chart in Excel

1.
Find the file that contains your data and open it in Excel. If you still need to enter your data, open a new workbook instead. Input your data into a spreadsheet in the new workbook. As an example, we will create a small table containing data on the number of books bought at a yard sale. We will categorize the books by genre.
2.
Highlight the cells in the spreadsheet that contain your data. For our example, the cells A1-B8 have been highlighted.
3.
Choose the “Column” chart option from the “Insert” menu on Excel’s toolbar. Pick the type of column chart that you want to create. We will choose the side-by-side, non-stacked 3-D column chart for our example.
4.
Review the column chart that you have just created. Make any desired modifications to the chart. You can change the colors, wording of the title, location in the spreadsheet, and font used in the chart. Don’t be afraid to experiment! If you do make a change that you don’t like, just use the “Undo” option to get rid of the change.
5.
Save your file as an Excel workbook.

Read more ►

How to Make Box Whisker Plots in Excel 2007

1. Open your Excel data. This instructional will assume that your first data column is in column 'A,' your first data value is in row '1,' and all your columns have 'n' data points.
2. Create new rows for your maximum, upper quartile, median, lower quartile and minimum values.
3. Calculate these statistics by entering the following values under your 'A' column:=MAX(A1:An)=PERCENTILE(A1:An,0.75)=MEDIAN(A1:An)=PERCENTILE(A1:An,0.25)=MIN(A1:An)
4. Copy and paste the same formulas to calculate statistics for your other columns, changing the letter for the corresponding column.
5. Select all the fields with your new statistical calculations. You can press 'CTRL' to select from more than one column.
6. Click the 'Excel Chart Wizard' button.
7. Select the 'Stock Open-High-Low-Close' diagram.
8. Click 'Next.' In the Data Range tab, click on 'Series In: Rows.'
9. Click 'Finish.' A box and whisker chart will display.

Read more ►

How to Create a Column Chart to Show Graphic Representation of Expenses on MS Excel

1. Type your data into a worksheet. Click on a cell, then type your data into the cells. In order for the column chart to work properly, you should enter your data in columns. For example, if you are comparing heights in inches of three people you might put 'John' into cell A1, 'Jane' into cell A2,'Bob' into cell A3 '72' in cell 'B1,' '69' in cell 'B2' and '75' in cell 'B3.'
2. Highlight the cells with your data by left clicking on the top left of the cells then dragging the cursor to the bottom right of the cells.
3. Click on the 'Insert' tab.
4. Click on the column' tab, then click on the column sub-type you want. For example, click on a '2-D Column' icon. Excel will insert a chart into your worksheet.

Read more ►

How to Delete Filtered Items in Excel 2007

1. Open Excel 2007 and then open the workbook containing the data you want to filter.
2. Select the range of cells you want to filter or click inside of a cell that is within the range of cells you want to filter.
3. Go to the 'Data' tab and click 'Advanced' in the 'Sort and Filter' group.
4. Select 'Filter the List, in Place' if you want to filter the list and delete duplicate items within the current worksheet. Choose 'Copy to Another Location' if you want Excel to delete the duplicate items and copy the remaining filtered items to another area on the worksheet.
5. Select the 'Unique Records Only' check box and click 'OK.' Excel will filter the list and delete any duplicate records it finds.

Read more ►

How to Embed a Word Document in Excel

Create from a File Option
1. Open Excel and the spreadsheet to embed the Word document in. Click on the 'Insert' tab, and then click 'Object' in the Text group. The Object dialog box appears.
2. Click on the 'Create from File' tab, and then click the 'Browse' button. Navigate to the file you want to add and click 'Insert.'
3. Choose any optional options. If you want to save room in the spreadsheet, click the 'Display as Icon' checkbox. This inserts a Word document icon. You can double-click on the icon to display the file. If you plan on continuing to work on the Word file in Word, but want the file information to update automatically in the Excel spreadsheet, click the 'Link to File' checkbox.
4. Click 'OK' to add a Word file to Excel.
Create from New
5. Open Excel and a spreadsheet to work with. Click on the 'Insert' tab, and then click 'Object' in the Text group.
6. Select the 'Create from New' tab. Select 'Microsoft Office Word Document' from the Object Type list (you will need to scroll to find it).
7. Click 'OK' to insert a Word document window in the spreadsheet. You can type in the document window as you would in a Word document. Notice that the Excel Ribbon has changed to reflect Word tools instead of Excel tools.
8. Type your document. You can insert graphics, use WordArt, add styles or apply other features available in Word. To return to the Excel spreadsheet, click off the document window. You can expand the Word document window in Excel by selecting the document window and dragging any of the handles. To return to the Word document, double-click the Word document window.

Read more ►

How to Find Hidden Columns on the Excel 2007 Document Inspector

1. Open Microsoft Excel.
2. Click the 'Office' icon located in the upper-left corner of the screen.
3. Select 'Prepare.'
4. Click 'Inspect Document.'
5. Check the box next to 'Hidden Rows and Columns.'
6. Click 'Inspect.'

Read more ►

How to Open a Xlxs File

1. Open your web browser and go to the following URL:
http://us20.trymicrosoftoffice.com/product.aspx?re_ms=oofamily=officeproculture=en-US
2. Download the free 60-day trial version of Microsoft Office Pro 2007, which includes Excel 2007.
3. Follow the onscreen install-wizard instructions to install the software on your computer.
4. Open Microsoft Excel and click on the Office start button in the upper-left corner of the window. From the list of options, select 'Open.'
5. Select the xlxs file that you wish to open and click the 'open' button at the lower right of the window. Excel 2007 will open the file.

Read more ►

How to Do Error Bars on a Line Graph

1. Open the Excel 2010 spreadsheet that holds your line graph.
2. Click anywhere on the line graph to select it, then click the 'Layout' tab on top of the window, near the right end.
3. Locate the drop-down box in the 'Current Selection' area of the ribbon. Click the box and choose the data series that you want to display with error bars. To display all of your data series with error bars, choose 'Plot Area.'
4. Click the 'Error Bars' button in the 'Analysis' area of the ribbon. From the menu that appears, choose to add error bars for the standard error, for one standard deviation or for a 5 percent error on each value. If you want more precise control, choose 'More Error Bar Options,' then choose a data series from a small window that appears, as you can only add error bars this way for one series at a time. If you choose this option, another window appears.
5. Click the radio button next to 'Both,' 'Minus' or 'Plus' under the 'Direction' heading to determine which way your error bars will appear from the line on the graph. Under the 'End Style' heading, choose either to add or not to add a cap on the end of the bar.
6. Select your method for determining the error bar size under the 'Error Amount' heading. If you choose 'Fixed Amount,' 'Percentage' or 'Standard Deviation,' enter an amount into the box next to the option. You can also choose 'Standard Error,' but this option has no entry box, as the error bar sizes are determined solely by the values.
7. Change the appearance of the error bars from the 'Line Color,' 'Line Style,' 'Shadow' and 'Glow and Soft Edges' menus from the left side of the window. Each of these menus has numerous options to specify the exact look of the bars. Click 'Close' at the bottom of the window when done. Your error bars appear on the line graph.

Read more ►

How to Rank Without Duplicating in Excel 2007

Creating the Formula
1. Start Excel and open up the data range you want to use. For this example, we're assuming that the data values to be ranked are in column A, starting in column A2.
2. Enter the following formula in cell B2: =RANK(A2,$A$2:$A$10) COUNTIF($A$2:A2,A2)-1. This formula ranks the data, using the value in A2 as the seed value, going through the ranks from top to bottom. The COUNTIF in the second part of the formula increments the rank number by 1, EXCEPT if the rank value is the same.
3. Copy the formula in cell B2 through the entire range of cells from B3 to B10.

Read more ►

How to Create a Gantt Chart Using Excel 2003

1. Type a schedule into four columns in Excel. Type the names of milestones for your project in column 'A,' then type the start dates in column 'B,' then type the duration in days in column 'C' and the project end date in column 'D.'
2. Click the 'Chart Wizard' button, then click the 'Bar Chart' on the left-hand side. Click 'Stacked Bar Chart' as the chart subtype.
3. Click the 'Series' tab.
4. Click 'add' to add a series from your spreadsheet. Type a name for one of the series in the 'Series name' text box -- for example, type 'Start Date.' Type the location for your series into the 'Values' box -- for example, if your start dates are in cells 'B1' to 'B10,' type 'B1:B10.'
5. Repeat Step 4 to add the name and location of the 'Duration' series.
6. Click the 'Category Axis' button and highlight the tasks you listed in column 'A.' This adds labels on the left-hand side of your chart. Click the 'Finish' button.
7. Drag the bottom right corner of the chart until the chart fills the screen.
8. Right-click the 'X' axis on the chart. Click 'Format Axis,' then click '10' for the font size. Click 'OK.'
9. Right-click the 'Y' axis on the chart. Click 'Format Axis,' then click '10' for the font size. Click 'OK.'
10. Right-click the blue bars on the chart, then click 'Format Series.' Click the 'None' radio buttons next to Border and Area. Click 'OK.'
11. Right-click on the 'Y-axis' label, then click 'Format Axis.' Click the 'Scale' tab, then click the 'Categories in Reverse Order' check box. Click 'OK.'

Read more ►

How to Use Excel Tornado Diagrams

1. Open your spreadsheet and highlight the data you want to include in your tornado diagram. Go to 'Insert' and select 'Bar,' then 'Clustered Bar.'
2. Right-click on the horizontal axis and select 'Format Axis.' Select 'Axis Value' under 'Vertical Axis Crosses,' then enter your base case value.
3. Select the vertical axis for your diagram, then check next to 'Categories in Reverse Order' and click 'Low' on the 'Axis Labels' menu.
4. Click one of the bars to open a pane labeled 'Series Options' and slide the button under 'Series Overlap' over to the far right. Click 'Finish.'

Read more ►