how to make a pie chart in excel with non adjacent ranges

Create a Table from Existing TextĬhapter Four. Use the Microsoft Help SystemĬhapter Two. Preview and Print Documents, Close a Document, and Close Word

Getting Started with Microsoft Office Word 2003.

Creating Documents with Microsoft Word 2003 Identify Safe Computing PracticesĬhapter One. Describe Networks and Define Network Terms Identify Types of Software and Their Uses Identify the Different Types of Computers Define Computer and Identify the Four Basic Computing Functions Start Internet Explorer and Identify Screen Elements

Getting Started with Internet Explorer 6.0.

Delete Outlook Information and Close Outlook

Getting Started with Microsoft Office Outlook 2003.

Maximize, Restore, Minimize, and Close a Window

Leave your Excel file open for use later. Click in the Chart Area and Move the chart to the left side of the screen, under the cells. You can also size the chart using its sizing handles.Īt the lower right corner of the chart object, drag the sizing handle to size the chart larger to the right and down a bit, making it larger and easier to read. You can move and position the chart on the sheet by clicking in the Chart Area and then dragging the chart to a new position. When you create charts, you will select rows or columns based on how you need to present the data.Įxcel displays the chart along with the other information on the worksheet. This creates a data set and legend items based on each row instead of each column. On the Chart Area, right-click, and then click Source Data. When you point to the Chart Area using the mouse, a ScreenTip appears that shows the name Chart Area. The Chart Area is the background area of the chart object that has no other chart content. This creates a chart with the default choices, a column chart on the current sheet, with a legend. You should have two nonadjacent areas of shaded selected cells.īecause you include the cells showing column headings in your selection, these labels will also appear on your chart. Press and hold the key, and then select cells D1 through D6. Press and hold the key when selecting multiple items.

You can also select specific cells of data from the worksheet to include in the chart. To create a chart quickly, you can use the default settings in Excel.

How to make a pie chart in excel with non adjacent ranges