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
|