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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |