Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access chart x-axis skipping values

Status
Not open for further replies.

genomon

Programmer
Aug 20, 2001
2,449
US
I KNOW I found the answer to this before, because I have used it, but sure can't scare it up now:
I have an x/y line graph that displays dates along the x-axis. There are tick marks for each date, but only every other date is displayed. The answer is not checking the "category" vs. "automatic" box, and adjusting font sizes is useless. I remember I clicked on "something" (about a year ago), and all the dates magically displayed. Anyone know what it is? [banghead] Arrrrgh!!...


"No matter what happens, somebody will find a way to take it too seriously."
 
Nothing to do with label direction, I suppose?
 




Click on the x-axis and select Format Axis.

Change the number of categories between tic labels.

Skip,

[glasses]Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![tongue]
 
Remou - labels are all good.
Skip - number is set to one. Any higher and fewer dates are displayed. I found the answer last year and stupidly forgot to document it. There is a checkbox *somewhere* that says *something*; when checked, I get all my data. I guess for now I'll just copy one of the older graphs & change the recordsource & datasheet. Thanks for the replies!

"No matter what happens, somebody will find a way to take it too seriously."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top