A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Time scale on x Axis What am I doing wrong?



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2009, 10:11 PM posted to microsoft.public.excel.charting
Will
external usenet poster
 
Posts: 242
Default Time scale on x Axis What am I doing wrong?

Issues at hand:
1. I have a list of smapling dates and the first date is during the middle
of the month... I dont want the minimum x axis to be the same as the first
sampling date bc it places the point in the graph to close to y axis... why
does the Min and Max x axis values not allow be to enter jullian dates that
are below or above the min and max dates in my data series?? When I enter
the new dates and click ok... nothing happens and the values are nolonger in
the fields when i return to the dialog box.

2. I must not understand the Major and Minor values for the x axis bacaue I
have the smae experience as in issue above... noting happens and when I go
back to dialog box it is the same as before I changed

3. I am trying to get the x axis to start at say Nov 1st 1992... then show
tic marks for January 1993 and then another tic mark for January 1994....

Can we not post .xls files for people to look at on this site? Did I not do
that before?

Maybe you can suggest a link for me
  #2  
Old March 18th, 2009, 10:49 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Time scale on x Axis What am I doing wrong?

If you could describe the problem clearly enough, you wouldn't need to
upload your workbook.

What version of Excel are you using?

Does it accept dates in the X axis scale parameter boxes? When you enter a
date there, do you leave the Auto box *UN*checked? Checking it makes it auto
again, so Excel will do whatever it wants, not what you want.

Have you set the base unit to days, not months?

Your tick marks have to appear at regular intervals starting at the axis
minimum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Will" wrote in message
news
Issues at hand:
1. I have a list of smapling dates and the first date is during the
middle
of the month... I dont want the minimum x axis to be the same as the first
sampling date bc it places the point in the graph to close to y axis...
why
does the Min and Max x axis values not allow be to enter jullian dates
that
are below or above the min and max dates in my data series?? When I enter
the new dates and click ok... nothing happens and the values are nolonger
in
the fields when i return to the dialog box.

2. I must not understand the Major and Minor values for the x axis bacaue
I
have the smae experience as in issue above... noting happens and when I go
back to dialog box it is the same as before I changed

3. I am trying to get the x axis to start at say Nov 1st 1992... then
show
tic marks for January 1993 and then another tic mark for January 1994....

Can we not post .xls files for people to look at on this site? Did I not
do
that before?

Maybe you can suggest a link for me



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.