Forum Discussion
Adding Data Points to a Table or Chart After Power Query Refresh
I have an Excel workbook that has a worksheet for calculating who doesn't have access to our system based on content on the site. These calculations use XLOOKUP to compare two other workbooks (1 CSV ...
1.When you load the data from Power Query into Excel, use an Excel Table (Insert > Table) rather than just a range. Excel Tables automatically adjust their size when data is added or removed. This ensures any charts linked to the table will reflect the updated data after a refresh.