View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markus Grein Markus Grein is offline
external usenet poster
 
Posts: 6
Default Charting Weirdness and VBA



"Terry Detrie" wrote in message
...

I have a chart with 9 series, and macro that will make them hidden or
visible, depending on the contents of a range of 9 cells in a
worksheet ("IR-Graph")

An odd thing happens sometimes with the the 9th series. I get an run
time error 1004 (Unable to get property of LegendEntry class).
Through a lot of trial and error, I found that this error only occurs
with the 3rd series is turned 'on'.

....

Your code works fine on my end. Created a workbook and took over your VBA
code,
and - as far as I can judge - it does the job nicely.

Feel free to send me copy of your worksheet - maybe there's something about
the way the
chart object is actually addressed / handed over to the macro.

cheers,
Markus