Thank you!
Fiorst off, I tried what you said...and I secected my column of "pseudo
dates" which is B600 -- B1400:
B600 says 1 - Nov
B601 says =B600+1
B602 says =B601 +1
etc, etc, etc
BUT THAT EXACT SAME COLUMN IS THE EXACT SAME FOR ALL 9 OF MY CHARTS WRITTEN
ON THAT PAGE!!
ALL THE CELLS ARE FORMATTED:
CUSTOM "D -- MMM"
YET I STILL GET THE 2 DISTINCTLY DIFFERENT "FORMAT X AXIS" EXAMPLES THAT I
EARLIER REFERRED TO!
WHY CHART 1 IS DIFFERENT FROM CHART 2 ...I DO NOT UNDERSTAND!
I tried your text to columns bit...but I got somewhat "lost" in your last
step...'select Date in the top right'.
WOW!!!!! I JUST solved my problem:
All the graphs that follow my example 2, have as source datta for the date:
B600:B1109
All the graphs that have my example 1, have as source data:
B972:B1109
Furthermore, all the charts show the date such as:
5/02/09 (For my example 1 -- what I'm after
All others, i.e. the charts from B600:B1109 show the X axis's date as:
12-Nov
SO FINALLY, I have fixed all my charsts...by "limiting" my opening date to
12/31/08
and source data B972:B1109
Now , my charts start earlier, and my charsts whos "X Axis" was B18:B1109
always came out "wrong" (my snd example.
I CANNOT UNDERSTAND WHY...ALL OB MY CELLS...B18:B1109 ARE FORMATTED EXACTLY
THE SAME!!!
So, again, thank you for the help...BUT WHY WAS THERE A
DIFFERENCE?????????????????
Please RSVP.
Thamk you,
FLKulchar
Jon Peltier
"Jon Peltier" wrote in message
...
In the second case, Excel has made a category axis, treating your dates as
nonnumeric labels. Perhaps the dates were imported from some other source
and were pasted into Excel as text.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"F. Lawrence Kulchar" wrote
in message ...
I have many Line-type charts, all of which have as the X axis, the DATE.
When I right click on the "X" axis, I get 2 distinctly different type
options under "SCALE" as follows:
1) FORMAT AXIS
Patterns Scale Font Number Alignment
minimum
maximum
base unit
major unit
minor unit
value (Y) axis
crosses at
Date in Reverse Order Value (Y) axis crosses between dates
Value (Y) axis crosses at maximum value
OR...
I get:
2) Patterns Scale Font Number
Alignment
Value (Y) axis crosses
at category number
Number of categories
between tick-mark labels
Number of categories
between tick marks
IN ANY EVENT, I FAIL TO UNDERSTAND WHY, UNDER "SCALE", WHEN I FORMAT THE
"X" AXIS,
I GET THESE 2 OPTIONS DESCRIBED ABOVE, BECAUSE..
"I BELIEVE THE CHARTS ARE IDENTICAL!"
Can someone please help me???
Thank you,
FLKulchar