Scatter

[Simon Campbell]

I have a Scatter plot with 16 different series, 8 have Markers with no lines and 8 have lines with no markers. The data displayed comes from a TABLE, and I use a series of SLICERS to filter the plotted data. Occasionally when turning on and off buttons in a slicer ALL plotted series are converted to Lines when they should have stayed as only Markers. Does anyone know of a solution to this problem. I have considered defining the Series format with VBA code but my VBA skills are limited. I have uploaded a screen dump of the spreadsheet to give you a better feel for the complexity of my plot.