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: 1706

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:

ActiveChart.ChartType = xlStockVOHLC

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



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.