Hi,
Does the Y axis display in percentages because your code is telling it to?
What code are you using the set the chart type.
The Y axis can display numerical values and the number format can be set to
display currency.
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Paul van Coller" wrote in message
...
I hav an application that creates a chart in excel through VB (Create an
excel.application object, and create the chart).
It works great, except for my Y axis that displays in percentages.
Is there a way for the chart to make the Y axis use money values from the
data?
Thanks
Paul.