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
|
|||
|
|||
Need to Make A Chart
I need to make a chart in Excel that plots two numbers onto a graph. The X
and Y zero points will intersect in the middle and all points on the graph will be plotted either to the left/right and up/down of the center point. Example: X Value: -4.0 Y Value: 2.5 The point will be plotted 4 ticks to the left and 2.5 ticks above the zero intersection point. How do I do this? -- NorthStar Always do right. This will gratify some people and astonish the rest. Spam protected -- Remove _NadaSpam_ to e-mail |
#2
|
|||
|
|||
Need to Make A Chart
Hi,
In A1 type X; in B1 type Y Let's say you have 6 points; enter them in A2:B7 (one pair to a row) Select A1:B7, click on the Chart Wizard in the Toolbar Select a XY (Scatter) chart Work thru the 3 steps. If the result is more or less what you want; get an intro Excel book and learn how to format the chart to make it 'prettier' Bernard "NorthStar" wrote in message ... I need to make a chart in Excel that plots two numbers onto a graph. The X and Y zero points will intersect in the middle and all points on the graph will be plotted either to the left/right and up/down of the center point. Example: X Value: -4.0 Y Value: 2.5 The point will be plotted 4 ticks to the left and 2.5 ticks above the zero intersection point. How do I do this? -- NorthStar Always do right. This will gratify some people and astonish the rest. Spam protected -- Remove _NadaSpam_ to e-mail |
#3
|
|||
|
|||
Need to Make A Chart
Put your X values in a column, and your Y values in the next column to
the right. Select the range of data and start the chart wizard. Choose an XY Scatter type in step 1, make sure step 2 uses Series in Columns, and go through the rest of the chart wizard. To format a part of the chart, try double clicking or right clicking on it. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ NorthStar wrote: I need to make a chart in Excel that plots two numbers onto a graph. The X and Y zero points will intersect in the middle and all points on the graph will be plotted either to the left/right and up/down of the center point. Example: X Value: -4.0 Y Value: 2.5 The point will be plotted 4 ticks to the left and 2.5 ticks above the zero intersection point. How do I do this? |
#4
|
|||
|
|||
Need to Make A Chart
I get two points for each person instead of the single point for each
person. How do I get Excel to recognize that each pair of numbers constitutes the chart address for a single point? -- NorthStar Always do right. This will gratify some people and astonish the rest. Spam protected -- Remove _NadaSpam_ to e-mail "Bernard V Liengme" wrote in message ... Hi, In A1 type X; in B1 type Y Let's say you have 6 points; enter them in A2:B7 (one pair to a row) Select A1:B7, click on the Chart Wizard in the Toolbar Select a XY (Scatter) chart Work thru the 3 steps. If the result is more or less what you want; get an intro Excel book and learn how to format the chart to make it 'prettier' Bernard "NorthStar" wrote in message ... I need to make a chart in Excel that plots two numbers onto a graph. The X and Y zero points will intersect in the middle and all points on the graph will be plotted either to the left/right and up/down of the center point. Example: X Value: -4.0 Y Value: 2.5 The point will be plotted 4 ticks to the left and 2.5 ticks above the zero intersection point. How do I do this? -- NorthStar Always do right. This will gratify some people and astonish the rest. Spam protected -- Remove _NadaSpam_ to e-mail |
#5
|
|||
|
|||
Need to Make A Chart
On Fri, 24 Oct 2003 18:02:07 GMT, NorthStar
wrote: I get two points for each person instead of the single point for each person. How do I get Excel to recognize that each pair of numbers constitutes the chart address for a single point? Each row in the data set is treated as an individual pair, assuming you use an XY scatter chart (*not* a line chart). You need to do nothing special. -- Dave dvt at psu dot edu |
#6
|
|||
|
|||
Need to Make A Chart
Oops! I'm sorry about the size of the JPG... I didn't realize it came out
as large as it did. My apologies to the group. -- NorthStar Always do right. This will gratify some people and astonish the rest. Spam protected -- Remove _NadaSpam_ to e-mail "NorthStar" wrote in message ... I'm just not getting it. After trying to stubborn my way thru this, it's still not giving me what I want. I've attached a picture of what I'm trying to get Excel to do. Horizontal Vertical ^DL^ -2.38 -3.64 3rdUp 1.50 3.23 NorthStar -4.50 0.56 As you can see from looking at the graphic, DL's point would be 2.38 left and 3.64 down from the intersection of the zero lines. 3rdUp is 1.50 up and 3.23 right of zero, and I'm 4.50 left and .56 up. Is this type of chart beyond Excel's capabilities, or am I just not understanding a fairly simple subject (and trust me, it wouldn't be the first time I was outsmarted by the computer g). -- NorthStar Always do right. This will gratify some people and astonish the rest. Spam protected -- Remove _NadaSpam_ to e-mail "dvt" wrote in message newsprxj86dp4qi5lh2@localhost... On Fri, 24 Oct 2003 18:02:07 GMT, NorthStar wrote: I get two points for each person instead of the single point for each person. How do I get Excel to recognize that each pair of numbers constitutes the chart address for a single point? Each row in the data set is treated as an individual pair, assuming you use an XY scatter chart (*not* a line chart). You need to do nothing special. -- Dave dvt at psu dot edu |
#7
|
|||
|
|||
Need to Make A Chart
So arrange your data like this:
X Y ^DL^ -2.38 -3.64 3rdUp 1.50 3.23 NorthStar -4.50 0.56 Select the two column wide, four row high range that contains the X and Y values and the header row. Run the chart wizard and create an XY Scatter chart. Not a Line chart. You can double click on an axis to adjust the scale parameters (min, max, etc), and you can right click on the chart and choose Chart Options to add vertical gridlines to go with the default horizontal ones. To use the labels in the first column as labels on the data points, download Rob Bovey's Chart Labeler (free at http://appspro.com), install it, and use the Chart Labels command that's added to the bottom of the Tools menu. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ NorthStar wrote: I'm just not getting it. After trying to stubborn my way thru this, it's still not giving me what I want. I've attached a picture of what I'm trying to get Excel to do. Horizontal Vertical ^DL^ -2.38 -3.64 3rdUp 1.50 3.23 NorthStar -4.50 0.56 As you can see from looking at the graphic, DL's point would be 2.38 left and 3.64 down from the intersection of the zero lines. 3rdUp is 1.50 up and 3.23 right of zero, and I'm 4.50 left and .56 up. Is this type of chart beyond Excel's capabilities, or am I just not understanding a fairly simple subject (and trust me, it wouldn't be the first time I was outsmarted by the computer g). |
Thread Tools | |
Display Modes | |
|
|