•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
PQuery / Data models: Dynamic table changing format when encountering null/empty values
Hi all, hoping the community can give me a hand.
As the title says, I have a dynamic graph that plots data from a query in the data model, but when it encounters empty or null values it resets itself.
I already tried changing advanced graph settings "Properties follow data points" to no avail. Also, since im working with external queries I do not know if I can and should modifu the whole data structure to change null/empty values (it could be more bothersome for other effects).
Hope the community can guide me on this issue!
[link] [comments]
Want to read more?
Check out the full article on the original site