+ Reply to Thread
Results 1 to 2 of 2

Set default line chart weight globally

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    Set default line chart weight globally

    Hi:

    I would like to set the default Excel 2013 chart weight to 1pt for all and every line chart our team creates or edits ....

    We have a line chart crtx template file with lots of series which do the trick when a chart is initially created.

    But when a user adds an additional column of data to the sheet and extends the series selection to add the series to the existing chart the line that is added reverts to 2.25pt.

    Can I globally set the default line weight within the xltx template so that all line weights are 1pt, not 2.25pt?

    The line.crt we use works fine when initially selected and created, its when extra series are added later that the line is added with the incorrect weight.

    We could create a vba "standardise" button that would apply the line weight to all charts when the editing is finished, but why on earth can't we set the value as we want it to start with!!

    Excel has to pick up this default 2.25 value from somewhere (xml, theme?) but where?

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

    Re: Set default line chart weight globally

    I believe you need to continue with the crtx approach you just need to format 255 lines in the template.
    Cheers
    Andy
    www.andypope.info

+ 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. Changing Chart line default width
    By SolomonTadesse in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-12-2013, 02:12 PM
  2. Replies: 1
    Last Post: 05-05-2006, 05:35 PM
  3. [SOLVED] Create excel chart from LotusScript, change xlLine line weight
    By Roy Rumaner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2006, 11:35 PM
  4. Weight loss line chart to monitor weight loss progress
    By S Fox in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-08-2005, 01:15 PM
  5. [SOLVED] Chart Default Line colours
    By Phil Wales in forum Excel General
    Replies: 2
    Last Post: 06-13-2005, 01:05 PM
  6. Default Line Weight in Excel
    By KCollard in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-30-2005, 10:06 AM
  7. How can i change the default line weight in an excel chart
    By Nigel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-29-2005, 11:06 PM
  8. How can i change the default line weight in an excel chart
    By NPG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-29-2005, 11:06 PM

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