Scatter Plot: Change X-Axis Date
- From: dyoung <dyoung@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 9 Apr 2009 18:47:27 -0700
I am plotting a Variable [ ] against Time [MM/DD/YY HH:MM] in a Scatter Plot
(NOT LINE PLOT). Say I want to change the x-axis labels as such: Min =
02/17/09 06:00; Max = 02/18/09 06:00; Major Unit = 1:00. It used to be that
you would type those numbers in the respective sections of the "format axis"
window, but it appears that '07 Excel does not allow this?? Is there a
workaround, or do I seriously have to go back to calculating the actual
number (ie..Min = 39861.25; Max = 39862.25)? I'm going to be pretty annoyed
if they "engineered" that feature out of Excel.
.
- Follow-Ups:
- RE: Scatter Plot: Change X-Axis Date
- From: Tushar Mehta
- RE: Scatter Plot: Change X-Axis Date
- Prev by Date: Re: Automatic swap of x - and y - axis
- Next by Date: Re: Automatic swap of x - and y - axis
- Previous by thread: Stop excel changing chart axes labels when letters are repeated
- Next by thread: RE: Scatter Plot: Change X-Axis Date
- Index(es):
Relevant Pages
|
