X axis collapsing to date on hourly data

  • Thread starter Thread starter UncaJJ
  • Start date Start date
U

UncaJJ

Hello,

I have a spreadsheet I am trying to chart that has values by date and
time, IE

Date-Time, Value
9/17/07 20:00, 1
9/17/07 21:00, 2
9/17/07 22:00, 4
9/17/07 23:00, 1
9/18/07 00:00, 2
9/18/07 01:00, 1
9/18/07 02:00, 0

When I highlight all of the above and select "Insert Chart" and choose
line chart, it creates the chart as if it had the following
information:

Date-Time, Value
9/17/07, 8
9/18/07, 3

It also looks more like a bar chart then a line chart. Anyone have an
idea on why this would happen and how to fix it?

-Jason
 
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 said:
Thank you David, but I do not see that option anywhere.
Click to expand...
 
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.
 
We were discussing XY, not line chart.
--
David Biddulph

UncaJJ said:
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.

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


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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top