open office calc tutorial3

[riverstrat]

When you put in a Chart there is an anchor that apears, what can you do with that anchor, what use is it ?

Please don't cut an paste the ms explanation.

Thanks.

[cbr0oks]

my daughter can only count to ten . . . but that means she could still count the number of pixels in this video.

[Ken106]

Can anyone figure out how to space columns/rows equally? This things is driving me insane...

[threecheerer]

hey do you know how i can set the the trend lines of my scatterplot graph charts to have a y-intercept of zero? so there would be no y-intercept on the graph's formula? thanks.

[dakinane]

Yep use the "Autofill" function. Do the formula for one column, then drag it across the rest.

[xxdigipiratexx]

Ok. I've been scratching my brain on thsi one a bit. Also found a bug in the OpenOffice countif function that if the comparison contains any punctuation, it will return 0, but enough about that. What I have is a column I have sorted and made unique in a new column. I want to compare items in column b to column a and countif the found results. It works, but I have 7000 items to do this forumal for. Is there a quick way to do this without retyping the formula for each item? Anyone know a way?

[alejandrogg1]

Thanks for the tutorial , is very good, is there a third part?

Alex

[antoneros]

Or see any of the spreadsheet detail?

[antoneros]

Can anyone actually understand this guy?