+ Reply to Thread
Results 1 to 2 of 2

Edit lines on line chart to be all uniform

  1. #1
    Registered User
    Join Date
    10-03-2020
    Location
    Manchester, England
    MS-Off Ver
    office 2016
    Posts
    1

    Edit lines on line chart to be all uniform

    Hi

    I need all the end points on the lines on a line chart to all look the same.

    I've 38 lines, with only a beginning and an end point (assessment score pre-clinic and post-clinic) they all were assigned different colours.

    I've gone through and selected each one in turn and changed it black

    But they all have different colours/ end shapes and they need to be the same

    Please could someone tell me (step-by-step) what the easiest way is to do this?

    Thanks

    Jill

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Edit lines on line chart to be all uniform

    You could use VBA, by first recording a macro to do it once. Post that Macro here and we can assist in re-creating it for all lines.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-10-2016, 11:17 AM
  2. Trend lines- Line chart
    By geraldccole in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2016, 02:37 PM
  3. [SOLVED] Setting line chart settings in VBA for unspecified number of lines in a chart
    By Vegiepie2016 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2016, 07:30 AM
  4. Replies: 2
    Last Post: 11-14-2012, 08:59 AM
  5. How to stop lines in a line chart?
    By nickFe in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-08-2011, 12:51 AM
  6. [SOLVED] I can't get any lines in my line chart
    By Alex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2006, 11:05 PM
  7. get edit mode on data lines in chart wizard
    By jdbruss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-27-2005, 11:05 AM

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