+ Reply to Thread
Results 1 to 2 of 2

Changing line-width in a line chart with a lot of series

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Mexico City
    MS-Off Ver
    Excel 2010
    Posts
    5

    Changing line-width in a line chart with a lot of series

    I am making a line chart with a lot of series (age categories 0-4, 5-10, 11-15 etc etc). My chart comes out fine but due to the number of series the chart gets almost unreadable. Therefore I would like to change the width of the lines (from 2.25 to 1). Is there an option to change all the lines at once, because I am only able to select 1 line at the time and this would take a lot of time?

    I am using excel 2010

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,715

    Re: Changing line-width in a line chart with a lot of series

    Hi
    try this macro, it should set all lines to width 4.5:


    Please Login or Register  to view this content.
    Last edited by NickyC; 10-13-2011 at 11:24 PM. Reason: typo

+ 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