How do I get my graph to read varying source data?

[curtryan45]

I have line graph that will read from a group of numbers that will be changing in value and in length. For example, I have an input cell for users to input a value. Based on that value it generates a list of numbers. So say they enter 25, there will be a list of 25 values.

I want my line graph to display those values, no matter the length of the list. Thanks

 

[ravishankar]

HI
Assuming Col A has values for x axis and col B for y axis, insert the following codes in the macro window(alt F11 insert>module)

Sub Macro1()
Dim a As Integer
a = InputBox("enter the length of column")
  Range("A1:B" & a).Select
    Charts.Add
    ActiveChart.ChartType = xlLineMarkers
    ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B" & a), PlotBy _
        :=xlColumns
    ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet1"
    With ActiveChart
        .HasTitle = False
        .Axes(xlCategory, xlPrimary).HasTitle = False
        .Axes(xlValue, xlPrimary).HasTitle = False
    End With
End Sub

run the macro.