Posted to microsoft.public.excel.programming

Sean McPoland[_6_] Sean McPoland[_6_] is offline

external usenet poster

Posts: 1

ActiveChart.ADD Fails

I have recorded a macro to add a new chart sheet but when
running the macro is step mode it fails:

the statements are
Charts.Add
ActiveChart.ChartType = xlSurface

and I get

Runtime error '1004'
method Charttype of object _chart failed...

any ideas - this is bog standard code

regards
Sean

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ActiveChart.Location help	Dave	Excel Discussion (Misc queries)	1	November 16th 07 07:38 PM
Activechart.SetSourceData Source???	Bob R	Excel Programming	2	July 30th 04 03:39 PM
Activechart.SetSourceMethod problem	grinning_crow	Excel Programming	2	March 1st 04 10:07 PM
How does the ActiveChart.Location() work	Ramil[_2_]	Excel Programming	0	January 20th 04 04:56 PM
Argument List Of ActiveChart.Location And ActiveChart.ChartType	Mo[_3_]	Excel Programming	2	September 1st 03 11:12 PM

All times are GMT +1. The time now is 02:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us