Date/Time stamp formate in Excel

[ClassicCrazy]

Hi,

I corrected the date formula in column A as you said and dragged it down to bottom and pasted it in so that seems good.

You can do it by: Ctrl-C to copy, Shift-Ctrl-Down, that highlights the whole column of data, then Ctrl-V to paste. I do it with a macro (time zone entry, cell error correction, copy/paste, & date/time format column).

Still, annoying after all these years.

dRdoS7

I did learn some those Control Shift arrow tricks  watching a youtube video the other day . Still have a ways to go on the graphing part though !

[ClassicCrazy]

I watched part of an Excel course and made some progress in graphing the Whizbang amps.
But I am sort of stuck on how to make my graph ( chart as they call it ) with better resolution. For example I would like to bring the bottom up from 0 to 10 amps and the top down to around 18 amps .

Is there an easy way to do that either in chart of any other way ?

John I see what you were talking about the noise - so today I had moved my ending amps from 10.8 up to around 11.2 . So I am hoping I could better analyze what it is doing from the chart .

So I am  getting there !


Larry

[Resthome]

I watched part of an Excel course and made some progress in graphing the Whizbang amps.
But I am sort of stuck on how to make my graph ( chart as they call it ) with better resolution. For example I would like to bring the bottom up from 0 to 10 amps and the top down to around 18 amps .

Is there an easy way to do that either in chart of any other way ?

John I see what you were talking about the noise - so today I had moved my ending amps from 10.8 up to around 11.2 . So I am hoping I could better analyze what it is doing from the chart .

So I am  getting there !

Larry

Click on the scale on the left until it is highlighted then right click on it and select Format Axis..

You can then change the MAX and MIN to Fixed values.

You can also add Minor lines by selecting Format Minor Axis after the doing the first step again.

Does that help?




Larry

[ClassicCrazy]

Thanks John - yes that helped !

I knew there must be an easy way to do it .

Larry