Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arrow key weirdness | Excel Discussion (Misc queries) | |||
Pivot Table weirdness | Excel Discussion (Misc queries) | |||
VLOOKUP weirdness | Excel Worksheet Functions | |||
Excel weirdness!!!! | Excel Discussion (Misc queries) | |||
Conditional Sum weirdness . . . | Excel Worksheet Functions |