Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
Chart in VBA
Modifyand 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
Duncan
Attachment:examplechart.xlsexamplechartimage.bmp
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
