Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Error when setting chart type

  Asked By: Hope    Date: Oct 18    Category: MS Office    Views: 739
  

I am using Excel 2003. I recorded creating a stock chart with the
macro recorder. When I play back the macro, I get the following in the
message box:

Run-time error '1004':
Method 'ChartType' of object '_Chart' failed

When I go into the debug mode, it has stopped at the second line of the
macro. The first two lines are:

Charts.Add
ActiveChart.ChartType = xlStockVOHLC

Seems strange that I cannot play back a recorded macro. What did I do
wrong?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Error when setting chart type Or get search suggestion and latest updates.




Tagged: