Is there a way to get the dimension that is being used as an axis in a chart? E.g. if I had Date as one of my dimensions could I swap that dimension with the other dimension i.e. swapping the X with the Y axis.
Yeah ideally, currently what I have is a chart where the dimensions are defined by the user by using conditional expressions however I'm finding that sometimes the chart may look better if the axis are swapped. I currently have a button that does not trigger anything but I was thinking that it can be used to call a VBA module that swaps the axis.