Insert a Simple Chart

In this topic you will learn how to create a simple chart.

In order to create a chart, you must first highlight the data you want to plot.   We will look at three different ways to highlight data:

Steps:

1.  

   Highlight consecutive rows or columns:

   Step 1

2. Highlight consecutive rows or columns:

    

   Highlight the first row in the range.

    

   Hold down the [Shift] key and use your arrow keys to go up, down, or across.

    

   In this example, we'll use the down arrow and then the right arrow.

    

    

   Step 2

3. Press [Shift+Down].

   Step 3

4. Press [Shift+Down].

   Step 4

5. Press [Shift+Down].

   Step 5

6. Press [Shift+Down].

   Step 6

7. Press [Shift+Right].

   Step 7

8. Press [Shift+Right].

   Step 8

9. Press [Shift+Right].

   Step 9

10. Press [Shift+Right].

    Step 10

11.  

    Highlight the Entire Range:

    Step 11

12. Highlight the entire range: 

     

    Click and drag to highlight the data.

     

    Step 12

13.  

    Highlight non-adjacent rows or columns:

     

    Step 13

14. Highlight non-adjacent rows or columns: 

     

    Highlight the first row or column in your range. In this example, select Columns A, C, and E.

     

    Step 14

15. Holding down the [Ctrl] key, highlight the additional rows or columns in your range.

    Step 15

16. Holding down the [Ctrl] key, highlight the additional rows or columns in your range.

    Step 16

17. With your data highlighted, create a Pie chart.

    Step 17

18. Click the Insert tab.

    Step 18

19. Create a Pie Chart.

     

    In the Charts group, select the down arrow under the chart heading and select a chart type.  

    Step 19

20. Select the Pie of Pie chart (top row, third chart).

    Step 20

After completing this topic you are able to create a simple chart.

Table of Contents  Start Topic