Hi, yes this is indeed about Chart creation. This part of the macro creates a chart of requested part number batch dates that appears on a sheet with a back button on it. when back is pressed, the chart itself is deleted. So it is always only a temporary thing. It was my work around for not knowing how to produce a pop up window from a user form. It works very well, except for this issue, which as you may have guessed by now cannot be fixed manually, it has to be done at the point of creation.

Is this possible?

Kind regards
Rob

P.S. It is not the X and Y axis that is being switched, it is the Y axis and the Series that is being switched. And I am after some VBA code to correct this.