The below code below all works except I can't get the range to be a real range, it inserts the actual words xminRange xmaxRage etc into the range fields for the chart
Here is what I am trying
Code:
Dim xminRange As String
Dim xmaxRange As String
Dim yminRange As String
Dim ymaxRange As String
xminRange = "Milestones!V$10"
xmaxRange = "Milestones!V$22"
yminRange = "Milestones!S$10"
ymaxRange = "Milestones!S$22"
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(1).XValues = "xminRange:xmaxRange"
ActiveChart.SeriesCollection(1).Values = "yminRange:ymaxRange"