Here are some tips on modifying the axis scaling on a chart. Whether this is of use to you - I don't know. It sounds like you are already familiar with the 'Axis Scaling' dialog. I'll revisit it later myself.
Dave http://www.openofficetips.com/blog/archives/2005/11/charting_modify.html On 2/1/06, Wangshanpo <[EMAIL PROTECTED]> wrote: > > Dennis > I can't follow your plan. If you want to PM me a copy of the ods file I > might have a better idea. > WSP > > Dennis Marks wrote: > > Thank you. That works. I have a further question. The bars represent > hours > > and minutes from midnight. It is based on a field that has the correct > value > > in hour:minute format. I want the values at the top of the chart to show > > 00:15 00:30 00:45 01:00 01:15 01:30 etc. up to 12:00. > > > > I have tried to set the max and the interval but I can not get it to > work. > > If I put a major interval of :15 it reverts to 0. I have tried the > fraction > > of a day in day (1 / 24 / 4) which does not work. Help, it has a mind of > its > > own and picks the interval and max it wants. > > > > > > > > "Wangshanpo" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > >> I suppose the easiest way is to select chart, then Insert... Axes... > and > >> select *Secondary *Y axis and deselect Y axis > >> > >> hth > >> WSP > >> > >> Dennis Marks wrote: > >> > >>> I have a chart embedded in a spreadsheet that aligns with data on the > >>> spreadsheet. It is a bar chart with the bars running left to right. I > >>> have removed the axis titles and values from the left of the chart. I > >>> have formatted the values that appear at the bottom of the chart. How > can > >>> I move the values at the bottom of the chart to the top? I want the > chart > >>> to look something like this. Please be specific since I am new to > this. > >>> > >>> > >>> 1 2 3 4 5 6 7 8 9 > >>> -------------- > >>> ----- > >>> --------- > >>> ---------------- > >>> > >>> > > > -- > OOo 2.0.1 & OOo 2.0-dev; SeaMonkey 1.0; Win XP sp2 > ============================================== > http://www.answersingenesis.org/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
