VBA, enter a stock code, will the stock yield HuaShe chart available within the month-CodePudding

As title, might use VBA what function? Best can give example, thank you! Now I will not use the array HuaShe chart

CodePudding user response:

Your data is available (sheet form already exists), or to grasp now?
If it is ready, with the chart, you can record a Duan Hong, then what all have

CodePudding user response:

Data is ready, can you say specific point? Obviously cannot record macro way,

CodePudding user response:

Since the data is ready, why can't record macro?

 Sub Macro1 () 
'
'Macro1 Macro 
'macro recording by MicroSoft, time: 2016/5/19 
'

'
Range (" C2: C16). Select "' this is a data column 
Charts. The Add '"' Add chart 
ActiveChart. ChartType=xlLineMarkers' "' choose line chart 
ActiveChart. SetSourceData Source:=Sheets (" Sheet1 "). The Range (" C2: C16) 
ActiveChart. The Location Where:=xlLocationAsObject, Name:="Sheet1" 
End Sub

CodePudding user response:

The

reference 3 floor Topc008 response:

since the data is ready, why can't record macro?
.

In my opinion, I'm afraid it is not ready-made data,

CodePudding user response:

The

reference 3 floor Topc008 response:

since the data is ready, why can't record macro?

 Sub Macro1 () 
'
'Macro1 Macro 
'macro recording by MicroSoft, time: 2016/5/19 
'

'
Range (" C2: C16). Select "' this is a data column 
Charts. The Add '"' Add chart 
ActiveChart. ChartType=xlLineMarkers' "' choose line chart 
ActiveChart. SetSourceData Source:=Sheets (" Sheet1 "). The Range (" C2: C16) 
ActiveChart. The Location Where:=xlLocationAsObject, Name:="Sheet1" 
End Sub

record macro, can't choose to input the date code?

CodePudding user response:

reference 5 floor as524 reply:

Quote: refer to the third floor Topc008 response:

Since the data is ready, why can't record macro?

 Sub Macro1 () 
'
'Macro1 Macro 
'macro recording by MicroSoft, time: 2016/5/19 
'

'
Range (" C2: C16). Select "' this is a data column 
Charts. The Add '"' Add chart 
ActiveChart. ChartType=xlLineMarkers' "' choose line chart 
ActiveChart. SetSourceData Source:=Sheets (" Sheet1 "). The Range (" C2: C16) 
ActiveChart. The Location Where:=xlLocationAsObject, Name:="Sheet1" 
End Sub

record macro, can't choose to input the date code?

After the chart generated can be modified by its data items to get new line chart...