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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Graph Colors
- Thread starter shane
- Start date
GregLocock
Automotive
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
Cheers
Greg Locock
- Status