How do I plot X and Y values on Excel 2003?

So I need to graph a chart which has X values ranging from 13-102 and Y values ranging from 0.1 - 100. When I select X and Y values Excel just graphs everything as Y data points and my X axes doesn’t have the proper range. What steps do I need to take to get my X and Y ranges set up properly?

You want to make a "Scatter" chart sub-type: data points with connected lines and not a "Line" chart.

Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=190

This entry was posted on Wednesday, December 2nd, 2009 at 4:14 pm and is filed under x. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “How do I plot X and Y values on Excel 2003?”

Cozmosis on December 2nd, 2009 at 9:22 pm

You want to make a "Scatter" chart sub-type: data points with connected lines and not a "Line" chart.

Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=190
References :

Cut Frame TV