If you use LEFT and RIGHT to generate cell content, this comes out as text,
not numbers. Excel is likely to plot only one point, at X=1 and Y=0.
To convert your text to numeric plottable values, put a double minus sign in
front:
=--LEFT(A1,3)
=--RIGHT(A1,3)
The minus sign closest to the LEFT or RIGHT forces Excel to try to evaluate
the expression as a number. The minus sign before that is needed to convert
the resulting negative number to a positive.
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Don't miss it! Only two weeks away!
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______
"Wobbles" wrote in message
...
Hi thanks again for your reply, The Name labels are less important and i
can live without them. my x co ords are in column n on my sheet and my y
co ords are in column o . I have just tried to do a dummy chart on a
fresh spreadsheet and it works more or less ,but the moment i apply the
same technique to my actual data it fails , the columns n and o are made
from an earlier column in the format NNN/NNN i am using "Left" and
"Right" function to manipulate just the NNN before the / for x and the
NNN after for y . These results columns are formatted as numeric
integers .
Jon Peltier;365153 Wrote:
How do you expect the labels to be plotted? Charts plot X values vs Y
values, with one label per series.
You could tediously plot each separate X-Y pair as its own series with
its
own series name label, but it will take a long time, and you'll find
you
can't have more than 255 such series, as if there is room with all
those
labels.
Or you could select the X and Y values together (hopefully your X data
is in
a column and the Y data in the next column to the right) and create an
XY
chart. Then download one of these free Excel utilities to add the
third
column as data labels on the points:
Rob Bovey's Chart Labeler, 'XY Chart Labeler'
(http://appspro.com/Utilities/ChartLabeler.htm)
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
Two weeks away:
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://tinyurl.com/crqwu6
_______
"Wobbles" wrote in message
...
Thank you for the explanation of the x y however it does not work, I
have a list of values in on column i am using as x co ords , i have
another list as y co ords and the third columns is names that
correspond
to the co ords , when i try to plot it my results are either one
plotted or then all but only on one axis.
Certain areas of the graph could get crowed so my perfect solution
would be to many even go one step further so that hovering or
clicking a
point will bring up the name, that is a less important thing than
getting the bleedin things plotted correctly :(
Wobbles;364331 Wrote:
Sorry i am new to this forum and as when i signed up it asked what
versions i was using i thought the information was public knowledge
, I
am in fact using excel 2002
:nw)
--
Wobbles
------------------------------------------------------------------------
Wobbles's Profile: 'The Code Cage Forums - View Profile: Wobbles'
(http://www.thecodecage.com/forumz/member.php?userid=365)
View this thread:
'Simple ( I thought) X Y Axis point plotting - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=102087)
--- Automerged consecutive post before response ---
PS the links you sent dont work unfortunately ;(
Wobbles;364844 Wrote:
Thank you for the explanation of the x y however it does not work, I
have a list of values in on column i am using as x co ords , i have
another list as y co ords and the third columns is names that correspond
to the co ords , when i try to plot it my results are either one
plotted or then all but only on one axis.
Certain areas of the graph could get crowed so my perfect solution
would be to many even go one step further so that hovering or clicking a
point will bring up the name, that is a less important thing than
getting the bleedin things plotted correctly :(
--
Wobbles
------------------------------------------------------------------------
Wobbles's Profile: http://www.thecodecage.com/forumz/member.php?userid=365
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=102087