Paul, Make sure the updated x axis level is defined between the new min and max y axis values.
If you redefine your minimum y axis value to 20, you need to shift the x-axis to at least the 20 mark. Failing that, just send me your sheet privately (this mailing list does not like attachments) Dave On 11/16/05, Paul_B <[EMAIL PROTECTED]> wrote: > On Tue, 15 Nov 2005 23:26:05 -0500, David Chapman wrote: > > > Here is Flash animation of what you want... (600k) > > http://www.openofficetips.com/downloads/axis_modify.htm > > > > Normal HTML format... (bandwidth friendly) > > http://www.openofficetips.com/blog/archives/2005/11/charting_modify.html > > > > I hope this helps... > > > > Dave > > > > On 11/13/05, Paul_B <[EMAIL PROTECTED]> wrote: > >> > >> I've actually been having some good results using charting. Two > >> questions I haven't been able to answer: > >> > >> First, is it possible to shift the X axis upward? All my values > >> lie between 20 and 190, and I'd like to concentrate the chart > >> visually by not showing the 0-20 range. > >> > >> A related question. Is it possible to have two Y axis scales, so > >> my 20-25 scales and 180-190 scales could be shown beside each > >> other on the same Y axis segment? This way I could concentrate > >> the chart much more, showing much more detail for a given area. > > > Thanks, Dave. That at least points the way to how to do this. But > I've got a remaining problem - the program keeps telling me my > choice of axis level is less/greater than the minimum/maximum > value. I went back and filled in blank cells with placeholder > data - something I did not want to do - and that didn't help. I > lopped off the first row, which contained label data, which I did > not want to do. But nothing gets me past this error. > > Thanks for pointing the way, in any case. > > Paul > > > -- > Using OOo 2.0 on Win XP sp2. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
