Excel plot XY

[gustaf111]

Hello,

I plot a table of date/time and values. Is it possible to just have a label once per day at midnight ? For example 20/08/2012 00:00:00 and next label on the x-axis 20/09/2012 00:00:00 ?

What is the max number of rows in excel 2010 ? I get an error when I write to row 65 537 ?

Thanks for a great forum!!


X axis Y axis
============= ========
20/08/2012 14:47:10 1
20/08/2012 14:47:11 2
20/08/2012 14:47:12 3
20/08/2012 14:47:13 4
20/08/2012 14:47:14 5
20/08/2012 14:47:15 6
20/08/2012 14:47:16 7

 

[SkipVought]

Hi,

Make the x axis a date not category.

How are you writing? What error? What statement?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Also, set the Minimum Axis Value to a whole number.

In the future, please ask different questions in separate threads.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]