Re: Excel 2003- Charts- date and time format on x-axis of XY chart
- From: "David Biddulph" <groups [at] biddulph.org.uk>
- Date: Thu, 4 Oct 2007 00:08:21 +0100
=LEFT(A1,11)+RIGHT(A1,5)
--
David Biddulph
"kk" <kk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:667293B3-CB1E-4D0B-9F3B-6F34A30D104F@xxxxxxxxxxxxxxxx
Continuing on with the "Date and Time" questioning above. I have data
that
looks like this in text form: "22-AUG-2007, 11:37". How would I go about
changing this format so that excel reads it as date and time (ie: 08/22/07
11:37, which would equal as a number 39316.4840277778)?
"David Biddulph" wrote:
Are your data values actually date and time, or are they text? Does your
10/28/06 17:00 change to 39018.7083333333 if you temporarily reformat the
cell as General or Number instead of Date and Time? If not, it's probably
text and you'll need to change it to date & time before you can plot them
that way.
--
David Biddulph
"Elizabeth" <Elizabeth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:44670FC7-744C-488F-9E39-B06981D1F86F@xxxxxxxxxxxxxxxx
Hello,
I am trying to plot an XY graph with x-axis data in date and time
format
but
Excel keeps counting the x-axis data as "data labels". It is in the
format
mm/dd/yy HH:mm
ex) 10/28/06 17:00
Instead, Excel appears to be turning my XY plot into a line plot (for
example, the first date is assigned an x-value of 1, the second value
assigned an x-value of 2 and so on so that each date/time x-value is
evenly
spaced).
I would like to find a way to plot this data so that it is spaced
relative
to date and time.
.
- Prev by Date: plot > 0 as green and < 0 as red
- Next by Date: Re: plot > 0 as green and < 0 as red
- Previous by thread: plot > 0 as green and < 0 as red
- Next by thread: Re: How to switch off warnings for logarithmic axis in charts?
- Index(es):
Relevant Pages
|
