Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Scatter plots
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 crashing with simple scatter plots with 8 k data points | Charts and Charting in Excel | |||
Excel 2007: Lines not displaying on Scatter Plots | Charts and Charting in Excel | |||
Excel 2007: Lines not displaying on Scatter Plots | Charts and Charting in Excel | |||
Scatter plots in excel 2007 | Charts and Charting in Excel | |||
Excel gives me line plots - I want scatter plots | Charts and Charting in Excel |