Closed Thread
Results 1 to 7 of 7

Formatting Multiple Series In An Excel Chart

  1. #1
    Forum Contributor
    Join Date
    03-13-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    136

    Formatting Multiple Series In An Excel Chart

    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?
    Last edited by jerseyguy1996; 10-15-2009 at 09:15 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,124

    Re: Formatting Multiple Series In An Excel Chart

    You can not, never could, format multiple series at once.

    Previous F4 allowed for fewer keystrokes. The Modeless dialogs in xl2007 make this impossible.

    You could use a template but you would still need to format ALL the series in the template.

    So code is quickest.

    Please Login or Register  to view this content.
    Whilst the chart is currently limited to 255 series you may be, depending on your chart and data layout, be able to get away with 1 series.

    If the chart is xy-scatter and all the data can be placed in 2 columns, you can use a blank row to separate and break the line.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    03-13-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    136

    Re: Formatting Multiple Series In An Excel Chart

    Quote Originally Posted by Andy Pope View Post
    You can not, never could, format multiple series at once.

    Previous F4 allowed for fewer keystrokes. The Modeless dialogs in xl2007 make this impossible.

    You could use a template but you would still need to format ALL the series in the template.

    So code is quickest.

    Please Login or Register  to view this content.
    Whilst the chart is currently limited to 255 series you may be, depending on your chart and data layout, be able to get away with 1 series.

    If the chart is xy-scatter and all the data can be placed in 2 columns, you can use a blank row to separate and break the line.
    Oh Wow......Andy!!! That worked so freakin well! I've spent two days trying to figure out how to format multiple series and with a quick copy and paste of your code it did it in about 1/2 a second. You are awesome!!!

  4. #4
    Registered User
    Join Date
    05-01-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Formatting Multiple Series In An Excel Chart

    I was wondering if I could write a similar code for changing the size of my line markers? I tried to make up my own, but it didn't pan out.

  5. #5
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Formatting Multiple Series In An Excel Chart

    Mbroswick,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  6. #6
    Registered User
    Join Date
    02-23-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    1

    Re: Formatting Multiple Series In An Excel Chart

    Quote Originally Posted by jerseyguy1996 View Post
    Oh Wow......Andy!!! That worked so freakin well! I've spent two days trying to figure out how to format multiple series and with a quick copy and paste of your code it did it in about 1/2 a second. You are awesome!!!
    Hi, how did you use the code? can you use this code in excel? Thanks!

  7. #7
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,877

    Re: Formatting Multiple Series In An Excel Chart

    @iAshish

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed 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