How do i insert charts in an excel sheet from vb 6.0

S

Srinivasan.K.S

Hi & Good Day All,

am using Visual Basic 6.0 / Windows 2000 / Office 2000
Am using excel 9.0 object for working with excel

Am populating the data from mdb file & i can save the file
add new sheets to the workbook, now i want to add / insert
a chart into a particular sheet with the range of data for
chart will be specified by me, how do i go about it....

reply asap......

thanx & warm regards,
srini
 
S

Steve Culhane [MS]

Srini,
Here's a KB article that should answer your question.

HOWTO: VB3: Create Excel Chart with OLE Automation from VB
http://support.microsoft.com/?id=112417

Hope this helps...

Stephen Culhane
(e-mail address removed)
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.




--------------------
| Content-Class: urn:content-classes:message
| From: "Srinivasan.K.S" <[email protected]>
| Sender: "Srinivasan.K.S" <[email protected]>
| Subject: How do i insert charts in an excel sheet from vb 6.0
| Date: Fri, 11 Jul 2003 23:36:16 -0700
| Lines: 14
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNIP+WNmucrZskmSOC+KAXCd/pSqw==
| Newsgroups: microsoft.public.office.developer.vba
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.office.developer.vba:16229
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.office.developer.vba
|
| Hi & Good Day All,
|
| am using Visual Basic 6.0 / Windows 2000 / Office 2000
| Am using excel 9.0 object for working with excel
|
| Am populating the data from mdb file & i can save the file
| add new sheets to the workbook, now i want to add / insert
| a chart into a particular sheet with the range of data for
| chart will be specified by me, how do i go about it....
|
| reply asap......
|
| thanx & warm regards,
| srini
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
How do I made data series visible or invisble in VBA 1
How do I find what is in a spreadsheet 5
Excel 2007 graphs/charts automatically populate with new data 1
How do you chart data from multiple sheets within a workbook? 3
Embedding Excel charts in PowerPoint 1
linking sheets and workbooks 0
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13

Top