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 SeaMonkey 1.5a/1.0b (nightlies...) - Win XP sp2 > ============================================== > http://www.answersingenesis.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
