Set cht = ThisWorkbook.Worksheets(1).Shapes.AddChart2Ĭht.Chart. Set yData = ThisWorkbook.Worksheets(2).Range("B1:B" & LastRow_this) This is the code I have used Set xData = ThisWorkbook.Worksheets(2).Range("A1:A" & LastRow_this) I am having trouble figuring how to get the y-values to plot with the x-values instead of excel making two seperate lines on the chart. The values below 247 and between 263 to 455 in column A will have corresponding -1.75 in column B.Īlso I want to have title to my graph and X and Y axis labelled. It lets you visualize distributions, see. Analyse-it is a statistical analysis and regression tool for Microsoft Excel. Learning 4 day ago One of the questions I stumbled upon on an Excel Forum, is how to plot Scatter plots with names, values with different colors and some series with connecting lines. I am trying to take data off of a worksheet and create a scatter plot with lines and no markers in the same workbook different sheet using VBA. Free download microsoft excel labels pictures Files at Software Informer. I am trying to code for a Scatter Plot using smooth lines with VBA.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |