1. Open a new workbook in Microsoft Excel.2. Type the list of numbers you would like to convert to text down a column.3. Type =Text(cell,'units') in the next empty column or row, where 'cell' is the cell containing the number you want to convert and 'units' is the unit you want the number to be expressed in. For example, if you have 10 in cell A1 and want to express it in U.S. dollars, type =text(A1,'$0.00') in cell B1.4. Click on the cell containing the formula and go the lower right-hand corner of the cell until your mouse pointer turns into sign. Drag the formula down the column to...
Browse » Home » Archives for August 2012
Tuesday, August 28, 2012
Monday, August 27, 2012
How to Create a Drop
1. Select the data you want the drop-down menu to contain. This can be any list of information. Highlight those cells and click the 'Data' menu. Select 'Sort' and 'A-Z.' This will alphabetize your list.2. Place your cursor in the cell where you want your drop-down list located. Click the 'Data' menu and the 'Data Tools' menu. In the 'Data Tools' menu, select 'Data Validation.'3. Choose 'List' in the 'Allow' menu of the 'Data Validation' dialog box. Click the arrow beside the 'Any Value' option to view the options where 'List' will be found.4. Click the button at the very end of the 'Source'...
How to Use a Chart Wizard in MS Excel 2007
1. Open the Excel workbook with the data that you wish to chart.2. Select all the cells containing the relevant data. Press 'CTRL' and 'A' to select them all.3. Select 'Chart' from the Insert menu. This will open the Chart Wizard.4. Select a chart type under 'Standard Types.' If you are unsure how a specific chart will represent your data, click it to view a preview. Click 'Next' when you are done.5. Confirm the data range to include in your chart. The information is already filled in to show the cells you selected in Step 2, but you can switch around the order in which your spreadsheet's...
How to Add a Header and Footer in Excel
1. Create or open the file you will be working with. A header and footer can be changed in an existing file or added to a new or existing file.2. Determine if you will use a header, footer or both. Also decide what you want each of these to look like and say. These steps show how to add both a header and footer so choose the steps suitable to what you need.3. Go to 'File' in the menu bar and select 'Page Setup.' A new box with options will appear. If you do not see 'Page Setup' in your options from the drop-down menu, click the arrow at the bottom of the 'File' list to see more options.4....
Sunday, August 26, 2012
How to Create a Timeline Using Word
Create a Timeline in Word 20031. Open the Word document on which you want to create a timeline. Go to the 'File' menu, click on 'Page Setup' and go to the 'Margins' tab. Select the 'Landscape' orientation option and click 'OK.'2. Go to the 'View' menu, point to 'Toolbars' and select 'Drawing' if it is not already selected. Click the rectangle auto shape in the drawing toolbar and draw a long, narrow rectangle horizontally onto the Word document, leaving room above and below it for text.3. Right-click the shape and select 'Format AutoShape.' The 'Format Shape' dialog box will open. Go to...
How to Print Bar Codes in Microsoft Excel
1. Launch Microsoft Excel from the Microsoft Office folder in your Start menu.2. Click the 'Tools' drop-down menu. Select the 'Macro' tab, and choose 'Security.' Set it to 'Medium.' If you use Office 2007, click on the Microsoft Office button at the top left corner and select 'Excel Options.' Click on 'Trust Center Settings' under the Trust Center category. Click on 'Macro Settings.' Put a check mark next to 'Enable all macros.'3. Click the 'File' drop-down menu and select 'New.' Select 'Enable Macros' when you get a prompt. For Excel 2007, click on the Office button and select 'New.'4....
How to Print Mail Labels From Excel
1. Open Excel 2010 and select the 'Mailing' tab on the ribbon. Select 'Start Mail Merge.' Click 'Labels.' Select the label vendor and product number. Click 'OK.' A grid of the label appears in your Word document.2. Click 'Select Recipients.' Select 'Use Existing List' from the drop-down list. Browse your files and locate the Excel workbook containing the mail labels. Click the workbook and select the worksheet containing the mail label information. Click 'OK.'3. Format the labels by clicking the 'Insert Mail Merge' field. From the drop-down list, select a field name. It appears in the first...
Saturday, August 25, 2012
How to Transform a Spreadsheet into a Web Page in Excel 2003
1. Fill out your Excel 2003 worksheet. You will create the Web page from this version of the worksheet.2. Format your worksheet. Make sure that your worksheet is formatted so it looks good enough to appear on the Internet. Save the file without exiting.3. Under 'File' from the toolbar at the top of the Excel window, click 'Web Page Preview' on the dropdown menu. This will preview how the page will appear online. You may have to make formatting changes; if so, preview until you're finished.4. Once the preview satisfies you, click 'Save as Web Page' under 'File.' This will save your spreadsheet...
How to Evaluate Multiple Columns in Excel 2003
1. Choose a formula or function that you want to use. For example, use the 'Sum' function to add columns or the 'Average' function to calculate the average of all the numbers.2. Type the function into a blank cell. For example, type 'Sum(' without quotes to start the Sum function.3. Type the column references, separated by a colon, then close the function with a closing parenthesis. For example, type 'a:b)' without quotes. Your function should look like '=Sum(a:b)'.4. Press the 'Enter' key or click out of the ce...
How to Make an Invoice Using Excel
1. Navigate to the Excel templates website (see References below for link).2. Select a template option and examine it for relevance to your needs. For example, click on 'Basic Invoice,' 'Sales Invoice,' or 'Service Invoice.' This brings up a window with a 'Download' button. Click on the button to download the template to your computer.3. Locate the downloaded file on the computer by using Windows Explorer. To run Explorer, click on the 'Windows' button in Windows 7 or Vista or the 'Start' button in Windows XP, then click on 'Run.' Type 'Explorer' into the text box, then click 'OK.'4. Double-click...
Friday, August 24, 2012
How to Find Standard Deviation on Excel 2007
1. Open Excel 2007 and select the 'Formulas' tab. Click the 'Statistical' button. A drop-down list appears.2. Click 'Stdev.' The Standard Deviation function arguments window appears.3. Type the first value in your standard deviation function in the 'Number 1' field. Type the second value in your standard deviation function in the 'Number 2' field. Click 'OK.' The standard deviation function is displayed in the ce...
How to Make a Stem Leaf Plot in Excel 2007
1. Rename a blank Excel worksheet “Data” by clicking the bottom tab for the worksheet and typing the new name.2. Rename another blank Excel worksheet in the workbook “Stem” by clicking the bottom tab for that worksheet and typing the new name.3. Enter your list of numbers in column A of the “Data” worksheet.4. Press “Alt” and “F11” at the same time to open the visual basic editor.5. Double click “This Workbook” under Microsoft Excel Objects in the left navigation pane to open a blank code window.6. Paste the following VBA code into the blank window:Sub StemAndLeaf()dataColumn = 1'Clean...
How to Reduce the Size of a Large Excel 2007 File
1. Press 'Ctrl' and 'End' at the same time. This will bring you to the bottom right cell of the worksheet.2. Select all the rows between your real last used row, and the row that Ctrl End brought you to. To select a row, click on the row identifier (for example, 'A.'). To select multiple rows, hold down the 'Shift' key and click the first and last row. Press 'Delete.'3. Select all the columns between your real last used column, and the column that Ctrl End brought you to. Press 'Delet...
How to Use Scatter Plots in Excel
1. Open the Excel 2010 file containing the data you want to make into a scatter chart.2. Arrange the data so the first row for each column has a header in the top row. The header is just a word that describes the data. If you need to add a row to accommodate the headers, right-click the number on the left side of the top row and select 'Insert' from the pop-up menu.3. Arrange the information so that the leftmost column holds the values you want to use on the X-Axis. You can move a column by right-clicking on the letter at the top of the column and choosing 'Cut' from the pop-up menu. Then,...
How to Generate a Random Number in a Range in Excel
1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files or create a new blank spreadsheet into which you want to generate a random number within a range that you designate.2. Select the cell or multiple cells that you want to generate the random number into. You can use the SHIFT or CTRL keys on your keyboard to select multiple cells at the same time. The cells that random numbers will be generated into will be outlined by a black heavy line.3. Type '=RANDBETWEEN' (no quotes) into the 'Formula' textbox near the top of the Excel screen.4. Continue to type the rest...
Thursday, August 23, 2012
How to Make a Bar Chart in Excel
1. Open the Excel file that contains your data. If you have not created a file with your data yet, open a new Excel workbook and do that now. In this example, there is e a small list of data detailing how many people chose various animals as their favorite to use as an example.2. Use your mouse to highlight the cells that contain your data. In this example, cells A1 through B7 are highlighted.3. Choose the “Insert” menu from the toolbar in Excel. Now choose the “Bar” chart submenu. Pick which type of bar chart you would like to create. For the example, use the simplest 2-D version.4....
How to Use Microsoft Excel Date Difference Function
1. Type a date into a cell. For example, type '10/02/2010' into cell A1.2. Type a second date into a cell. The second date should be later than the first date. For example, type '10/06/2010' into cell B1.3. Type an interval into another cell. For example, type 'd' into cell C1.4. Click on another cell and type the DATEDIF formula, inserting the cell locations of the DATEDIF components. In this example, type '=DATEDIF(A1,B1,C1)'.5. Press the Enter key for the result. In the example, the result returned will be '4,' indicating there are four days difference between the two dat...
How to Set Margins in Powerpoint
Set Margins for Print1. Open the presentation in Microsoft PowerPoint.2. Select 'File' and 'Page Setup' from the toolbar. Select an option from 'Slides sized for.'3. Use the scroll bar to adjust the height and width or type it in. Then click 'OK.'Set Margins for Text Boxes and AutoShapes4. Select the text box or AutoShape on your slide.5. Double-click the selection to open the 'Format Text Box' or 'Format AutoShape' dialog box.6. Go to the 'Internal margin' section under the 'Text Box' tab. Then change the left, right, top and bottom margins and click 'O...
How to Convert Dates in Excel
1. Open the worksheet.2. Click the cell or a selection of cells.3. Click the 'Home' tab on the command Ribbon.4. Click the Dialog Box Launcher in the lower right corner of the 'Number' group. The dialog box opens.5. Click the 'Number' tab. A list of categories displays.6. Click 'Date.' A list of date formats displays in the 'Type' box. Examples include March 14, 2001 and 14-Mar-01.7. Click the date format.8. Click the down-arrow for the 'Locale (Location).' A menu includes 'English (United States),' for example. The formatted date can translate into other languages.9. Click the...
Wednesday, August 22, 2012
How to Make Clustered Histograms on Excel
1. Open your Microsoft Excel worksheet that contains the data for your chart. Label a new column as Bin Range, and type the groups of values that you want to use as your horizontal axis. For example, if you're counting the frequency of test scores, type '2. Label a new column 'Frequency1' to the right of your Bin Range column. Count the number of occurrences for each of your groups of your first data set and type them into the 'Frequency1' column. Repeat the process for your second data set and label the column 'Frequency2'.3. Highlight your 'Frequency1' and 'Frequency2' columns and click...
Tuesday, August 21, 2012
How to Change Interval of Value Axis in an Excel Chart
1. Start Microsoft Excel 2007 and open a spreadsheet that contains a chart to which you would like to change the interval of the value axis.2. Select the entire chart by clicking in the white area of the chart. You will then see a light blue outline around the chart indicating you have selected the entire chart.3. Choose the 'Format' tab at the top of the Excel screen and location the 'Current Selection' group. The 'Current Selection' group is the first group that appears on the 'Format' ribbon.4. Click the 'Chart Elements' drop-down list and select '(Value) Axis' from the list. The 'Chart...
How to Convert Excel Formulas to Hard Numbers
1. Highlight the cell(s) with that contain formulas you wish to convert to hard numbers.2. Right click your mouse and select 'Copy'.3. Right click again and select 'Paste Special'.4. Select the 'Values' option in the Paste section of the Paste Special box.5. Click 'OK.'6. Hit the Enter key. The cell(s) selected will now display numbers rather than formul...
How to Use the '' Symbol in the Header in Excel 2007
1. Open an Excel 2007 document and click the 'Insert' menu.2. Click 'Header and Footer.'3. Type the text you want to include in the 'Header' box. When typing the symbol, type '' two times. Microsoft Excel will now recognize one of those ampersands and include it in the head...
Monday, August 20, 2012
How to Create an Excel Macro for a Frequently Used Formula
1. You will need to have the Developer tab displaying. If it is not displaying, click on the Microsoft Office Button (upper left corner red, blue, yellow, green logo). Click on the Excel Options button, and then under the Popular category, click to fill the box next to 'Show Developer tab in the Ribbon.' Click OK to exit. You will need to adjust the security level to run macros, so on the Developer tab, in the Code group, click on Macro Security. Fill the box next to 'Enable all macros (not recommended, potentially dangerous code can run).' Click OK. It is fine to run your own macros.2....
How to Merge Cells in Excel With the Keyboard
1. Navigate to the first cell in an open spreadsheet you want to merge by using the arrow keys on your keyboard.2. Select the adjoining cell or cells by holding down the 'Shift' key and pressing one or more of the arrow keys on the keyboard. You should see an outline of the cells that you will merge.3. Press the 'Alt' key to display number and letter key tips in Excel.4. Press 'H' to display the key tips for all commands in the 'Home' tab.5. Press 'M' to open the merge menu. Select one of the merging options: press 'C' to 'Merge and Center,' press 'A' to 'Merge Across' or press 'M' to...
Sunday, August 19, 2012
How to Calculate Time in Excel 2007
1. Open the Excel 2007 document in which you want to include time calculations.2. Enter headings for your calculation columns. For example, in a new Excel 2007 spreadsheet, you might type “Start” in cell A1, “End” in cell B1, and “Total” in cell C1.3. Enter start and end times in the cells under the first two headings you added. For example, type 11:30 AM in cell A2 and 12:15 PM in cell B2. Always enter AM and PM after the time, unless you are using 24-hour clock time.4. Insert formulas in the third column to calculate difference in times: If you have start and end times in cells A2 and...
How to Use Excel's Intercept Function
1. Find the function field at the top of the page, with the = sign to the left. This is where you can program a cell value. If the function field is not immediately available, you can go to 'Insert' and select 'Function.'2. In your function field, add the operator INTERCEPT.3. Start a parenthetical statement after INTERCEPT. Your values and parameters will all be inside a set of parentheses.4. Add a cell range for your 'y axis.' The most common arrangement might be a range of values for a y axis in the A column of the spreadsheet, and a range of values for an x axis in the B column. In...
How to Create a Sales Invoice
Excel 20101. Open Excel 2010. Click the 'File' tab and select 'New.' Click the 'Invoices' category in the left task pane. Review the available sales invoices. Download the sales invoice by clicking the invoice image and the 'Download' image. The invoice opens in Excel 2010.2. Right click the default logo image and select 'Change Picture.' Browse your files and select your logo. Click the 'Open' button. Your image replaces the sales invoice template logo.3. Highlight the default customer information on the template and type your custom information. Save the changes by clicking the 'Save'...
Saturday, August 18, 2012
How to Write Percentage Formulas in Excel
1. Calculate the percent of a total. Choose a cell for the percentage formula and enter the '=' symbol to activate the formula in Excel. Highlight the cell with the part, then enter the '/' symbol, and then select the cell with the total. For example, if the total lies in cell A10 and the part lies in A3, the formula is '=A3/A10'.2. Calculate difference in percent between two numbers. Choose a cell for the percentage formula and enter the '=' symbol to activate the formula in Excel. Enter the opening parenthesis symbol, or '('. Highlight the cell with the first number, then enter the '-'...
How to Use Text Wrap in Excel
1. Open a new workbook in Excel by choosing 'File,' and then 'Page Setup.'2. Select the small square at the top left corner of the screen of the new page. This highlights the entire workbook for formatting. If you want to format only a single cell, select that cell and continue with Step 3.3. Right-click your mouse and select 'Format Cells,' 'Alignment' and then click the 'Wrap Text' box listed under 'Text Control.'4. Resize the width of any Excel columns as necessary. Type in the text you need into each column of the spreadsheet. Whenever you get to the right margin of a particular cell,...
Friday, August 17, 2012
How to Open a Dbf
1. Navigate to the folder containing your DBF file.2. Right-click the DBF.3. Drop down to the 'Open With' submenu.4. Select 'Microsoft Office Excel' from the list of progra...
Thursday, August 16, 2012
How to Use Freeze Frame in Excel
1. Click on the cell after the row or column you want to freeze. If you want to freeze column A, then put your cursor in column B. If you want to freeze row 1, then put your cursor in row 2. Combine these if you want to freeze a row and column.2. Click 'View' then 'Window.'3. Select 'Freeze Pane...
How to Protect a Sheet in Microsoft Excel 2003
1. Access the sheet protection menu. To access this menu, scroll to the “Tools” tab on the command bar and select “Protection.” Under the sub-menu that opens, select “Protect Sheet.”2. Set the sheet protect options. Make sure that you check the box labeled “Protect worksheet and contents of cells” to enable protection. Under the scroll menu in the middle of the sheet protection properties menu, you can check the corresponding boxes for the features you want disabled when unauthorized users are viewing the file.3. Add a password to your worksheet. To add password to your worksheet, simply...
How to Make Text Flash in Excel
1. Open the Microsoft Excel 2010 file in which you want to make the text flash. Press 'Alt' and 'F11' to open up the VBA console.2. Right-click the 'ThisWorkbook' entry on the left side of the VBA console. Move your mouse over 'Insert' and choose 'Module.'3. Double-click the 'ThisWorkbook' option. Copy the following code and paste it into the white space on the right side of the screen:Private Sub Workbook_Open()BlinkEnd SubPrivate Sub Workbook_BeforeClose(Cancel As Boolean)NoBlinkEnd SubThis code will start and the blinking text when you open this workbook, and stop the blinking text when...
Wednesday, August 15, 2012
How to Sort in Excel 2003
1. Open Excel 2003 and select a workbook containing data that needs to be sorted. Click 'File' on the menu bar and select 'Open.' Browse your computer for the workbook. Click the workbook and select 'Open.' The workbook opens.2. Highlight the range of data that needs to be sorted. Click the first cell in the range you want to sort by. Click the 'Ascending' button on the Standard toolbar. The data is sorted in ascending order by the values in the column.3. Highlight the range of data you want to sort. Click 'Data' on the menu bar. Select 'Sort.' The 'Sort' dialog box opens. Select a column...
How to Teach Yourself Microsoft Excel Virtually
1. Browse through Excel tutorials on the official Microsoft Excel website. Choose 'Getting Started With Excel 2010' if you are a total beginning, or 'Excel Skills Builder' to augment the skills you already have.2. Compare private databases of Excel tutorials. Examples include 'Excel-2010.com,' 'Excel 2010 Tutorials' and 'Lynda.com.' Although the accuracy of non-Microsoft materials isn't guaranteed, private websites often provide other users' personal experiences, which may help you work through difficulties better than straight instruction.3. Enroll in a formal online Excel 2010 training...
How to Control Multiple Users on One Excel Spreadsheet
1. Open the Excel spreadsheet you wish to share among multiple users.2. Click 'Tools' and select the 'Share Workbook' option. A pop-up window will appear.3. Place a check mark in the check box at the top of the 'Editing' tab on the Share Workbook pop-up window.4. Click the 'Advanced' tab at the top of the 'Share Workbook' pop-up window. The window will change to present a variety of customizations for controlling multiple users on the Excel spreadsheet.5. Choose desired options on the 'Advanced' tab. You may change the history log time frame and control how updates are handled.6. Click...
How to Create Mailing Labels in Microsoft Word
1. Open Microsoft Word 2010 and create a new document if one hasn't already been created. You can create a new document by clicking 'File' then 'New.'2. Click the 'Mailings' tab, then 'Labels.' The 'Envelopes and Labels' window will open.3. Type the address you wish to use on your labels in the address box. Choose if you want a whole sheet of the same label or just a single label printed in the 'Print' section.4. Click the 'Options...' button near the middle bottom section of the window to choose the labels to which you want to print. Under 'Label Information' select the brand of labels...
How to Make the Top Row Scroll in Excel
1. Open up to the worksheet in the Microsoft Excel workbook.2. Click the 'View' tab.3. Click the 'Freeze Panes' icon. Select 'Freeze Top Row' from the menu.4. Click the 'Windows Office' orb logo in the top left corner. Use the save options on the menu, if you want to make the top-row scroll permane...
How to Figure Percentage Using Excel
1. Click the 'Start' button on the taskbar, point to 'All Programs' and then click 'Microsoft Excel.'2. Click in an empty cell on the spreadsheet document in which you want the percentage value to be displayed (for example, B12).3. Type '=(total_value/number_of_values)*100' in cell B12 to get the percentage. Here, replace total_value with the total sum of the numbers whose percentage you want to calculate and number_of_values with the number of individual values. For example, to calculate the percentage of 12, 22, and 32, type '=(66/3)*100'. Here, 12 22 32=66 and there are 3 individual values...
Tuesday, August 14, 2012
How to Adjust Page Breaks in Excel 2007
1. Open the worksheet you want to print.2. Click 'View' then 'Page Break Preview.'3. Click on the page break and drag the break to the place you want the break to ...
Monday, August 13, 2012
How to Set Two Print Areas Using an Excel 2007 Worksheet
Printer Method1. Select your first desired print range by highlighting the cells within your worksheet; for example A1:H15.2. Hold down the 'Ctrl' key while highlighting the second set of cells to print--for example N5:V15--resulting in two separate highlighted areas.3. Select the 'Page Layout' tab, click on 'Print Area' and select 'Set Print Area.'4. Press 'Ctrl P,' a shortcut that brings up the Print Dialog Box.5. Verify the output printer displayed is the correct printer and click the 'Properties' button.6. Look through your different tabs and options for a setting asking you to...
How to Insert the Same Drop
1. Enter the list items in a column on the spreadsheet where you will not need to enter other data, such as on the far right or bottom of the page. Enter the items in the order you want them to appear in the list, one item per cell. Make sure there are no blank cells between the items.2. Select all of the cells into which you want to insert the drop-down list. If the cells are contiguous in one row or column, you can select them by clicking the first cell and dragging your mouse down or across the row or column. If they are in noncontiguous cells, press and hold the 'Ctrl' key while you click...
How to Center in a Row on Excel for Microsoft 2003
1. Select the row of text that you want to center by left clicking on the first cell and then dragging the cursor to the right.2. Right-click and then select 'Format Cells' from the pop-up window.3. Select the 'Alignment' tab.4. Click on the arrow next to the 'Horizontal' or 'Vertical' text alignment tab. If you want the text centered both horizontally and vertically, then choose both options.5. Click on 'Center Across Selection.'6. Click on 'O...
How to Create Free Receipts
1. Open a Microsoft Excel spreadsheet. Select 'New'. Select a free sales receipt template from the list of available spreadsheet templates.2. Fill in or delete the specified fields for company information, such as company name, address, company logo, and receipt number.3. Enter in the sales information for each item, which includes quantity, item number, item description, and the unit price.4. Enter a value in the discount cell if a discount applies and the discount is a flat number. If the discount is in the form or a percentage off, then enter '=xy*z' in the cell where x = the column...
Saturday, August 11, 2012
How to Convert Numbers Into Letters in MS Excel
1. Open your spreadsheet in Microsoft Excel.2. Click 'Tools' in the top menu bar, select 'Macro,' and choose the 'Visual Basic Editor' option. If you use Excel 2007 or later, click the 'Developer' tab and click the 'Visual Basic' button instead.3. Click 'Insert' in the top menu bar of the Visual Basic Editor and select 'Module.'4. Copy and paste all of the code shown below:Option ExplicitFunction SpellNumber(ByVal MyNumber)Dim Dollars, Cents, TempDim DecimalPlace, CountReDim Place(9) As StringPlace(2) = ' Thousand 'Place(3) = ' Million 'Place(4) = ' Billion 'Place(5) = ' Trillion 'MyNumber...
How to Make a Frequency Chart
1. Create a dataset of student grades; include student names and the grades 50, 60, 70, 80, 90 and 100. Enter or sort the grades in ascending order.2. Create a bin range of 50, 60, 70, 80, 90 and 100 and enter or sort it in ascending order.3. Go to 'Data Analysis.' In older versions of Excel, go to 'Tools,' 'Data Analysis.'4. Click on 'Histogram,' then click 'OK.' A frequency chart is also considered a Histogram.5. Select the 'Input Range' of the histogram. Click on the box beside the field.6. Highlight the 'Input Range' which is the 'Grade' column. Click on the box again to return...
How to Turn Off Calculations in Excel 2010
1. Open Microsoft Excel and click 'Formulas' in the Ribbon at the top of the Excel window.2. Click 'Calculation Options' on the far right side.3. Select 'Manual' to disable auto-calculation. If you want Excel to recalculate your spreadsheet while auto-calculation is disabled, you will need to click 'Calculate Now,' also located under 'Calculation Options.' When you are ready, you can re-enable auto-calculati...
How to Do a Scattergraph in Excel 2003
1. Click 'Start,' then 'All Programs,' then 'Microsoft Office,' then 'Microsoft Excel 2003.'2. Click 'File,' then 'Open.' Locate the Excel document that contains the data in it which you wish to make a scatter chart from.3. Highlight the cells that contain the data.4. Click 'Insert,' then 'Chart' to launch the Insert Chart wizard.5. Select 'XY (Scatter)' foam the list of options then click 'Next.' You can 'Press and Hold to View Sample' to see what the graph will look like. Click 'Next' then name the axes and the chart. Click 'Finish' when you have finished creating the gra...
Subscribe to:
Posts (Atom)