General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
08 Nov 09 06:40
Date Joined: 07 Nov 08
| Topic/replies: 680 | Blogger: Roman.Totale's blog
Hello and thanks in advance.

I've got two columns of data and I want to plot them in a graph so that the Y-axis is Col 1 and the X-axis is Col 2, and there is a single mark on the graph for each row of data - in other words Cols 1&2 are pairs of co-ordinates.

I hope this makes sense. At the moment everything I try plots them as two sets of data on an X-axis that is scaled by the number of pairs of data, ie 300 rows of data sees the X-axis run from 0-300.
Pause Switch to Standard View Excel Graphs Help
Show More
Report Roman.Totale November 8, 2009 8:39 AM GMT
Sorted it thanks

X-Y - Scatter markers only. does the trick.
Report Roman.Totale November 8, 2009 11:34 AM GMT
Another problem Im having is in vlookup - i have a column rounded to two deci places, but when looking up for values from that column in a table it insists on looking for the full figure and never finds it.

ie -instead of looking for 1.52 it's acutally looking for 1.52003654
Report modk November 8, 2009 11:43 AM GMT
Have you tried setting the last parametre to TRUE
Report Roman.Totale November 8, 2009 11:47 AM GMT
Cheers Modk, should have tried that myself.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.


Instance ID: 13539