Hi,
I desperately look for a way to adapt a pivot chart (radar) each time a given cell changes. Basically, the chart is in a kinf of dashboard in which data over different topics/projects are examined. In C12, when I switch the project code (moving to the next one for instance), I want the chart to adapt automatically.
I tried to register a macro but it doesn't work.
Any idea?
Thanks a lot!
H
See file enclosed to illustrate.Chart update with macro.xlsm
You're very nearly there, with your code in Module1.
Put this in the WORKSHEET module for Sheet1:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks