Quickly create specialized charts in Excel2007

Source: Internet
Author: User
Tags extend ranges first row

Creating charts in Microsoft Office Excel is quick and easy. Excel provides a variety of chart types for you to choose when you create a chart. For more information about the available chart types, see available chart types.

For most charts, such as column and bar charts, you can use Worksheets worksheet: The primary document that you use in Excel to store and work with data. Also known as spreadsheets. Worksheets are made up of cells that arrange rows or columns. The worksheet is always stored in the workbook. Rows or columns in the row or column are plotted in the chart. However, some chart types, such as pie and bubble charts, require specific data arrangements.

1, on the worksheet, arrange the data to be plotted in the chart.

2, select the cells that contain the data you want to use for the chart.

Tip If you select only one cell, Excel automatically draws all the cells that contain data that is immediately adjacent to the cell in the chart. If the cells you want to draw in the chart are not in a contiguous range, you can select nonadjacent cells or ranges as long as the selected range is rectangular. You can also hide rows or columns that you don't want to draw in your chart.

How to select a cell, range, row, or column

Select Action A cell click the cell or press the arrow keys to move to the cell. Cell range Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while pressing the arrow keys to extend the selection.

You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.

A larger range of cells click the first cell in the range, and then hold down Shift while you click the last cell in the range. You can use the scrolling feature to display the last cell. All cells in the worksheet click the Select All button.

To select the entire worksheet, you can also press CTRL + A.

Note If the worksheet contains data, press CTRL + A to select the current range. Press CTRL + A for one second to select the entire worksheet.

nonadjacent cells or range of cells select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.

You can also select the first cell or range of cells, and then press Shift+f8 to add another nonadjacent cell or range to the selected range. To stop adding cells or ranges to the selected range, press Shift+f8 again.

Note You cannot deselect a cell or range of cells in nonadjacent selections without canceling the entire selection.

Click the row or column heading for the entire row or column.

Row headers

Column headings

You can also select a cell in a row or column by selecting the first cell, and then pressing the ctrl+shift+ arrow key (right ARROW or LEFT arrow for the row, or up ARROW or DOWN arrow for the column).

Note If the row or column contains data, press the ctrl+shift+ arrow key to select the portion of the row or column before the last cell that has been used. Press the ctrl+shift+ arrow key for one second to select an entire row or column.

Adjacent rows or columns drag the mouse between row headings or column headings. Either select the first row or column, and then hold down Shift while you select the last row or column. nonadjacent rows or columns click the row or column heading for the first row in the selection, and then hold down CTRL while you click the column headings for the row headings or other columns that you want to add to the other rows in the selected range. The first or last cell in the row or column selects a cell in the row or column, and then presses CTRL + the ARROW keys (for rows, use the right arrow or left arrow; Use the UP or DOWN ARROW keys for columns). The first or last cell in the worksheet or Microsoft Office Excel table, press Ctrl+home to select the first cell in the worksheet or Excel list.

Press Ctrl+end to select the last cell in the worksheet or Excel list that contains data or formatting.

The cell range before the last cell in the worksheet (lower-right corner) selects the first cell, and then presses Ctrl+shift+end to extend the selected range to the most-used cell in the worksheet (lower-right corner). To the range of cells at the beginning of the worksheet select the first cell, and then press Ctrl+shift+home to extend the cell selection to the beginning of the worksheet. Increase or decrease the number of cells in the active selection hold down SHIFT while you click the last cell that you want to include in the new selection. Active cell active Cell: The active cell is the selected cell in which you can enter data. You can have only one active cell at a time. The border around the active cell is bold. And the cells you click will become the new selected range.

Tip To deselect a range of cells, click any cell in the worksheet.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.