You are logined,Please click reply OR ask tag,USER_ID:
Server is busy or in error, if still in problem, please send us email at support@
HKSTOCK
Below area will not be traslated by Google,you can input code or other languages
paste code or other language below=>click Code(Run code, select all=>click STEP icon=>click Code)
Current Browser:
Update your Chrome/Edge to >=130.0.0.0 version to get faster future/News data: Install/Update Chrome
I would like to know how to do a chart like the one I expect and label it "My expect Chart Here" attached in the examplechart.xls I am trying to do a VBA code for gernerating the chart exactly matched the chart of My expect Chart Here" with Chart Title of "Store-1". Now I am doing plot at Area Label of "Tesing Chart in VBA. SO I have several question to ask before completely generate the chart of "My Expect Chart here" for VBA coding without any Excel function help such as mouse drag for max and min the chart area or char size.
Question-1: How to add X-axis data in the chart for example, "Date" QUestion-2: How to add second,third,forth etc..for Y-axis data Is it using seriescollection(2), I tried but it has run-time error, What is it means that seriescollection(1), 1 or 2 means for What ? Question-3 How to set location of Chart Title of Store-1 and A-price and B-Price as the same spot in "My expect Chart here" chart Question-4 How to set the character size, font and blod in Tiel of Store=1 and A-price ? Question -5 How to set the time interval of Data at X-axis and number interval in Y-axis for A-price , for example, each 5 days and each 5 increment Question-6 How to set the color the line color and its width for A-Price and B-price Question-7 Is there good Chart tutorial website for suggestion for beginner Quesion-8, How to set the plot area location or size in Chart I search a lot information in website and try its example and always have run-time error that is why I would like to ask here for starting , Please Advise
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: teylyn replied at 2024-10-23 13:28:38
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: byundt replied at 2024-10-23 12:40:26
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 12:22:03
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 12:19:39
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 12:11:26
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 11:35:07
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 11:25:34
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: imnorie replied at 2024-10-23 10:59:51
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: imnorie replied at 2024-10-23 10:47:59
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Assisted Solution
Expert: imnorie replied at 2024-10-23 10:46:40
75 points EXCELLENT
Expert: byundt replied at 2024-10-23 10:43:05
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: byundt replied at 2024-10-23 10:34:41
Assisted Solution
Expert: imnorie replied at 2024-10-23 10:32:44
75 points EXCELLENT
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: byundt replied at 2024-10-23 10:27:41
Author: duncanb7 replied at 2024-10-23 10:27:36
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Accepted Solution
Expert: byundt replied at 2024-10-23 10:08:11
350 points EXCELLENT
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 09:16:30
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Expert: imnorie replied at 2024-10-23 08:59:11
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
Author: duncanb7 replied at 2024-10-23 08:47:12
I think I could find a lot of answer to my question and tutorial in macro recording. And before closing my question here. THe last question is
Even I delete all charts , but when I creat a new one chart, the activesheet.Chartojects(" Chart 5"). Activate, why it is not "Chart 1" because I already delete all charts. In the Macro recording, it also show "Chart 5" not "Chart 1"
免責聲明：以上資料僅作參考之用 computer28.com對以上資訊的準性和可靠性不能亦不會作 任何保證或承擔，並對資料或有關的錯漏或延誤而作出的任何 決定或導致的損失概不負責. Disclaimer: The above information is for reference only, computer28.com cannot and will not provide any guarantee or commitment for, and not responsible for any decision or loss caused by the information or related errors,omissions or delays.
