X Error Bars appearring when it is not set

[Kah Nee Ong]

Hi,
I am using the ErrorBars in my chart. I only want the Y
Error Bars to show on my chart and I set it correctly in
my program using .ErrorBar Direction:=xlY but it appears
as a bug in Microsoft Excel Macro.

I tried the method in Article 157110 of the Microsoft
Knowledge Base to remove the erronously set X Error Bars
as follows and it doesn't seem to work:

Application.ExecuteExcel4Macro ("SELECT(""Series 1 X Error
Bars"")")
Selection.Delete

What else should I check or what other method can I use?

Is this problem corrected in the the latest Microsoft
Office Service Pack? My Microsoft Office is running
Service Pack 1 on Windows 2000.

Thanks for your response

Kah Nee Ong

 

[Jon Peltier]

Could you post more of the macro, particularly the entire command that
applies the error bars and a few steps earlier. Also, what chart type is
this?

- Jon