+ Reply to Thread
Results 1 to 1 of 1

Add trendlines to all series in a chart with Toggle Button

  1. #1
    Forum Contributor
    Join Date
    03-26-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2013
    Posts
    128

    Add trendlines to all series in a chart with Toggle Button

    I am not having any luck with adding toggling trendlines on or off. Ideally, when the toggle is selected, trendlines would be added and once unselected they would disappear. My chart is modified with slicers, which can cause the trendlines to disappear, therefore, the code would have to recognize if trendlines are or aren't present and not throw an error or double up on the lines. I have several series in my chart and would need the trendlines to be formatted the same color as the respective series lines. Any help would be greatly appreciated. Thank you.
    Last edited by RaydenUK; 09-22-2015 at 10:43 AM.

+ 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. [SOLVED] toggle data series on/off on chart
    By xelhelp in forum Excel General
    Replies: 5
    Last Post: 12-08-2021, 04:23 AM
  2. Combining separate button functions into one toggle button 2011 office for mac
    By voidcreativ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2015, 09:28 AM
  3. Toggle Button on Workbook Open - value is True but button not pressed?
    By excelnat in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-03-2014, 11:23 AM
  4. Toggle Button Does not Toggle OFF when Clicked
    By robbfamily in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2014, 05:12 PM
  5. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  6. [SOLVED] Toggle Chart Series Objects On/Off
    By Raul in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-20-2006, 11:50 AM
  7. Trendlines and Data Series
    By T Valente in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-12-2005, 04:56 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