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)
Dalmatian
Dalmatian
Dalmatian
Dalmatian
Dalmatian
Golden Retriever
Golden Retriever
Golden Retriever
Golden Retriever
Golden Retriever
Golden Retriever

<colgroup><col style="width: 70px"><col width="103"><col width="80"></colgroup><tbody>
[TD="align: right"]50[/TD]

[TD="align: right"]12[/TD]

[TD="align: right"]60[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]70[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]55[/TD]

[TD="align: right"]12[/TD]

[TD="align: right"]65[/TD]

[TD="align: right"]13[/TD]

[TD="align: right"]70[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]80[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]85[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]75[/TD]

[TD="align: right"]7[/TD]

[TD="align: right"]65[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]76[/TD]

[TD="align: right"]7[/TD]

</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.