How to Chart Cells From Two Different Worksheets in Microsoft Excel

Create the Chart
1. Enter data in rows by using row headers with data under them. You can also choose to enter data in columns by using column headers with data under them.
2. Select the cells containing the data you will use for the chart.
3. Select the 'Insert' tab on the top menu, and click the arrow in the bottom-right corner of the Charts group to open the Insert Chart window.
4. Choose the type of chart in the Templates column of the Insert Chart window.
5. Select the chart using the images in the right box in the Insert Chart window, and click the 'OK' button.
6. Move your embedded chart by clicking anywhere in the chart to activate the Chart Tools option on the top menu.
7. Click 'Chart Tools' on the top menu, select the 'Design' tab, and click the 'Move Chart' button in the Location section of the menu.
8. Embed the chart in any sheet in the workbook using the pull-down menu in the Object In option in the Move Chart window, if you choose to. Click the 'OK' button when you are done.
9. Move the chart to a new sheet that you can name using the box next to the New Sheet option in the Move Chart window, if you want to. Click the 'OK' button when you are done.
Add Data from a Second Worksheet to the Chart
10. Click anywhere in the chart to activate it.
11. Click 'Chart Tools' on the top menu, and select the 'Design' tab.
12. Click the 'Select Data' button in the Data section of the Design tab to open the Select Data Source window.
13. Click the 'Add' button in the Legend Entries (Series) box of the Select Data Source window to open the Edit Series window.
14. Name the series in the Series Name box. You can choose to type in a name or link to a cell that contains the name.
15. Select the square box next to the Series Name box in the Edit Series window to link to the name of the series. If it is on another worksheet, click the tab of that worksheet, select the cell containing the name, and click the square box in the Edit Series window.
16. Select the square box next to the Series Values box in the Edit Series window to select the data range you want to include in your chart.
17. Click the tab for the sheet containing the data, and select the range of data you want to include on your chart, and then click the square in the Edit Series window. Click the 'OK' button to include the new data from a second worksheet in your chart.

Read more ►

How to Rotate a Pie Chart in Excel

1. Open the Excel worksheet containing the pie chart you wish to rotate.
2. Click on the pie chart. Doing so will display the 'Chart Tools' menu at the top of the Excel window. Within this menu you will see tabs labeled 'Design,' 'Layout' and 'Format.'
3. Select the 'Format' tab. Navigate to the 'Current Selection' group. Locate the 'Chart Elements' box and click on the arrow next to it. Click on the desired data point or series.
4. Return to the 'Format' tab. Select 'Format Selection' from the 'Current Selection' group.
5. Locate the 'Angle of First Slice' box. Move the slider to the position corresponding to the desired degree of rotation. Alternatively, indicate the angle at which you wish the first slice to appear by entering a value between zero and 360.

Read more ►

How to Change to R1C1 Cell Reference in Excel 2007

1. Open Microsoft Excel 2007.
2. Click on the 'Office' button in Excel.
3. Click on 'Excel Options.'
4. Click on 'Formulas,' in the left-hand pane of the 'Excel Options' box.
5. Check the 'R1C1 reference style' check box under 'Working with formulas' to enable 'R1C1' style referencing. Clear this check box to use 'A1' style referencing.

Read more ►

How to Insert a Check Box on an Excel Spreadsheet

1. Click the 'Developer' tab.
2. Click 'Insert.'
3. Select 'Check Box' under the Active X controls.
4. Click where you want the check boxes to appear on the spreadsheet.
5. Go back to the 'Developer' tab and select 'Design Mode.' This allows you to design the check boxes.
6. Go back to the 'Developer' tab and select 'Properties' to change any properties for the check boxes.

Read more ►

How to Enable Excel Data Analysis in Office 2007

1. Open the Microsoft Excel 2007 application on your computer and then click on the 'Microsoft Office' button.
2. Click on the 'Excel Options' button from the bottom of the application and then click on the 'Add-ins' button.
3. Select the 'Excel Add-ins' option from the 'Manage' box and then click on the 'Go' button.
4. Click on the box next to the 'Analysis ToolPak' field so that it's selected and then click on the 'OK' button.
5. Click on the 'Yes' button if you are prompted to install the add-in for your computer. Once the add-in is loaded, click the 'Data Analysis' button from the 'Data' tab.

