1. Open a blank worksheet in Microsoft Excel.2. Create a data table. For instance, enter time values in column A, such as the months of the year. In column B, enter a column heading for your first data series, such as number of items sold, followed by the data values. Enter a second data series in column C, such as average price, with each data value lining up with a value in column A.3. Highlight all of the data you want to plot in a chart, including both data series.4. Click the 'Insert' tab. In the 'Charts' group, select the chart type you want to use for the first data series. For...
Browse » Home » All posts
Saturday, June 15, 2013
How to Make a Line Graph in Microsoft Excel
1. Arrange the data in either rows or columns. Excel makes the decision as to how to best graph the line based on the data input you provide. You need at least two sets of data to create the axes for your chart. For example, build a line graph using one row or column that provides time periods, such as months or quarters, and the other row or column listing gross sales.2. Select the data in the rows or columns to include in the line chart. Click and drag your mouse across the data in the Excel spreadsheet to include it.3. Click the Insert tab and review the available types of Chart. Select...
How to Delete a Macro in Excel
1. Start Microsoft Excel 2007, and open a spreadsheet from your files that contains at least one macro that you want to delete.2. Select the 'Developer' tab from the top of the Excel screen. The 'Developer' ribbon will be displayed just under the tab.3. Find the 'Code' group in the 'Developer' ribbon and click the 'Macros' button. The 'Macro' dialog box will open onto your Excel screen.4. Choose the name of the macro you want to delete from the list that appears in the 'Macro' dialog box. The macro name will be highlighted in black once it is selected.5. Click the 'Delete' button on...
Friday, June 14, 2013
How Do I Exit From the Header in Office 2007 Windows Vista?
1. Look at the top of your Word program window and locate the text 'Header and Footer Tools.'2. Under 'Header and Footer Tools,' click 'Design.' The 'Design button will be immediately below the words 'Header and Footer Tools.'3. Click the red 'X' on the far right side of the Design menu that says 'Close Header and Footer,' under ...
How to Make a Second Line in One Cell in MS Office Excel on Mac
1. Position your cursor inside the cell at the exact place you want to create a new line, such as at the end of the first line.2. Hold down the 'Option' and 'Command' keys on your keyboard.3. Press 'Enter.' Release the 'Option' and 'Command' keys. You now have a new li...
How to Calculate a Year
1. Click on a blank cell where you want to enter your formula calculation and display the year-to-date average.2. Begin your formula calculation by clicking the 'Average' function. You can find this formula in one of several places in different versions of Excel. In Excel 2010, it is easily accessible on the 'Auto Sum' menu, available on both the 'Home' tab and the 'Formulas' tab. Or you can always manually type in '=AVERAGE().'3. Select the cells you want to use in the average. If they are all in the same row or column, click and drag your cursor across all of the cells you want. If they...
How to Tab Over in Excel 2003
1. Launch Microsoft Excel 2003.2. Click 'Tools' at the top of the window.3. Click 'Options.'4. Click the 'Transitions' tab at the top of the window.5. Click the box to the left of 'Transition Navigation Keys' to remove the check mark, and then click 'O...
How to Change the Display of Axes in Excel
1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to change the display of the axes.2. Click the chart that you want to change the display of the axes so it is selected. The chart will have a light blue border surrounding it, indicating that it is selected.3. Choose the 'Axes' button in the 'Axes' section of the 'Layout' ribbon. A drop-down menu will appear.4. Point to 'Primary Horizontal Axis' to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed...
How to Import a Web Page to Excel 2007
Import Data from Web Page1. Open both your Internet browser and Microsoft Excel 2007 program. Go to the web page that you want to import into Excel.2. Go the Data tab on the user interface in Excel. In the 'Get External Data' command set, click 'From Web.' A 'New Web Query' box will appear on the screen.3. Type in the web page that you want to import into Excel, if it does not automatically appear in the 'New Web Query' box. Select the 'Import' button. Excel will then give you the option to select the cell in which you want the web page information to be placed.4. Select either Existing...
Thursday, June 13, 2013
How to Create a Visio Network Diagram From Excel Data
1. Start Visio and click on the 'File' tab. Click 'New' in the left pane and select 'Network.' Choose 'Detailed Network Diagram' and click 'Create.'2. Drag a ring network shape or Ethernet shape from the 'Network and Peripherals' group onto the page. Drag the appropriate devices from the 'Computers and Monitors' or 'Network and Peripherals' section onto the page.3. Connect the device shapes to the network shape. Click on the network or Ethernet shape and hover the mouse pointer over the yellow, diamond-shaped control handle. When the pointer changes to a four-way arrow, drag toward the first...
How to Open XLSM, XLSX, XLSB, XLTX, XLTM and XLAM Files in Excel 2003 and 2002
1. Go to the Microsoft Download Center (link in Resources) and select 'Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats,' located under the 'Popular downloads' heading. Click the 'Download' button on the right side of the ensuing page.2. Click 'Run' if you are using Internet Explorer; click 'Open' if you are using Google Chrome; click 'Save File,' then double-click the downloaded file if you are using Mozilla Firefox.3. Click 'Yes' if you are prompted by the User Account Control window. Read the license terms and select the 'Click Here to Accept the Microsoft...
How to Turn Excel Cells Into Mailing Labels
1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook will open.2. Review the workbook and make sure the data that will be used in the mailing labels contains column headers. Click the 'Save' icon on the Quick Access Toolbar.3. Open Word 2010 and click the 'Mailings' tab. Click the 'Start Mail Merge' button. A drop down list appears. Select 'Labels.' The Labels Option dialog box appears. Select the 'Label Vendor' drop down list and select the type of labels you are creating. Select the label...
Wednesday, June 12, 2013
How to Move a Chart in Excel to Another Page
1. Launch Microsoft Excel 2010.2. Click the 'File' tab at the top-left corner of the window, and then click 'Open.'3. Browse to the file containing the chart that you want to move, and then double-click the file to open it.4. Click the chart to select it. This will add three tabs to the top of the window in a new 'Chart Tools' section.5. Click the 'Design' tab in the 'Chart Tools' section.6. Click the 'Move Chart' button in the 'Location' section of the ribbon at the top of the window.7. Check the 'New Sheet' option, and then click 'OK.' The chart will be moved to a new tab called...
How to Create an XML Map
1. Click the 'developer' tab in Microsoft Excel or if it is not available click the Microsoft Office button. Next click on Excel options.2. Locate the 'popular' category in Excel. Now you will click the 'show developer tab.'3. Click 'source' on the developer tab in the group labeled XML.4. Locate XML maps and click on it. Now click 'add.'5. Find the 'lookin' list and click on the drive, list and folders that you want to open. Now click 'open' for whatever you want.6. Click 'OK' and the XML map is creat...
How to Make a Histogram in Excel 2010
1. Download the Excel 2010 Analysis ToolPak. Click 'File,' and then 'Options.' From the Add-Ins category, select 'Excel Add-Ins,' which display in the Manage box. Click 'Go.' Check the 'Analysis ToolPak' box from the list of add-ins and click 'OK.'2. Choose an appropriate bin size for your data set. The bin size refers to the range of values that fall into a specific class. For example, if your data set is ages of people in the United States, set your bin size to 10 years. This makes the bins correspond to ages 0-10, 11-20, 21-30 and so on, with a maximum bin of 101-110. Select a bin width...
Subscribe to:
Posts (Atom)