Format Graph Data

[GavinP]

Hi all, i'm sure there is a simple explanation for this, but i can't find it. I have a line graph on a report, which is working fine, but i want to format the data so that it has no decimal places and , separator. In excel that's easy, but in access it doesn't seem to want to know. I've changed the options on the x axis to reflect this, and also changed the options in the excel design bit which pops up when double clicking the graph in design view. this has the effect of making the data appear in the data table in the correct format in design, but as soon as you go to report view, it reverts to decimals.

How the hell do you make it stick to the format?

Gavin