Sunday, 15 August 2010

excel - How to graph a specified range with VBScript -


I have Excel Sheet with 5 columns in it. I want to use VBSPTech in graph data from only one column A, D and E

Currently, using the code given below, I add all 5 columns. Please advise in advance and thank you.

 . With Active Chart. Ends with Setsource Data (Source: = ObjsLSworkSheet.Range ("A: A" and Ultimate RAOFOA, "D: D" and Final RowOff D, "E: E & amp; LastRowOfE)  Try to use  Union   

 < Code> ActiveCart with.SetSourceData.The application (objXLSWorkSheet.Range ("A1: A" and the final rouffa), objXLSWorkSheet.Range ("D1: D" and "Landroff"), objXLSWorkSheet.Range ("E1: E "And LastRowOfE))  

No comments:

Post a Comment