Dot -
You need to make an XY Scatter chart, not a Line chart. The difference
is not whether the markers are connected by lines, but rather in the way
each handles X data. A scatter chart treats the X values as numerical
values, so 90 would be a lot closer to 0 than to 240; whereas a line
chart simply spaces the data equally across the horizontal axis, and
sticks the X data under the tick marks as labels, without regard to any
numerical value.
Here's some further reading:
X Axis: Category or Value?
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
> I am attempting to create a chart with the following data:
>
[quoted text clipped - 18 lines]
> Thanks
> Dot