+ Reply to Thread
Results 1 to 4 of 4

Format Multiple Series Code & How to

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    4

    Format Multiple Series Code & How to

    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

  2. #2
    Registered User
    Join Date
    02-14-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Format Multiple Series Code & How to

    Anyone figure this out?

  3. #3
    Registered User
    Join Date
    02-14-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Format Multiple Series Code & How to

    Can someone please help figure this out

  4. #4
    Registered User
    Join Date
    02-14-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Format Multiple Series Code & How to

    Bump again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1