Automatic Y axis scaling

[Paul van Coller]

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.

 

[Andy Pope]

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