chart axis formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
Back
Top