VBA and Charts - Can SOMEONE help?

John McGraw · Apr 26th, 2002, 02:35 PM

Does anyone know where I can get some code that creates multiple embedded chart objects and arranges them in a sheet?

I just want some examples of embedded chart objects being handled. Whenever I add my own chart objects, I always get "method failed" errors when trying to handle them. This drive me nuts, because a recorded-macro handles the activechart the same way, but there are no "method failed" errors.

Damon Ostrander · Apr 26th, 2002, 10:49 PM

Hi John,

An example is headed your way via email.

Apr 26th, 2002, 10:49 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi John, An example is headed your way via email. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 02:35 PM	#1
John McGraw Board Regular Join Date: Feb 2002 Posts: 76	Does anyone know where I can get some code that creates multiple embedded chart objects and arranges them in a sheet? I just want some examples of embedded chart objects being handled. Whenever I add my own chart objects, I always get "method failed" errors when trying to handle them. This drive me nuts, because a recorded-macro handles the activechart the same way, but there are no "method failed" errors.