OpenOffice.org 3.1 Chart Feature: What to do with zero values

If you're missing data, you have three options now: skip the data, assume zero, or compute a logical continuation.

Let's say you've got this data, with this line chart. The default is to leave the missing data out completely.

If you don't want that, though, you can double-click the chart, then click on one of the data lines, and choose Object Properties.

Select another option, such as the one setting all missing values to 0.

That might or might not be what you want.

The Continue Line option gives the best-looking, if maybe not the most accurate, results.

Comments

[Carol Whitney]

Thank you! Thank you! Great help! I'm just learning!

[chi flat irons]

Just wanted to say a big huge CONGRATS on the book! I look forward to reading it, and I love your blog and your column. Can't wait for the new blog

[runescape money]

They are able to provide a world of warcraft gold service at first time when it came out.

[wow power leveling]

http://www.gamegoldme.com/
http://www.wowgold-powerleveling.com/
http://www.wowgold-wow.com/
http://www.wowpowerleveling.me
http://www.watchrolexshop.com
http://www.wowgold-wow.com/wow-power-leveling
http://rs-runescapegold.com/
http://www.watchrolexshop.com/wow-power-leveling/
http://www.cheap-lotrogold.com/
http://www.globalsale.me/Aion-gold-083.aspx
http://www.cheap-gamegold.org
http://www.gamegoldvip.org
http://www.globalsale.me/

[metin2 yang]

Can't wait for the new blog