Make sure that data labels are not overlapping
I often use some combination of vba, pitvottables and the Offset function to get automatically updating charts. The only problem that I continously have and cannot solve is that data labels for new data Points are overalapping so that they are impossible to read. Of course I know that I can adjust this manually with drag and drop. But I would definetely like a function that automatically separates the data labels for the last data Point so that they can be read. Googled it and many people are looking for the same function and no one seem to have come up with a good idea how to solve this.