Re: [users] Re: Dual scale charts
At 10:17 04/10/2010 -0400, Robert Peirce wrote: I have 3.2.1 for Mac. I can't find Object Properties in any of the dropdowns. I know. That's why I suggested that Format Selection... might be where the same dialogue was in your version. It would make sense. You don't say whether it is. It turns out I can select a series, right-click on it and get to the properties from there. I mentioned that, too. Also, apparently, I cannot put the chart in a separate tab. Do you mean on another sheet of the spreadsheet? You can, of course: just cut and paste it there. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Dual scale charts
In article 618661.49374...@smtp816.mail.ird.yahoo.com, Brian Barker b.m.bar...@btinternet.com wrote: I have version 3.1.1. for Windows; perhaps you have another. Your Format Selection... is in the same place as my Object Properties...; was one simply renamed as the other? Does it lead to the option I describe? I also discover the date column doesn't get put on the bottom of the chart as it does in Excel, and I don't know how to get it there. In the second step (Data Range) of the Chart Wizard, tick First column as label. I have 3.2.1 for Mac. I can't find Object Properties in any of the dropdowns. Apparently the two versions are considerably different, which makes it pretty difficult to ask questions that might produce useful answers. Later ... It turns out I can select a series, right-click on it and get to the properties from there. Apparently I can draw grid lines for the left scale but not the right. Also, apparently, I cannot put the chart in a separate tab. However, I can make fractional log scales, as for example, 15000 to 36000. Excel would force you to use 1 to 10. All-in-all I prefer OO even if I can't put the chart in a separate tab. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Dual scale charts
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
Re: [users] Re: Dual scale charts
On 10/4/2010 7:17 AM, Robert Peirce wrote: SNIP Later ... It turns out I can select a series, right-click on it and get to the properties from there. Apparently I can draw grid lines for the left scale but not the right. Also, apparently, I cannot put the chart in a separate tab. However, I can make fractional log scales, as for example, 15000 to 36000. Excel would force you to use 1 to 10. All-in-all I prefer OO even if I can't put the chart in a separate tab. Why can you not put the chart in a separate tab? I have used separate worksheets for graphs in OOo for several years. Joe Conner, Poulsbo, WA USA - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Dual scale charts
In article 743805.78028...@smtp823.mail.ird.yahoo.com, Brian Barker b.m.bar...@btinternet.com wrote: At 11:35 03/10/2010 -0400, Robert Peirce wrote: I am virtually certain I can't do this in excel. Can I do it in OO? Yes, you can do this in OpenOffice, and - dare I admit it here? - you can do it in Excel too. Okay. That I would have to figure out if not for your comments below. 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. o Create your chart in the normal way. o Double-click the chart to select it - so that you see the grey border. o Click one of the data points; the data series is marked with green squares and the relevant column (or row) in the spreadsheet is outlined in blue. o Go to Format | Object Properties... | Options (or right-click | Object Properties... | Options). o Under Align data series to, select Secondary Y axis. o You can repeat this for other data series if necessary if you have more than two series in your chart. Wonderful! That is exactly what I needed. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Dual scale charts
In article bob-88d02d.18231703102...@news.gmane.org, Robert Peirce b...@peirce-family.com wrote: In article 743805.78028...@smtp823.mail.ird.yahoo.com, Brian Barker b.m.bar...@btinternet.com wrote: o Create your chart in the normal way. o Double-click the chart to select it - so that you see the grey border. o Click one of the data points; the data series is marked with green squares and the relevant column (or row) in the spreadsheet is outlined in blue. o Go to Format | Object Properties... | Options (or right-click | Object Properties... | Options). o Under Align data series to, select Secondary Y axis. o You can repeat this for other data series if necessary if you have more than two series in your chart. Wonderful! That is exactly what I needed. Oops! When I click on Format, I do not get Object Properties as a choice. What I get are: Format Selection... Position and Size... (grayed out) F4 Arrangement --- Title Legend... Axis Grid Chart Wall... Chart Floor... (grayed out) Chart Area... Chart Type... Data Ranges... 3D View (grayed out) I also discover the date column doesn't get put on the bottom of the chart as it does in Excel, and I don't know how to get it there. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Dual scale charts
At 18:58 03/10/2010 -0400, Robert Peirce wrote: Robert Peirce wrote: Brian Barker wrote: o Create your chart in the normal way. o Double-click the chart to select it - so that you see the grey border. o Click one of the data points; the data series is marked with green squares and the relevant column (or row) in the spreadsheet is outlined in blue. o Go to Format | Object Properties... | Options (or right-click | Object Properties... | Options). o Under Align data series to, select Secondary Y axis. o You can repeat this for other data series if necessary if you have more than two series in your chart. Wonderful! That is exactly what I needed. Oops! When I click on Format, I do not get Object Properties as a choice. What I get are: Format Selection... [...] I have version 3.1.1. for Windows; perhaps you have another. Your Format Selection... is in the same place as my Object Properties...; was one simply renamed as the other? Does it lead to the option I describe? I also discover the date column doesn't get put on the bottom of the chart as it does in Excel, and I don't know how to get it there. In the second step (Data Range) of the Chart Wizard, tick First column as label. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org