Chart on form

[wiremonkey22]

Never used charts before hopfully this is easy.

I have a form that tracks billing and date billed and i used the chart icon and wizard to visually show the trends. The chart works fine only problem is all my data on the billing charge is in currency but on the chart it doesent show currency which would not be a problem if the charge was never below 10 cents so insted of showing .04 it shows 4.00E - 02 any ideas on how to fix this to show currency.

Thanks in advance.

 

[KenHigg]

Can't you click on the axis and do Right Click->Format Axis->Number and set it there?

 

[wiremonkey22]

Thank you very much!

 

[wiremonkey22]

Accually now it just goes back to the way it was when i click off a record i also did it in design view and it does the same thing any ideas.

 

[KenHigg]

Maybe you didn't save the change first?

 

[wiremonkey22]

Nevermind i got it thank you.

 

[wiremonkey22]

in design rightclick and format axis i was using the format on the table it pulls up whenever you open the chart design.

 

[KenHigg]

Cool - Glad you have it working.