View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.charting
UncaJJ UncaJJ is offline
external usenet poster
 
Posts: 6
Default X axis collapsing to date on hourly data

Hmmm... Well, I MEANT to say what version I was using, but I see I
didn't say Excel 2003. Sorry about that.

However, I was finally able to answer my original question by changing
on the Axes tab from Automatic to Category for "Category (X) Axis."

Now I have my line chart showing date and time on the X axis with each
hour showing separately.

On Oct 2, 1:14 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Did you tell us which version of Excel you are using? Did you try typing
Format Axis into Excel help? Or a web search?
--
David Biddulph

"UncaJJ" wrote in message

oups.com...

Thank you David, but I do not see that option anywhere.
On Oct 1, 3:18 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Format Axis/ scale tab.
--
David Biddulph