Read more ►

How to Enter 17 Digits Into Microsoft Excel 2003

1. Enter your 17-digit number in a cell in an open spreadsheet. If the number displays in scientific notation, you have to adjust the cell format to have it display all 17 digits.
2. Click on the 'Format' pull-down menu at the top of the spread sheet, and select 'Cells' to format how numbers will appear within an individual cell.
3. In the 'Format Cells' box that appears, select 'Numbers' from the tabs. You'll be presented with a series of choices for formatting numbers, such as currency, dates or percentage. Select 'Numbers' from the list. This will change the appearance of numbers in cells, removing scientific notation and displaying all digits as originally entered.
4. You may also want to check the box labelled, 'Use 1000 separator (,)', so that your 17-digit number is displayed with commas, as this makes the numbers much easier to read.

Read more ►

How to Make a Series the Same Color Across Multiple Charts in Excel 2010

1. Launch Excel and open the spreadsheet that contains the charts for which you want to create a common color for a data series. Click the chart to display the “Chart Tools” menu in the ribbon.
2. Click one of the data series in a chart for which you want to create a common color. Click the “Format” tab and locate the “Current Selection” section. Click the “Chart Elements” menu and select the “Data Series” option. Click the “Format Selection” button, which will open a separate window.
3. Click the “Patterns” tab and click a color in the “Area” section. The series will automatically take on the selected color. Repeat steps 2 and 3 for the same data series in each chart, selecting the same color each time.

Read more ►

How to Move Columns in Excel 2007

1. Open the Excel 2007 spreadsheet you wish to modify.
2. Select the top of the column you wish to move, such as column A. This highlights the entire column.
3. Right-click the column and click 'Cut.'
4. Place the column in the location you prefer. Right-click the location and click 'Paste.' Repeat these steps for other columns you wish to change. You have now moved columns in Excel 2007.

Read more ►

How to Remove Print Preview Lines in Excel 2007

1. Click the 'Page Layout' tab on the Ribbon at the top of the Excel screen.
2. Find the 'Gridlines' section inside the larger 'Sheet Options' section.
3. Uncheck the 'View' box to remove gridlines from the Print Preview screen. If you want to prevent the gridlines from appearing on a printed sheet as well, uncheck the 'Print' box.

Read more ►

How to Move Columns in Excel

1. Choose the column heading (1, 2, 3 and so forth) that you want to move and highlight it. You can also select several columns by holding down your left mouse button and sliding it across the columns which you would like to select, in case you want to move more than one column at a time.
2. Leave your mouse placed on the highlighted column(s) and right click your mouse button. This will bring up a pop up menu with several options to choose from.
3. Pick 'Cut' from the menu that pops up. This will make the column you want to move disappear, but your computer will store it in its temporary memory. As long as you don't cut anything else or close the program, your information will not be lost.
4. Select the column that is directly to the right of where you want your selected column to be placed, so that it is highlighted. This is how you let your computer know where you want to place the row that you are moving.
5. Go to the 'Insert' menu and click on the 'Cut Cells' option. The column(s) that you chose to cut will be pasted into your selected area.

Read more ►

How to Sort Columns in Excel 2007

1. Open your spreadsheet file in Microsoft Excel.
2. Press 'Ctrl' and 'A' to select all the columns in your spreadsheet.
3. Click 'Sort Filter' near the right side of the ribbon.
4. Choose 'Custom Sort.'
5. Select the first column you want to sort on, such as Column A, in the first drop-down box.
6. Select the criterion on which you want to sort this column, such as the value of the cell or the cell color, in the second drop-down box.
7. Select your desired sort order, such as A-to-Z or smallest-to-largest, in the third drop-down box.
8. Click the 'Add Level' button if you want to sort by additional criteria.
9. Check 'My Data Has Headers' if your spreadsheet has a header row. If you check this box, Excel will leave the header row as the very top row. Otherwise it would sort your column headings as though they were data.
10. Click 'OK.' Your Excel spreadsheet is now sorted by columns according to the criteria you set.

Read more ►

How to Make a Double Bar Graph on Microsoft Excel

