Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2004

Tip: Looking for answers? Try searching our database.

Indeterminate X axis

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dot Appleman - 29 Apr 2004 15:40 GMT
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
Jon Peltier - 30 Apr 2004 06:07 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.