Indeterminate X axis

  • Thread starter Thread starter Dot Appleman
  • Start date Start date
D

Dot Appleman

I am attempting to create a chart with the following data:

Clear 51.4 71.0 78.4 86.5
Blue 51.9 79.3 88.7 97.3
Green 51.8 80.9 90.1 98.2
White 51.6 68.9 75.2 81.5
Red 52.7 68.9 75.2 81.5
Black 52.5 76.6 85.2 93.7
Alum Foil 51.4 63.8 69.4 76.1
Clear 51.9 72.3 78.6 86.1
Air 51.3 67.1 71.5 73.7

Elapsed Time(min) 0 45 90 240

I want to have the X-axis plotted in the relative
proportion of the Elapsed Time data. When I do the plot,
each of the 4 numbers are the same distance apart.

Is there a way to do this.

Thanks
Dot
 
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/
_______
 
Back
Top