In news:bob-2bda7c.11353003102...@news.gmane.org, Robert Peirce <b...@peirce-family.com> typed: > I am virtually certain I can't do this in excel. Can I do > it in OO? > > Usually, what I want to plot is some kind of price index > along with some sort of economic series. Their values are > going to wildly different. The price series might be > 20,000, while the economic series is 1.8. I want both to > fill most of the chart. Putting the scales on opposite > sides would be great but not critical. > > If anybody has a method to do this, I would appreciate > seeing it.
I can't show it to you because it's long ago archived, but I can assure you that can be done in both Excel 97 to 2003 and OO.o version 2.4.x to 3.2.1 which I use now. include the versions simply because you have no hint of the version you have. In both cases, it's a matter of going to the chart's controls and adding a series of data for the wanted axis (usually X). I think it's excel also has a decent Help on the subject, and of course there's Google if you don't mind the thousands of extraneous hits it'll also include. But if you're good with Google ... . Sorry about not being more specfic. Surely I or someone else here (or at Microsoft groups) can fix up a couple examples for you. Start wth Bar or Line graphs, whichever you like best, so it's simplest to do, then move on to what you actually want. Some formats don't lend themselves to this, but since you included so little data, ths is all I got to do samples for you. The devil's always in the details, you know. HTH, Twayne` H, Twayne` --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
