VBA - Dividing y-axis labels by 1000

[RawlinsCross]

I have a macro that makes a chart based on data that is expressed in mg/L. Most of the data is in the 50,000 - 100,0000 mg/L range. When I graph this I'd like the y-labels to be scaled from 0 to 100 g/L range. How can this be done using vba?

 

[RawlinsCross]

Upon further digging, I found the answer. All you need to do is add a comma at the end of your custom folder to divide by 1000. You get to keep all your data in its original form but the axes will be scaled - absolutely brilliant.

so instead of:
.Axes(xlValue).Select
Selection.TickLabels.NumberFormat = "#,##0.0"

you add the comma (in red):
.Axes(xlValue).Select
Selection.TickLabels.NumberFormat = "#,##0.0,"