1-866-245-5224 sales@keystonelearning.com

Excel 2003: Creating a Chart

Excel 2003: Creating a Chart

The first step to a great chart is good data. So, before you can create any type of graphical representation of numbers, you need to have those numbers (along with their labels) into an Excel worksheet.

Once you have your data, think about which data you want to chart. For example, it’s not a good idea to chart data with their totals. This can really skew the appearance of your graphs.

If you’re still wondering how the data should appear on the worksheet in order for it to plot appropriately for your desired chart, refer to the table below.

               

Chart Type

Data Arrangement

Column

Bar

Line

Area

In columns and rows

For example:             West     East        South    North

Salesperson 1            100         200         100         200

Salesperson 2            150         350         100         250

Salesperson 3            100         500         210         150

Pie

Doughnut

In ONE column or row of data and one column or row of data labels

For example:                                             West

                        Salesperson 1                    1,000

                        Salesperson 2                    2,000

                        Salesperson 3                    1.500

Creating a Chart

     
  1. Select the cells that contain the data that you want to use for the chart
     
  2.  
  3. Click the Chart Wizard button on the Standard toolbar
     

Figure 25. Chart Wizard Dialog Box - Step 1 of 4

   3.      Click the Chart Type you want to use and then click Next

Figure 26. Chart Wizard Dialog Box - Step 2 of 4

   4.      Because you selected the cells that make up the chart, this information should be correct. On Step 2, verify the data is correct and then click Next

Figure 27. Chart Wizard Dialog Box - Step 3 of 4

   5.      In Step 3, you’ll view each available tab and set your chart labels and preferences. When finished, click Next.

Figure 28. Chart Wizard Dialog Box - Step 4 of 4

   6.      To create an embedded chart, choose “As object in” and then click Finish.