Can anyone give me some advice on creating graphs in OpenOffice Calc... I wanna make a graph of my profit/loss against hands played but it doesn't seem to work. I have numerous columns with different details in my cash poker spreadsheet but the 2 I'd need are cumulative profit/loss and cumulative hands played. But when I try to do it, it turns out like this....

For people who can't see it till it gets approved. The number of hands is on the vertical axis but I want it on the horizontal axis, AND for some reason it has put the number of hands in $$$ which isn't how it appears in my data.
Then obv, I want the profit/loss on the vertical axis but that doesn't seem to have come out right at all. My excel skills are good and I'm sure I'd be able to do it in that but OpenOffice seems bizarre with some of it's options/menus. I'm too tight to pay for Excel by the way, and OpenOffice is free before you ask lol.
Comments
I just need to figure out how to get the horizontal axis to be the cumulative number of hands I've played. Essentially I want it to look like a Sharkscope graph but with 'no. of games' replaced by 'no. of hands'.