chart axis formatting

N

nevpoe

I have my records in the date format of mm/dd/yyyy ham/pm. I am trying to
chart the information but the x-axis is getting crowded. I want the data to
appear in mm/dd or just dd if possible but I loose the order and spacing of
the data when I try. Any suggestions?
 
A

Al Camp

Nevpoe,
In the Access query behind your chart you can format you Date field.
Either use the format property, or create a calculated field...
FDate : Format(YourDateField, "dd")
hth
Al Camp
 
N

nevpoe

I tried changing the formating on the query. All I ended up with is a chart
that looked like a mountain range. The chart plotted all four points as one
group for the day. The four points come from 4 different times of day. I
don't need all that information on the x axis, but I want it to continue to
plot the graph as each time per day.
 
Top