VBA and Charts in Excel 2007

**nsv** · 02-17-2010, 07:10 AM

I have a piece of code that arranges a chart to fit the data it should show. The code used to work perfectly in the old Excel version, but after an "upgrade" to Excel 2007 I get "Automation Error" from the line where the scale type is set.

Please Login or Register  to view this content.

If I click "Help" on the error message, I am told to insert a "Microsoft Outlook 2002" disk, but I don't have that and I fail to se the relevance.

How do I set the scale type in Excel 2007?

I know I should not 'select', but I have copied the method directly from the recorder. If someone can show me how to write the instructions without selecting, please do so.

NSV

**Andy Pope** · 02-17-2010, 07:17 AM

It would help is you could post example of the chart you are running this code against.

**nsv** · 02-17-2010, 07:46 AM

Hi Andy

Thanks for the quick response.
I attach the complete workbook with a number of sheets.
Sheet 'Histo' has the chart as push button for the macro and it makes this Automation error.
Sheet 'Prob' has a separate push button and works without problems.
Sheet 'Weibull' has a separate push button and fails, but in a more instructive manner than 'Histo'.

NSV

**Andy Pope** · 02-17-2010, 08:41 AM

Looks like setting the Scaletype is bugged. But only for charts with mixed chart types.

As long as you are not changing the scale type you can use the following edit.

Please Login or Register  to view this content.

**nsv** · 02-17-2010, 09:18 AM

Thanks for the explanation, Andy

Do you think someone will correct the bug? It ought to be possible to set the scale in VBA.

I can of course just remove the line and solve this specific case, but sometimes the data is not linear and I then manipulate the scale manually to see if it fits. That is why I keep this scale setting instruction to be sure it is reset when running the macro.

NSV