Google Docs has a nice trend viewer that can be created just like any other chart:
Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really annoying.
Interactive? No. Openoffice is designed for print / static type outputs, whereas Google Docs is a step away from that and expects all of its users to be on the Web. This component in particular is a Google Charting piece that Google leverages on its other properties including Analytics and Finance.