Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
Hi, All: I am getting crazy about this error. I tried everything but no help at all. Here is the simple task I want to do: adding a chart. The code is as below: Charts.Add ActiveChart.ChartType = xlXYScatterLines Set myrange = Worksheets("Sheet1").Range("B16:B18") ActiveChart.SetSourceData Source:=myrange, PlotBy:=xlColumns ActiveChart.Location where:=xlLocationAsObject, Name:="Rates" It always … |