.Chart.SetSourceData Source:=Sheet3.Range("B2:C8,I2:I8"), PlotBy:=xlColumnshow to replace C8 and i8 with Sheet3.[ b2] .CurrentRegion.Rows.Count to connect
.Chart.SetSourceData Source:=Sheet3.Range("B2:C8,I2:I8"), PlotBy:=xlColumnshow to replace C8 and i8 with Sheet3.[ b2] .CurrentRegion.Rows.Count to connect
excel has a chart, line chart. assume that the data selection is Range ( "B1:B10 ") if cell B10 is empty, reads Sheet1.ChartObjects (1) .Chart.SeriesCollection (1) .values Times error. I guess the reason is the blank lines at the end of , for examp...
problem description the company needs to do some category ppt to show customers. I put the page made by echarts into ppt through the ppt development tool, and the page display can be called by clicking the mouse button. But in the actual display, they...
problem description this is my VBA code. The main thing is to create an object and upload the data to the Internet. There is no problem on window10, but when I run on Window XP, I find that although he does not have error, he does not respond. Origina...
I used vsto technology to develop a com add-in for PPT. one of the requirements is to add a custom menu button to the right-click menu. I finished writing on my computer, and there was no problem. but this error occurred when running on the customer ...