If you don’t want to graph the entire spreadsheet, you can select multiple cells by holding Ctrl and clicking the cells you want to graph.
You can also add a second axis to a line graph or a bar graph.
If you want to change the chart type for the entire chart, click the chart type in the menu to the left of the window and then double-click the chart style in the window.