I changed the input value from a time value to a decimal value and the numbers format ok now. Thank you for your help.
"Wangshanpo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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]
