+ Reply to Thread
Results 1 to 3 of 3

Charting - Changing Multiple Line Weights - Excel 2010

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel for MS365
    Posts
    8

    Charting - Changing Multiple Line Weights - Excel 2010

    I am drawing a line chart. It has many many lines and the default line thickness is too thick. Rather than click each line and alter its weight, does anyone know if it's possible to change / select multiple lines and change the thickness in one go.

    Thanks for any assistance.

    PGee

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

    Re: Charting - Changing Multiple Line Weights - Excel 2010

    You have to format each line individually.

    You can speed it up a little by selecting a line series and using the Format Tab > Shape outline > Weight. to select the require thickness.
    Then use the arrow key to move to the next series and F4 to repeat.

    Else you need to use code.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-08-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel for MS365
    Posts
    8

    Re: Charting - Changing Multiple Line Weights - Excel 2010

    Not the answer I was hoping for but thanks anyway Andy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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