[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
Go Back  Xtreme Visual Basic Talk > > > [VBA and VB 200507] How to export line chart to VB2005?


Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2008, 10:50 PM
abelchoo abelchoo is offline
Newcomer
 
Join Date: Jun 2008
Posts: 20
Default [VBA and VB 200507] How to export line chart to VB2005?


Hi,

I have a problem here. I have come up with the chart in excel, but am having trouble exporting it to VB2005. I have created it.

I would like to also ask, is it possible to communicate with the serial port using Excel 2007? I'm currently working on a student project which requires me to draw a line chart upon receiving data from a PIC controller through serial port. But am currently stuck. Don't know how to go about it.

Can someone point me in the right direction pls? Thanks!!
Reply With Quote
  #2  
Old 07-01-2008, 08:52 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Hi Abelchoo,

You can't export the chart as an object to our VB.NET application. I think that you would instead want to either:

(a) Export the data as an array of values, which you can then utilize as the source values for a chart control in your VB.NET App. Note that the Range.Value property will return a two dimentional array of values which you could pass into your program to use as data for your chart control.

(b) Export the Chart as a graphic, and then import that graphic. Here is a good example on how to do this: How to Excel 2007 Chart in VB.NET Picture Box.

Hope this helps...
Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005? [VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
 
[VBA and VB 200507] How to export line chart to VB2005?
[VBA and VB 200507] How to export line chart to VB2005?
 
-->