Show Hide Data Table in Form's Chart

[phil105]

How can I show/hide the data table in an embedded chart of a form in MS Access(2003)?

I want users to click a control rather than play with the chart
I can find stuff on show legend but not data table

[phil105]

Didn't need to ask, sorry.
Recorded a macro in Excel editing chart objects and ripped the code from that.
This was attached to a control button, and another used for "True" to show the data table

Me.GRAPH1.HASDATATABLE = False

I also figured out formatting the number on the axis which is a bit more complicated
This was part of the code used when the chart was re-queried and dependant on the reult (currency or number) the number format was changed using this code

Me.GRAPH1.Object.Application.chart.axes(2).TickLabels.NumberFormat = "#,##0"

Use "$#,##0" for currency. The $ uses your system format so returnde £ for me