1. Open a new Excel 2010 document.
2. Enter the names of the items you want on your double bar chart, starting in cell B1 and continuing to the right of that cell. These headers will become the labels printed at the base of each of the bar sets on the graph.
3. Type the names of the two categories that the double bar graph will track into cells A2 and A3. These labels will be located to the right of the bar graph. Each of these two categories will be assigned a color bar, which will appear next to each of the items on the graph.
4. Input your numerical data into the cells, starting with cell B2 and continuing down and to the right. When you're done entering information, select cell A1 and hold down the mouse button. Move the mouse to the bottom-right cell and release the button.
5. Select the 'Insert' tab at the top of the screen. Click the 'Bar' button located in the 'Charts' area of the ribbon. Choose any of the 'Clustered' bar chart options, as opposed to the 'Stacked' options. Your double bar chart will appear on the spreadsheet.

Read more ►

How to Create a Frequency Table in Excel Using Pivot Tables

1. Highlight the cells containing the data, if you’re starting the pivot table from scratch.
2. Open the Data drop-down menu and select “PivotTable Report…”. A new frame will open. Click the two “Next” buttons that you see. Click “Existing Worksheet” and select a cell to be the upper-left corner of your pivot table.
3. Click “Layout.” A new panel will open. Drag the field name to the square center of the table that you want to know the frequency of. Double-click it and select “Count.” Drag the same field from the far right into the left column where the row labels go. Click “OK” and then click “Finish.” You will be sent back to the Excel spreadsheet, which will now have a pivot table starting in the cell where you requested it be created.
4. Group continuous data by right-clicking your mouse on the column with the field labels. (An example of continuous data is 'revenue,' while an example of discrete or nominal data is “highest degree achieved.”) Select “Group and Outline” in the menu that pops up and then select “Group.” The range of data will be displayed for you. Select the interval width you want the data grouped into, and enter it in the “By:” field. Select “OK.” The table will now collapse into a more-compressed form and the frequencies listed will go up as data points are added together. If an interval width has no data in it, it won’t be given a row in the table.

Read more ►

How to Change the Text Box Size in Excel 2003

Inserting a Text Box
1. Click on 'View' on the main toolbar, then 'Toolbars' and ensure there is a check mark next to the 'Drawing' toolbar.
2. Locate the 'Drawing' toolbar on your screen.
3. Click on either the 'Text Box' or 'Vertical Text Box' commands on the 'Drawing' toolbar. Your cursor changes to the 'Text Box' tool.
4. Click and drag your mouse to create a text box.
Resizing a Text Box
5. Locate the text box that you wish to resize, then click anywhere in the text box to select it.
6. Change the width of the text box by clicking and dragging from the central anchor point on either side of the text box.
7. Click and drag from the central anchor point on the top or bottom of the text box to change the height of the text box.
8. Change the width and height of the text box simultaneously by clicking and dragging from any of the text box's corner anchor points.

Read more ►

How to Format an 'If Statement' in Excel for a Blank or Filled Reference

1. Open the Microsoft Excel 2010 worksheet. Press 'Alt F11' to open the VBA console.
2. Select a module from the list on the left side. If no module exists, right-click on a worksheet in the list, move the mouse pointer over 'Insert' and choose 'Module.' Select the module that appears.
3. Type 'sub testing()' into the first line of the module and press 'Enter.' Change 'testing' to whatever word you want as it is simply the name of the subroutine. Excel VBA automatically adds the 'End Sub' command to the last row of the module.
4. Type 'Dim x as range' into the next line. This will establish 'x' as a variable, which you will need in the next statement.
5. Type 'For each x in range ('XX:YY')' into the next line. Change 'XX' to the top-left cell in the range you want to work with and 'YY' to the bottom-right cell. This will create a loop that will go through each cell in the range one by one.
6. Type 'If IsEmpty(x) Then XXX Else YYY' into the next line. Change 'XXX' and 'YYY' to whatever code you want to run. The IsEmpty command will check each cell and perform the action after 'Then' if the cell is empty. 'Else,' and the code after it, are optional.
7. Type 'Next' on the next line. This tells Excel to loop back to the 'For' statement and move on to the next cell.

Read more ►