Excel line chart (how to change axis points)

[charlie15]

If I have the following data for example:

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

Weight (lb)	Type of Dog	Speed (mph)
50	Dalmatian	12
60	Dalmatian	10
70	Dalmatian	11
55	Dalmatian	12
65	Dalmatian	13
70	Golden Retriever	5
80	Golden Retriever	4
85	Golden Retriever	6
75	Golden Retriever	7
65	Golden Retriever	3
76	Golden Retriever	7

<colgroup><col style="width: 70px"><col width="103"><col width="80"></colgroup><tbody>
</tbody>

I want to create a line chart that shows weight on the y axis and speed on the x axis with one line for Dalmatians and another for Golden Retrievers. How do I accomplish this? Should I be setting up my data tables differently?

-- removed inline image ---

 

[charlie15]

Currently I am only getting line charts that show one line for weight and another for speed with data points for breed type.