Chart - VBA
 

Hi all,
Does anyone know creating,updating,and deleting the exisiting chart in a
worksheet "abc".

I have no ideas about these after trying so many times.

Ur help will be appriciated.
Thank you.
Best regards,
Ocurnos

Chart - VBA
 

what i am trying to tell is by using VBA to create,update, and delete the
existing chart. (not manual way)

"Daniel" wrote:

Hi all,
Does anyone know creating,updating,and deleting the exisiting chart in a
worksheet "abc".

I have no ideas about these after trying so many times.

Ur help will be appriciated.
Thank you.
Best regards,
Ocurnos

Chart - VBA
 

Turn on the macro recorder and make the changes manually.

Then turn of the macro recorder and examine the recorded code. That should
give you some ideas.

--
Regards,
Tom Ogilvy
"Daniel" wrote in message
...
Hi all,
Does anyone know creating,updating,and deleting the exisiting chart in a
worksheet "abc".

I have no ideas about these after trying so many times.

Ur help will be appriciated.
Thank you.
Best regards,
Ocurnos

Chart - VBA
 

Hi Daniel.

See Jon Peltier's site at:

http://peltiertech.com/Excel/ChartsHowTo/index.html

See particularly the VBA section at the foot of the page.

---
Regards,
Norman



"Daniel" wrote in message
...
Hi all,
Does anyone know creating,updating,and deleting the exisiting chart in a
worksheet "abc".

I have no ideas about these after trying so many times.

Ur help will be appriciated.
Thank you.
Best regards,
Ocurnos

Chart - VBA
 

Here's a good start:
http://msdn.microsoft.com/library/de...latecharts.asp
--
- K Dales


"Daniel" wrote:

Hi all,
Does anyone know creating,updating,and deleting the exisiting chart in a
worksheet "abc".

I have no ideas about these after trying so many times.

Ur help will be appriciated.
Thank you.
Best regards,
Ocurnos

Chart - VBA
 

thanks guy

"Norman Jones" wrote:

Hi Daniel.

See Jon Peltier's site at:

http://peltiertech.com/Excel/ChartsHowTo/index.html

See particularly the VBA section at the foot of the page.

---
Regards,
Norman



"Daniel" wrote in message
...
Hi all,
Does anyone know creating,updating,and deleting the exisiting chart in a
worksheet "abc".

I have no ideas about these after trying so many times.

Ur help will be appriciated.
Thank you.
Best regards,
Ocurnos