+ Reply to Thread
Results 1 to 5 of 5

Solid Trendlines in Excel 2013 and later

  1. #1
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    161

    Solid Trendlines in Excel 2013 and later

    I am unable to format a chart trendline as a solid line; it always shows as a dotted line.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,156

    Re: Solid Trendlines in Excel 2013 and later

    Can't you change the Dash type dropdown to show a solid line?
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Solid Trendlines in Excel 2013 and later

    I can, but when I click on the solid line radio button, the trendline is still a dotted line.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,156

    Re: Solid Trendlines in Excel 2013 and later

    And if you click the Solid line button first then change the Dash type?

  5. #5
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Solid Trendlines in Excel 2013 and later

    That was it, thanks. I'd never noticed this in older versions. Apparently the default dash type was a solid line.

+ 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. VBA EXCEL: Solid Code to add context help to a userform texbox
    By lhasha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2016, 01:44 AM
  2. [SOLVED] Open Excel and display minimal items with a solid background
    By chin67326 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2016, 04:31 PM
  3. Replies: 1
    Last Post: 12-27-2014, 11:20 PM
  4. Excel Trendlines and RSQ is there a Bug?
    By smkallakuru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-14-2011, 01:55 AM
  5. Excel 2007 : Solid conditional formatting Excel
    By okeefe87 in forum Excel General
    Replies: 2
    Last Post: 03-21-2010, 11:27 PM
  6. Trendlines in Excel
    By OPNorty in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-22-2005, 11:05 AM
  7. [SOLVED] Re: Logarithmic Trendlines in Excel
    By Quazz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-06-2005, 08:06 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