Attached is an interactive chart I’m working on – to change the chart on the “Interactive Dashboard” sheet, all you have to do is mouse over any small triangle on row 6 between Col B – G. I have 9 stocks assigned to five different categories – the category count is displayed on row four.
My problem is that while Col E actually only should have two diamonds on the chart, the chart is plotting the first 5 lines on the horizontal access. I can solve this problem by filtering Col H on the “Graph” worksheet for blanks. I have a worksheet_change macro to do just that – if you put your cursor in cell H2 of the "Graph" worksheet and hit enter, you can see that macro works.
My question is how can I trigger those two lines of code from the UDF? I’ve tried adding those lines to the UDF, Calling them from the UDF and even using the worksheet_change event. None of those work – even though the UDF changes cell H2, the worksheet_change event does not fire.
Does anyone have any ideas? Appreciate any suggestions. Thanks!
aquixano
Bookmarks