PC Review


Reply
Thread Tools Rate Thread

Display Charts Created In Excel In A Windows Form

 
 
=?Utf-8?B?QXJ2aW5kdG4=?=
Guest
Posts: n/a
 
      15th Sep 2006
Hi,

I have several Excel files and each file has several Charts. I have a
requirement where i have to display the chart with data points in a windows
form.

In my WinForms code iam able to access the chart object through the
following code

Excel.ChartObjects chCharts =
(ChartObjects)oWorkSheet.ChartObjects(Missing.Value);
Excel.ChartObject chChart = chCharts.Item(1);

The problem is how do i use this ChartObject to be displayed in WinForm, I
tried using the AxChartSpace control, but iam not able to add this
chChartObject to it.

The idea is to re-use the charts that has already been created in excel
rather than to generate the chart dynamically in WinForms using AxChartSpace

I had been successfull in displaying the chart as an image in my WinForms
but this doesn't meet the requirement to display the Data Points for the
respective chart(i.e. if i move my mouse over a particular location in the
chart it doesn't show me a tooltip with values, as compared to my chart in
excel)

Thanks & Regards
Arvind T N
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I am not able to see charts created in excel 2003 in excel 2007 djinns Microsoft Excel Charting 1 1st Dec 2009 01:53 AM
Created Charts not appearing in Excel Tilly Microsoft Excel Charting 1 17th Sep 2008 05:15 AM
Charts created in Excel 2003 are not showing up in excel 2007 =?Utf-8?B?UkxhbmcwNw==?= Microsoft Excel Charting 1 25th May 2007 11:58 PM
Formatting Excel charts created with VBA neil@invidion.co.uk Microsoft Excel Programming 0 12th Jun 2006 01:19 PM
Embedding excel charts in my C# windows form =?Utf-8?B?TWF0dCBLb3Nvcm9r?= Microsoft Excel Charting 0 11th May 2005 06:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:25 PM.