Scatter Plot Problems with Dates

[homeguard]

I am trying to make a scatter plot. I have a list of audits with a calculated field of how many days it took to complete the audit. I am trying to make a scatter plot that has the dates at the bottom with the days it took to complete the audit running up the side. but for some reason access wont let me do this, i cant get it to use the dates for the X axis(i think it is just using the column).

Anyone know what i am doing wrong?

 

[homeguard]

ok so i fixed that problem but am wondering another thing. Each plot point has an owner of who created the audit(point) is there a way to color each indivdiual plot point a color for the auditor?

 

[SkipVought]

Yes, using VBA.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[homeguard]

ok np, do you happen to have any example code?

 

[SkipVought]

Are you familiar with objects?

dim pnt as point
for each pnt in chart.seriescollection(whichseries).Points
  with pnt
    .interior.color = vbred
  end with
next

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]