Chart VBA for .CrossesAt auto Code

[pickledmuffin]

Is it possible to enable .crossAt function to automatically set within say 50,000 units of the MinimumScale.

For example;

The minimum scale for a particular chart reads 200,000, and the .CrossesAt function would automatically set to 150,000. This would be used dynamically for all charts on spreadsheet

Please Login or Register  to view this content.

Many thanks;

James.

[nsenor udofa]

Can this work?

Please Login or Register  to view this content.

[pickledmuffin]

No Unfortunately that didn't work. It just sees it as crossing at -50,000..


Thanks.

[nsenor udofa]

set the MinimumScale manually. set MinimumScaleIsAuto to False. you can set the MinimumScale to the next 1000 multiple of the minimum of your data.