#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 354
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 354
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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




  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 354
Default 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







  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Chart - determining the color of a chart style Shane Devenshire[_2_] Charts and Charting in Excel 1 February 6th 10 04:09 AM
Change Chart Properties for Multiple Chart Shts using a Worksheet KUMPFfrog Charts and Charting in Excel 0 July 22nd 09 11:01 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Charts and Charting in Excel 2 March 6th 09 04:43 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Setting up and Configuration of Excel 1 March 6th 09 01:57 AM
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? lpenndorf Charts and Charting in Excel 1 February 7th 07 04:32 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"