So I had a macro that worked fine in 2003 but not in 2007. The problem was
that, to my knowledge, 2007's default chart type for scatter plots is with
lines. I want it without lines. One way that I tried to fix this was
setting the default chart type in a blank worksheet to without lines. When I
did this and tried to rerun the macro, it would not work. Changing it back
makes the macro work again. The place it kept getting stuck was the first
line below:

Set ChartObj = ActiveSheet.ChartObjects.Add(left, top, width, height)
ChartObj.Chart.ChartType = x1XYScatter
ChartObj.name = chart_name "(" & CStr(index) & ")"
ChartObj.Chart.ChartArea.AutoScaleFont = False

where left = 48, top = 6, width = 528, and height = 533 have all been
previously defined.

Obviously, this is only part of the code but I've done numerous different
things and am 99.9% sure the problem is that for some reason, these lines
won't work for scatter plots without lines (got some sort of error like "This
dimension is not valid for this plot type") but, again, they work fine for
scatter plots with lines.

Does anyone know why this is the case?

If you need more info, just ask for it and I'll try to get it posted. I
just felt this was long enough already so I didn't explain everything I tried.