A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can a graph be made with your own X axis values



 
 
Thread Tools Display Modes
  #1  
Old June 26th, 2005, 04:36 AM
heyteach
external usenet poster
 
Posts: n/a
Default Can a graph be made with your own X axis values

I'm trying to make a graph with data that relates to pressure vs temperature
and I can not get excel to let me number my own X axis. I want to establish
the values for both X and Y and then have data distributed on a line graph.
Can this be done?
  #2  
Old June 26th, 2005, 05:38 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

Hey Teach -

Put the X values in a column and the corresponding Y values in the next
column. Select the data and start the chart wizard, but don't fall into
the trap of creating a Line chart. You want an XY Scatter chart. The
names ore deceptive: either can be formatted to show markers or no
markers, connecting line or no connecting line. The difference is in the
treatment of X data. The line chart treats the X values as non numeric
category labels, while the scatter chart recognizes their numerical values.

Here are a couple of web pages with comparisons of the two chart types:

http://pubs.logicalexpressions.com/P...cle.asp?ID=190
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


heyteach wrote:
I'm trying to make a graph with data that relates to pressure vs temperature
and I can not get excel to let me number my own X axis. I want to establish
the values for both X and Y and then have data distributed on a line graph.
Can this be done?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I increase the y axis in a bar graph? Silviawood72 Powerpoint 1 May 24th, 2005 02:21 PM
2 axis bar graph Steve General Discussion 3 March 29th, 2005 11:06 PM
Non-Numeric values in X axis of a scatter chart penasm General Discussion 1 October 28th, 2004 05:44 PM
Lines in graph only if values in fields Jon Peltier Charts and Charting 0 December 5th, 2003 06:24 PM
Line graph along a single axis conaghan Charts and Charting 1 November 29th, 2003 10:05 PM


All times are GMT +1. The time now is 02:25 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.