Every time a EXCEL data inside test results data (such as: detailed data), we need to use VBA to make a scatterplot (such as: sheet1) effect, please grant instruction!!!!!!!!!!

CodePudding user response:

http://club.excelhome.net/thread-455423-1-1.html

CodePudding user response:

Caozhy, hello, connection accessories can not open, under the new registered users also not, would it be convenient for you to give us a? Thank you [email protected]

CodePudding user response:

You record a Duan Hong, then it is ok to modify a little bit about the...

CodePudding user response:

For example:

 Option Explicit 

Sub Macro1 () 
'
'Macro1 Macro 
'macro recording by MicroSoft, time: 2017/3/1 
'

'
Range (" D2 "). Select 
Charts. The Add 
ActiveChart. ChartType=xlXYScatter 
ActiveChart. SetSourceData Source:=Sheets (" Sheet1 "). The Range (" A1: A26 "), PlotBy:=xlColumns 
ActiveChart. The Location Where:=xlLocationAsObject, Name:="Sheet1" 
End Sub 

.