LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arrow key weirdness Earl Kiosterud Excel Discussion (Misc queries) 3 April 7th 08 03:12 AM
Pivot Table weirdness Phil Smith Excel Discussion (Misc queries) 0 February 21st 08 07:24 PM
VLOOKUP weirdness Dave Excel Worksheet Functions 2 November 5th 06 03:22 PM
Excel weirdness!!!! MattShoreson Excel Discussion (Misc queries) 5 July 6th 05 01:43 PM
Conditional Sum weirdness . . . WillRn Excel Worksheet Functions 1 February 17th 05 10:46 PM


All times are GMT +1. The time now is 06:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"