Search:

Hi Kelfro,
The code I assume is external to the application, something that calls Excel. Not quite sure where to embed it. What I was looking for was some solution to the problem of creating a chart...

I'm using Excel 2007 trying to create a macro to draw a chart. Using Record Macro doesn't work. So have tried many attempts at writing one, now even the suggestion in Excel Help gives an error.
...

I get the same problem as reported by Clemens, so I tried Crona's suggestion and now I get the following error:
Type Mismatch on the Set chtChart = Charts.Add

' Create a new chart.

Set...