Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
fizbim
 
Posts: n/a
Default Using Microsoft Excel Chart object in VB6


I have added a "Microsoft Excel Chart" object to a form, then sized the
chart to fit the form. The chart has been modified to show the proper
axis labels, scaling, etc. In effect, creating the template.

The Excel Chart has a "Chart" tab and a "Sheet1" tab where the Sheet1
tab is the actual worksheet for the chart plot data. My problem is
filling in "THIS" worksheet with data from my array. I cannot find any
object reference to an Excel worksheet in my project. The Excel Chart
object only has parameters for height, width, top, bottom locations,
etc.

As a stab in the dark, I tried this code segment to attempt to fill the
worksheet with no success.

For r = 0 To 1400
Worksheets("Sheet1").Cells(r + 1, 1) = r
Worksheets("Sheet1").Cells(r + 1, 2) = TripData(1, r)
Next r

How do I access the worksheet portion of an Excel Chart object that has
been added to a form ?

Thanks,
Fiz


--
fizbim
------------------------------------------------------------------------
fizbim's Profile: http://www.excelforum.com/member.php...o&userid=25196
View this thread: http://www.excelforum.com/showthread...hreadid=386861

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
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet Graham Jones Excel Discussion (Misc queries) 1 May 13th 05 12:58 AM
Changing the format of an Excel output file made by Microsoft Access Amir Excel Discussion (Misc queries) 2 May 1st 05 12:57 AM
How do we generate Candlestick chart using Microsoft Excel? silver23 Charts and Charting in Excel 0 April 30th 05 11:32 PM
Microsoft Excel tries to load front page on opening Excel and Front Page Excel Discussion (Misc queries) 1 March 21st 05 09:51 PM
Adding a chart to a Word template linked to an Excel doc. Bobbie Excel Discussion (Misc queries) 0 January 3rd 05 09:07 PM


All times are GMT +1. The time now is 12:04 PM.

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"