Consulting

Results 1 to 2 of 2

Thread: Referring to Trendline by name

  1. #1
    VBAX Newbie
    Joined
    Jan 2006
    Posts
    5
    Location

    Referring to Trendline by name

    I create a trendline and give it the name of "Trend_1"
    Later I want to delete/modify this line by referring to it by name (not index number which I think can change).
    Can I do this?
    Des

  2. #2
    VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location
    Perhaps something like this:

    [VBA] Worksheets("sheet1").ChartObjects(1).Chart.SeriesCollection(1) _
    .Trendlines.delete Type:=xlLinear, Name:="Trendline1" [/VBA]
    Peace of mind is found in some of the strangest places.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •