MSChart Problems

I'm passing a dataset into MSChart and the Y axis is showing exponential numbers. ie.

5e+009 |
4e+009 | X
3e+009 | X X
2e+009 | X X X
1e+009 | X X X
-------+------------------

I actually want it to show

50000000 |
40000000 | X
30000000 | X X
20000000 | X X X
10000000 | X X X
---------+------------------

Any idea how to force it to show as a proper number and not as an exponential number. The datagrid its coming from shows it in the full format but Chart changes it.

This is a test reply due to problems that have been reporting. Please ignore.

John

This is a reply from Judd who was having problems with posting:


Try this:

Code:

---

    With .Plot.Axis(VtChAxisIdY)
            .Labels(1).Format = "0.00"
    End With

---

Obviously you will need to change the format to the format you desire.

Hope it helps,

:cool:

Dan