Did you make a line chart? It will plot the data incorrectly.
Are the values in the X column really numeric, or are they text that
looks numeric? It only takes one text value to mess it up, and Excel
will convert the whole X range into 1, 2, 3, etc.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/
On 3/11/2010 12:45 PM, Eric_G wrote:
I have created a scatterplot where the X value is to be one value (risk) and
the Y value is to be another (return). I've entered the X and Y value ranges
properly and the y value is being plotted correctly, BUT the X value is not
being plotted as the correct X value. Instead, the X value is being
interpreted as the relative ranking in the list. In other words,
# in list X value Y Value
1 12.2 13.7
2 10.7 11.3
etc.
The graph is currently plotting the values as (1,13.7), then (2,11.3) and
NOT with the correct X values as listed in the chart. I've checked the
ranges and there's nothing indicating that the graph should look to the
"relative position" for the x-axis value. What gives?
thanks,
Eric