admin管理员组

文章数量:1130349

I've got some code, that retrieves data from DB, creates a ListObject, and a Chart above. When i generate a chart, i'm making some ~by hand modification - for example i'm changing individual bar color, using ActiveChart.FullSeriesCollection(1).Points(i).Format.Fill according to data in ListObject, im also adding some kind of static graph element - lines using series. The problem is when user use Filtering feature on that ListObject. Series get automatically updated, but how can i run my code to change bar color, or redraw / recalculate my static series ? Can i hook somehow to SeriesChange event in that chart from VBA ? Or maybe there is a way, to run my code when user change filtering on Listobject ?

I've got some code, that retrieves data from DB, creates a ListObject, and a Chart above. When i generate a chart, i'm making some ~by hand modification - for example i'm changing individual bar color, using ActiveChart.FullSeriesCollection(1).Points(i).Format.Fill according to data in ListObject, im also adding some kind of static graph element - lines using series. The problem is when user use Filtering feature on that ListObject. Series get automatically updated, but how can i run my code to change bar color, or redraw / recalculate my static series ? Can i hook somehow to SeriesChange event in that chart from VBA ? Or maybe there is a way, to run my code when user change filtering on Listobject ?

本文标签： EXCELVBAattach event to ListObject or ChartStack Overflow

版权声明：本文标题：Excel, VBA, attach event to ListObject or Chart - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://it.en369.cn/questions/1736006909a1377886.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。