Question

Data:

Student ID	Final GPA	Annual Salary ($1000)
1	3.36	78
2	2.62	71
3	2.69	71
4	3.18	78
5	3.02	77
6	2.88	76
7	3.04	77
8	2.47	67
9	3.4	78
10	2.61	69
11	3.75	86
12	2.92	76
13	3.02	77
14	2.66	72
15	3.3	81
16	3.15	78
17	3.05	103
18	3.06	78
19	3.57	80
20	2.32	64
21	2.73	73
22	2.71	69
23	2.19	65
24	2.86	73
25 Question is make a simple scatter chart in excel. How ever on the axis i need to show 2-4.0 for the gpa My problem: i can create a chart but it its slightly off from what my teachers points are . I need step by step help	2.87	98

Answer 1

A Simple Scatter Chart may look like this as it basically covers all the required information with an easy to understand digram.

Steps are quite simple:

1. Select the required data (in excel) to be captured in the diagram.

2. Go to Insert and select scatter chart.

3. Now you need to change you chart. So right click the chart and click change chart type.

4. Go to Combo where you can change the axis to make your chart more presentable.

5. When you select combo, Final GPA will be shown as clustered column and Annual Salary as line.

6. Tick Final GPA as secondary axis to show it vertically on the right side of the chart.

7. Also select scatter for Annual Salary. Then click ok.

8. Now as per your requirement you need to chage the range of Final GPA. So, right click on the Final GPA range and click format axis.

9. Now in Axis options you may select bounds ranging from 2 (minimum) to 4 (maximum).

10. In the same way, you may also change the Student ID range according to the requirement as number of IDs are only 25, maximum bounds can be set at 25.

11. Chart will look like one shown above. First Final GPA line comes and then its corresponding annual salary with a dot for a particular ID and similarly for other IDs.