Format Secondary Axis to PERCENT

Originally Posted by Olly

Try:

    .Chart.Axes(xlCategory, xlSecondary).TickLabels.NumberFormat = "0.0%"

Thanks for your input, but nope... i tried this (screenshot: http://screencast.com/t/QZycmSAERUNq)

Exactly the same error...