I am attempted to plot the output of a Monte Carlo simulation but I am having problems formatting the chart. The simulation runs 10000 times. I understand that I can only plot 255 of these simulations which is fine but it seems to want to make me format each series by itself. I need to change the line thickness from the default of 2.25 pt to .75 pt or it just ends up being a jumbled mess. I also need to change the lines to all be one color. I can't imagine that they wouldn't put something in there that would allow me to select all 255 series and format them all at once. Is there a way to do this or do the geniuses at Microsoft expect me to select each series individually to change the line thickness to .75 pt and the color to black?
I tried recording a macro to see what code was generated when I changed the format of the line but the only code that was generated was the code to select the chart as active and the code to select the series as active. No code was generated from my formatting clicks. Is formatting not part of vba code?
Bookmarks