add a target line to a chart

**justlearning123** · 08-25-2015, 10:57 PM

currently I am making a chart in VBA and I am trying to get a target line. I have a code that works but it uses a range and they are always the same number
is there a way to code it so it just looks at 1 cell so I don't have to have the same number in every cell in the comuln? sorry if this sounds confusing! heres what I have noe

With ChrtSrs3
         .MarkerStyle = xlMarkerStyleNone
         .Name = "Target"
         .Values = Range("R6:R66")
        .XValues = Range(Cells(x, 1), (Cells(Y, 1)))
     End With

**Kaper** · 08-26-2015, 05:29 AM

Try:

Dim myvals(1 To 2) As Double, myXvals(1 To 2) As Double
myvals(1) = 3 'of course here values you'd put in R column
myvals(2) = 3
myXvals(1) = 1 'and here Cells(x, 1)
myXvals(2) = 6 ' and Cells(Y, 1)
With ChrtSrs3
         .MarkerStyle = xlMarkerStyleNone
         .Name = "Target"
         .Values = myvals
         .XValues = myXvals
End With

add a target line to a chart

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

add a target line to a chart

Re: add a target line to a chart

Thread Information

Users Browsing this Thread

Similar Threads

How to add target line to stacked column pivot chart chart

Target line in chart

Adding target line to a chart

create chart with target line

Insert a target line to a chart

Target Line on Chart

target line in bar chart

Chart Target Line

Bookmarks

Bookmarks

Posting Permissions