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.

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.