Languages
Back
Languages
Create a Scatterplot Chart - Excel on a Computer
> ... PathwayConnect Frequently Asked Questions > Assignment Help for PC 102 W03 Application Activity: Value of a Degree > Create a Scatterplot Chart - Excel on a Computer
  1. Highlight the entire table you created in Part 2, including headings.
  2. Click “Insert” on the main menu ribbon.
The first callout shows the entire table in Part 2 being highlighted. The second callout is pointing at the Insert menu.

  1. Click drop down button and scroll until you see scatter.
  2. Choose the Scatter with Smooth Lines and Markers.
The first callout is pointing at the drop down arrow for charts. The second callout is pointing at the Scatter with Smooth Lines and Markers option.

  1. Once you have your chart, drag it to Part 3 Chart Area.
  2. Hover your cursor on the small box being pointed at until an arrow appears, resize it to fit the chart area.
When the chart appears in the spreadsheet, drag it to Part 3 Chart Area.
Click the bottom middle circle to resize the chart and fit it in the chart area.

  1. Click on the chart itself, so the chart tab appears.
  2. Click on the Chart menu, then click on Edit Chart Title to add a name to your chart.
When you click on the chart itself, the Chart tab will appear in the menu. When you click the Chart menu, look for the Chart Title and select it. Click Edit Chart Title so you can add a name to your chart.

  1. Enter new chart title and click OK once you finish.
A pop up will appear where you can enter the new chart title. Click OK when you're done.

  1. Select Axis Titles in the menu to edit the horizontal and vertical titles
  2. Click the drop down menu in Primary Horizontal Axis Title and Select Edit Horizontal Axis Title
  3. Once you edit the title, click OK
  4. Click the drop down menu in Primary Vertical Axis Title and Select Rotated Title

  5. Once you edit the title, click OK

    Click the Axis Titles option in the Chart menu to edit the horizontal and vertical titles.
    Click Primary Horizontal Axis Title, then select Edit Horizontal Axis Title to add and edit the title for the x-axis.

The title for your x-axis should be Years. Click OK to apply the changes.
Select Primary Vertical Axis Title for your y-axis, then select Rotated Title.
The title for your y-axis should be Amount Earned. Click OK to apply the changes.

This is a final look at the chart:

This image shows what your chart should look like.

Format Cells to Currency - Excel on a Computer
Enter Name Text -- Excel iOS App