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.
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
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
Select the cells that contain the data that you want to use for the chart
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.