General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
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.
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.
Show More
Sorted it thanks
X-Y - Scatter markers only. does the trick.
X-Y - Scatter markers only. does the trick.
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
ie -instead of looking for 1.52 it's acutally looking for 1.52003654
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539