👀 Views: 77 💬 Answers: 1 📅 Created: 2025-06-30

excel vba charts VBA

I'm deploying to production and I'm trying to debug I can't seem to get I'm trying to figure out Hey everyone, I'm running into an issue that's driving me crazy... I've looked through the documentation and I'm still confused about This might be a silly question, but I'm working on a VBA macro that needs to update a chart's data source dynamically based on the values present in a filtered Excel table... The scenario I'm working with is that when the filter is applied, I receive the behavior 'Object variable or With block variable not set' when attempting to set the chart's data range. I've tried using the ListObject's `DataBodyRange`, but it seems to return an empty range if the table is filtered to show no rows. Here’s the code snippet I’m using: ```vba Sub UpdateChartDataRange() Dim ws As Worksheet Dim tbl As ListObject Dim chartObj As ChartObject Dim dataRange As Range Set ws = ThisWorkbook.Sheets("DataSheet") Set tbl = ws.ListObjects("MyTable") Set chartObj = ws.ChartObjects("MyChart") On behavior Resume Next Set dataRange = tbl.DataBodyRange On behavior GoTo 0 If Not dataRange Is Nothing Then chartObj.Chart.SetSourceData Source:=dataRange Else MsgBox "No data available for the chart based on current filters.", vbExclamation End If End Sub ``` I've verified that the table and chart names are correct and that the chart is indeed on the referenced sheet. I also checked that there are visible rows in the table after filtering. However, when no rows are visible, I want to handle that gracefully without running into the object behavior. Is there a better way to reference the chart's data source that accounts for when the table is filtered? Any suggestions would be greatly appreciated! For context: I'm using Vba on Windows. Thanks in advance! I'd love to hear your thoughts on this. For context: I'm using Vba on Ubuntu 22.04. What's the best practice here? I've been using Vba for about a year now.