I have a XY scatter plot that is a combination (type=xlcombination) type plot. It contains a mixture of series that are lines, points only and lines showing points. I'd like the plot to convert to a line plot so the X values are treated as categories in response to a cell value on a worksheet. Then have it revert back to the scatter plot depending on the cell value. I have all the VBA working (event trapping) except actually converting the plot. I'd like all other formatting to remain the same, just have the x-axis change back and forth between categories and values.

I tried just making axis.type = xlcategory but all the lines and points disappeared. Do I also need to redefine other properties of the series?

Thanks, in advance.