Mgiyuk

Pivot Chart/Pivot Table blank/missing data to hide on table I hope everybody is well! Quick question I have concerning Pivot Tables and Pivot Charts. I have quite a quantity of data that I am trying to put into a Pivot Chart, however it also creates space for data that is blank and therefore make the pivot chart very small and hard to read. I've been trying to find a solution for my problem for quite some time and wasn't able to find anything. enter image description here What I would like to achieve not to have the data that is blank showing in the pivot chart. Thank you ! How about uploading a higher resolution picture. I can't see what's going on in that one. – jeffreyweir Jun 28 at 21:50 Thanks for the reply. I've updated the picture with a better resolution. Due to the huge amount of data...

Automate Filter Selection in Pivot table of Excel using macro How can I jump to the first selection of a date filter in Excel? The filter is connceted to a cube and everyday new date gets refreshed and added to the filter automatically. I want to unselect the current selection and select the next date. And I want to build a MACRO for this task. Please suggest how to do it. This is Off-Topic, please don't ask how to do x without offering what you tried so far. If you want a tutorial on how to build a Macro for something like this please use google. Quote from stackoverflow.com/help/on-topic: Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it. Please take a look at How to Ask. – Paxz Jun 29 at 11:00 ...