I create a lot of graphs for research using the "line with markers" graph because we graph data progressively over the years (i.e. 1-3months, 3-8months, 8-12months, 1-2.5yrs, ect...). However, since this is research, I need all the lines to be formatted the same exact way and not individual colors and shapes. I was wondering, is there a code that could change all the following at once or at least most of these (the F4 method is pretty slow):
Marker Options: Circle
Marker Fill: No Fill
Line Color: Black
Line Style: 1pt
Marker Line Color: Black
I am very unfamilar with coding in Microsoft Excel2007, so if you could provide a detailed way of getting to the coding menu, as well as how to input the code (if its possible), I would greatly appreciate your help! The n= is different for each graph, so if you need to know that, I can give you a the "n" for one of the sets as a template and then I could change it in each code. Not sure if that's even how the coding works for graphing lol
If you have any more questions feel free to ask!
Thank you for your time & hope to hear from you soon,
Nick
Bookmarks