Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 150
Default Creating Excel chart sheet using C#

Hello,

I'm writing a tool using VS 2005 SP1 (C#) which processes some survey data
within Excel (2007). And have gotten the point where I need to create a chart
displaying some results. However, when executing the 2nd line of code below.
I get "Exception from HRESULT: 0x800A03EC." After lots of searching , etc, I
haven't been able to narrow down a cause. Any ideas?



Chart ch = (Chart)wb.Charts.Add(Type.Missing, (Worksheet)wb.Worksheets[1],
1, Microsoft.Office.Interop.Excel.XlChartType.xlXYSca tter);

ch.SetSourceData(ws3.get_Range("J2:K38",Type.Missi ng),
Microsoft.Office.Interop.Excel.XlRowCol.xlRows);


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
creating a percentage bar chart in excel pelican Charts and Charting in Excel 1 August 30th 06 04:31 AM
creating a excel spread sheet using ffinancial functions slide show Excel Worksheet Functions 1 September 8th 05 08:46 PM
Problems Creating html files with excel sheet Bigredno8 Excel Discussion (Misc queries) 1 July 5th 05 11:28 PM
creating a combobox dynamically on an excel sheet gupt New Users to Excel 8 June 7th 05 04:07 AM
Creating a pie chart in Excel Kelly Wagner Excel Discussion (Misc queries) 1 December 30th 04 12:35 PM


All times are GMT +1. The time now is 08:43 PM.

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

About Us

"It's about Microsoft Excel"