Convert a scatter graph with multiple data series into individual graphs

I am trying to convert a scatter graph with multiple data series into individual graphs, with the series having the same formatting as in the graph when all series are together.

Normally, if I delete any series, the color scheme for all the other series vanishes. I can then waste more time in having to re-adjust the  color and shape of the series, but this is tedious. This, I do not want. Is there an automated way to do this?

Ideally, of course, all series would appear in little subsections in the space of the former one graph, all with individual axes, but I can't have all, so I'll settle with having several individual new graphs, each with just one series, and with the original formatting.

Thx.

April 2nd, 2015 2:17am

How about creating a copy of the chart, and then setting all series except one to be transparent (no line, no marker)? Repeat for each series.
Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2015 10:26am

It is strange for me. By mere deleting the appropriate series I achieve the same effect. Or was it a benefit only of my old, good Excel 2003?

PB

April 4th, 2015 11:10am

Removing series works OK for me in Excel 2013, but apparently not for the original poster...
Free Windows Admin Tool Kit Click here and download it now
April 4th, 2015 11:33am

The effect described by the OP (shift of series formats) takes place, when the original data are deleted. The question is, what is meant in the contribution under the term 'series' : data or curve?

PB

April 4th, 2015 4:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics