X Error Bars appearring when it is not set

  • Thread starter Thread starter Kah Nee Ong
  • Start date Start date
K

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
 
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
 
Back
Top