Excel Graph Colors

[shane]

Does anyone know how to set the default for ALL data sets in a plot to black or some other color without having to format each data series individually? As you all know Excel uses a different color and symbol for each plot series, but they don't show up very well in a B/W plot. I don't know if this is an option at all, but there are many tricks out there so I thought I would ask.

 

[GregLocock]

I'm sure there is a proper trick, failing that set curve 1 to your preferred format, select curve 2, hit F4, and so on.

Cheers

Greg Locock