General Betting
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.
sort by:
Show
per page
Replies: 4
|
By:
Sorted it thanks
X-Y - Scatter markers only. does the trick. |
|
By:
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 |
|
By:
Have you tried setting the last parametre to TRUE
|
|
By:
Cheers Modk, should have tried that myself.
|